Wednesday, June 6, 2012

Dumping CSV files to SQL tables.

Select Import and Export data, by using this you can export any type of datas to your tables.

If you are using window authentication while accessing the tables then you should open this tool by the corresponding net user.

C:\Users\philip\Desktop>runas /netonly /user:DOMAIN\USERNAME "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTSWizard.exe"
Enter the password for DOMAIN\USERNAME :

No comments:

Post a Comment