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?