question

p0peye avatar image
p0peye asked

SSIS Package: Dynamic metadata mapping before it runs

I have a simple SSIS package which will load data from a source to destination (say from ServerA to ServerB). To achieve this, I have used data flow task with OLEDB source & destination task and updated mapping for them. This approach works fine. But the problem with this approach is, whenever there is a change in data type or column names or introduction of new column, I have to touch the package. My question, is it possible to design a package in such a way that any changes will take care automatically by itself. i.e. I will have a kind of lookup tables where I will define the source and destination mapping details based on which the SSIS should perform the data flow execution. Is this really possible?
packagessis-2008complex-package
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Sule avatar image
Sule answered
Maybe this would be helpful [ https://gallery.technet.microsoft.com/scriptcenter/Dynamic-SSIS-Generation-to-ccbab86b][1] [1]: https://gallery.technet.microsoft.com/scriptcenter/Dynamic-SSIS-Generation-to-ccbab86b
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.