Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
 Posted - 2009-05-10 : 11:49:45
|
| I have a OLEDB source -> Flat File destination.I have selected 10 columns out of 15 columns(in the table) that I need in the flat file.The question is, If I have to add a new column to the table itself, should i change my package to specifically "uncheck" the new column I have added to prevent it from coming in the Flat File destination.Or I dont have to do anything? Will it cause any errors/warnings during execution? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-10 : 12:55:05
|
| if you're adding a new column to the table, the column wont be added to package by default. so unless you want it to be included in flat file, you dont need to edit package. metadata of ssis wont change dynamically based on changes in source table structure. however if you're dropping an existing column, you need to edit package also to refresh metadata else it will complain of non existent column. |
 |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-05-10 : 23:08:08
|
| This is great news. Thanks much. |
|
|
|
|
|
|
OLE DB Source question