Results 1 to 2 of 2

Thread: Data transfer automation

  1. #1
    Join Date
    Jul 2010
    Posts
    1

    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

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    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
  •