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 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply