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 |
|
shantheguy
Starting Member
22 Posts |
 Posted - 2012-10-10 : 03:11:00
|
Hi All,I have created a ssis project and deployed it to the server. And after the deployment has been done, some of the datatypes of the table columns are to be changed. If i change the datatypes there could be some metadata mismatch in the package. So how can i fix this without going into the package. Thanks in advance....  |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-10-11 : 00:23:32
|
| you cant. ssis cant change metadata at runtime. So you need to redesign package using new datatypes. Between are new datatypes compatible with earlier ones or entirely different?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Handling datatype changes after deployment SSIS