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 |
|
Hommer
Aged Yak Warrior
808 Posts |
 Posted - 2007-09-19 : 17:10:14
|
| Hi, all,How do you refresh a SSIS pkg to get the latest table schema change?I have this data flow task that will load data from a flat file into a table.I got a Warning: Truncation may occur due to retrieving data from database column "txtSNumber" with a length of 50 to data flow column "txtSNumber" with a length of 20. Then I went into Management Studio and changed the column size.Now in my dev BID I got next:[SQL Server 05[82]] Warning: The external metadata column collection is out of synchronization with the data source columns. The column "txt..." needs to be updated in the external metadata column collection. I think this means my change on the table did not get into my ssis, and I could not find a way to refresh.Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-19 : 23:19:30
|
| I think you need edit the package. |
 |
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-09-20 : 09:05:41
|
| I am in the package in design mode, and I am not talking to refresh AFTER the deployment.Could you be more spesific? Thanks! |
|
|
|
Hommer
Aged Yak Warrior
808 Posts |
Posted - 2007-09-20 : 11:05:39
|
| I found it. Double click the component with the yellow triangle exclamation mark. |
|
|
|
|
|
|
refresh SSIS pkg to get the change