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?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.|||Save the package in Visual basic File then edit it.
And you can re-create the package from the Visual basic File.|||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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment