May 6, 2012 at 8:01 am
I you add columns to a table and delete them will it mess up the mapping?
If you open up the package and you get the warning, close the table, remove the column and reopen the package do you have to click on mapping to correct the out of sync issue (metadata?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 7, 2012 at 12:39 am
Don't know the answer by heart, but you can easily test this yourself.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 7, 2012 at 12:59 pm
My experience is that adding columns or deleting columns that aren't otherwise used has no effect on the download process. When you open the SSIS package in design mode, however, you do get the warning icon. It's simply a matter of the destination and clicking on mapping and then okay to remove it.
May 7, 2012 at 3:01 pm
It was not consistent as far as having to remap which was a good case because it could have effected thousands of transformations.
I had to remap several and redeploy the SSIS Packages.
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply