Results 1 to 3 of 3

Thread: Merge DTS packages

  1. 01-30-2003, 11:04 AM #1
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

    Question Merge DTS packages

    I have 14 DTS packages with same connection name in all of them.

    each DTS has atleast 7 transformation task.

    Is there anyway I can merge all the DTS packages to one single DTS package?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  2. 01-30-2003, 11:35 AM #2
    JBane
    JBane is offline Registered User
    Join Date
    Dec 2002
    Posts
    181
    Mak,
    You might save them all as VB files then do some cutting and pasting.

    Jeff
    Reply With Quote Reply With Quote
  3. 01-30-2003, 11:44 AM #3
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Thanks Jeff.

    But I have to do a lot of editing cas' it creates same task names.

    any easier way?
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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