Hi Experts

I'm newbie to SQL Server 2005, how can i import a csv file on a table.

Earlier version the SQL Server 2000, there was a facility to import or export by right on the table and it will "all task" and then will able to choose the import data and it will load a DTS wizard. How can this be done on SQL Server 2005 Enterprise Edition.

I tried to check on SSMS but no luck.

Can anyone guide to the right direction?

Kind Regards
Bhavesh

Bhavesh,

You can use the SSIS Import/Export wizard.

Find it here: C:\Program Files\Microsoft SQL Server\90\DTS\Binn

DTSWIZARD - right click, pin it onto your desktop

Thanks for your reply.

I do not have import Data or export data under Tasks Menu. Just to let you know that i have download the SSMS (free version) from Microsoft downloads and I am accessing the MS SQL Server 2000 database through the SMSS tool.

On my development server i have installed MS SQL Server 2005 and the SMSS Application that was part the SQL Server 2005 CD gives me this option for import data and export data for both databases the one on v2005 and v2000.

I need to intall additional programs of SQL Server 2005 that will enable me to access all the features of SMSS Application.

Any further assistance will be appreciated.

Kind Regards
Bhavesh

The downloadable Management Studio(SQL Server Management Studio Express Edition -SSMSEE )is a light weight tool and it will not have all the features offered by the full version of the tool. What you need to do is, if you have Enterprise Edition or any licensed edition cd install the tools (workstation components) from the CD you will have Import/Export wizards.

Madhu

SQL Server Blog

SQL Server 2008 Blog