So now I just need one task to do everything, I just need to store the mappings in my table.
Perhaps a bit sarcastic, but still....nice solution!
Hi Jonathan,
Nope... You can store your mappings anywhere you like! Could even be an XML file. The point being that storing the mappings outside of the code makes them configurable. It just happened to be the case that the mappings table was already there, having been used by the DTS 2000 package before the migration.
Regards,
Hiske
Huh. so I can make the BA team create and manage the file with the mappings, and I can just run it. I like this idea even better......thanks!
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses