-
Data transfer automation
Hi All,
I am uisng SQL Server 2000. I need to transfer tables in about 116 databases from AS400 to SQL Server.Is there anyway to automate this? right now I am creating DSN for each data source and using DTS to import tables from each data base. This work is too much for 116 databases. What is the approach I need to take in order to automate this task? Your help is greatly appreciated
Thank you,
Sam
-
You can run dts packages as sql job.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|