May 3, 2012 at 7:53 am
We have a SSIS package that imports a large flat file (amongst other things). A coworker of mine is doing a completely different project with the same flat file, and would like to know the column mappings. Is there a way to extract this information from the editor? I can see the mappings on my screen, but don't know how to get the information to my coworker (she doesn't have access to SSIS). And now that the issue is brought up, the column mappings for this file should be stored someplace besides just in the one spot.
Any ideas?
Thank you.
May 3, 2012 at 8:46 am
If you're just looking for documentation purposes, I've just opened the OLE DB Destination (or whatever destination you're using in your Data Flow Task) and did a screen capture with the snipping tool on the Mappings to show the Input Column and the Destination Column.
Not great, but it does show what went where.
This is all be inside the XML of your .dtsx file as well, but I don't know how to easily extract it in a usable format.
HTH,
Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply