Handling datatype changes after deployment SSIS

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Data Warehousing » Integration Services » Handling datatype changes after deployment...

Add to briefcase

Handling datatype changes after deployment SSIS

Expand / Collapse

Author

Message

Posted Wednesday, October 10, 2012 1:16 AM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 7:42 AM
Points: 1, Visits: 104

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.... Smile

Smile

Post #1370727

Scott Murray-240410

Posted Thursday, October 11, 2012 4:36 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 5:22 AM
Points: 159, Visits: 2,207

You will need to go to the package to update the metadata. Otherwise you will get validation errors.

Post #1371339

Posted Friday, October 12, 2012 2:29 AM

SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 4:23 AM
Points: 842, Visits: 741

Agree. cant think of any way round it.

Ian Cockcroft
MCITP BI Specialist

Post #1371944

« Prev Topic | Next Topic »

Add to briefcase

Permissions

Expand / Collapse