cdjohn31
asked on
MS SQL server express 2005
Just installed this package. Was expecting to see some data import/export utilities such as DTS but nothing there. What solutions are available to me
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1) Download the Microsoft SQL Server 2005 Express Edition Toolkit (223.9 MB) at:
http://go.microsoft.com/fwlink/?LinkId=65111
2) Run "C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWiza
For BCP, you can use similar query as below:
BULK INSERT MyTableName FROM 'C:\Documents And Settings\Me\My Documents\MyFile.csv'
WITH (FIELDTERMINATOR = ',');
GO