Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2003
    Posts
    15

    Post Unanswered: Saving DTS Packages

    I am building packages to migrating data from Sybase to SQL Server; however, I have problem saving my packages when it is selecting from a large table. It takes a long time for it to save, but if I limit the script to a small subset, it save faster.

    Is there an option to disable the SQL Server Enterprise Manager to run the query against the db on a save?

  2. #2
    Join Date
    Sep 2003
    Location
    Dallas, Texas
    Posts
    311

    Re: Saving DTS Packages

    You can uncheck the Run Immediately option and just check the Save. This will only save the package without actually running it.

  3. #3
    Join Date
    Oct 2003
    Posts
    15
    Sorry, I am new to this. Where is that option?

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's the source (Access?) And it's across the Network?

    Yeah I had that problem...I created a shell empty access db, and it's quick...I thought is was because of the large number of objects, and had to spin through the collection to "find" that table.

    But yours sounds different...are you sure it's the volume of data?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Oct 2003
    Posts
    15
    On the Source Tab of the DTS Properties, I added the where clause to look for only one record and it saves immediately. The script is doing a select from a Sybase environment and pump into SQL Server.

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    How are you creating the dts package - Import/Export wizard, dts editor, vb ?

  7. #7
    Join Date
    Oct 2003
    Posts
    15
    I am building the packages in the dts editor.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •