Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1

    Unanswered: Save/Copy column mappings in DTS?

    Is it possible to save column mapping definitions from a Transform Data Task? The practical use is I have four tables with very similar layouts of which 200 or so columns are identical. I have various front and back office applications that require local copies of this data in various formats. It is EXTREMELY tedious to remap all of the columns for each Transform Data Task required on these applications.

    Is there a way to store all of the column mapping def's and import them into a new transform data task?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    if you are using SSIS, the task itself is an xml file so you could just edit it directly...

    EDIT: did I say task? I meant the package is an xml file.
    Last edited by jezemine; 02-20-07 at 23:53.

  3. #3
    Join Date
    Feb 2007
    Posts
    38
    Save the package in Visual basic File then edit it.
    And you can re-create the package from the Visual basic File.

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I should have mentioned this is sql 2k I suppose. I haven't toyed with saving packages as vb scripts yet, I'll give that a go and see what sort of damage I can do.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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