Link to home
Start Free TrialLog in
Avatar of cdjohn31
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
Avatar of seenuforall
seenuforall
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of geek_vj
geek_vj

You can use either BCP or Toolkit for accomplishing this task - Here are the details

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\DTSWizard.exe"

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