Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Refresh metadata in SSIS (200 packages) programmatically ?
158 views
Skip to first unread message
M Bourgon
Nov 18, 2010, 5:13:43 PM11/18/10
to
Howdy. We have a table, used across the enterprise, which has a field
which is going from varchar(8) to varchar(15). Given that we have 200
SSIS packages that reference this field in some way (most through data
pumps), is there some way to programmatically (powershell, C#, VB,
Perl, etc) take the package and refresh or change the metadata in SSIS
to reference the new size? I'd love to be able to do it in advance of
doing the ALTER TABLE, but that's not mandatory. We could export each
package, munge, then import (SQL Mag has a tool to import/export), but
if there's some way to modify it that would be awesome.
which is going from varchar(8) to varchar(15). Given that we have 200
SSIS packages that reference this field in some way (most through data
pumps), is there some way to programmatically (powershell, C#, VB,
Perl, etc) take the package and refresh or change the metadata in SSIS
to reference the new size? I'd love to be able to do it in advance of
doing the ALTER TABLE, but that's not mandatory. We could export each
package, munge, then import (SQL Mag has a tool to import/export), but
if there's some way to modify it that would be awesome.
Many thanks,
M
ing.ernest...@gmail.com
May 8, 2013, 3:45:56 PM5/8/13
to
Same problem if someone find an answer please let us know
0 new messages