Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Script to automate DTS process

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-15 : 07:51:51
Sunil writes "Hi,
I'm a newbie.. Can anyone provide me with a test script to automate the DTS process? I've data coming from flat files(.csv), I need to write a script that converts them into tables in my SQL Server Database.

Thanks in advance.
Regards
Sunil"

JimL
SQL Slinging Yak Ranger

1537 Posts

Posted - 2005-06-15 : 08:02:51
Sunil you might want to look up Bulk transfer in Books On Line. Also If you have enterprize manager it has a wizzard, this is the easyist way to create this type of application.

Jim
Users <> Logic
Go to Top of Page
   

- Advertisement -