hi, i need to convert a .txt file to database format..so i found about this great utility "Import and Export Data" wizard in SQL server..it does the job when i do it manually through the wizard, but is there any way that it could do the same operation automatically, and is it possible to include the code in a java program?

another thing.. Oracle provides a similar utility "SQL Loader" for the same kind of task, so any ideas which one is better? better in terms of speed, portability, memory usage, etc?

You can save the DTS package and schedule it to run when ever you want.

I have a similar problem and cannot schedule a DTS, because my .csv files are created dynamically, and only exsist for long enough to do my updates. What I need is some sort of SQL command to run a DTS Package, and be able to view any errors.