Make Bulk Changes to DTSX package?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Make Bulk Changes to DTSX package?

Make Bulk Changes to DTSX package?

Rate Topic

Display Mode

Topic Options

Author

Message

CptCrusty1

Posted Wednesday, December 05, 2012 2:21 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 1:17 PM
Points: 158, Visits: 252

I have a DTSX package with probably... hmmmm....50 steps. For development purposes, everything was written to a temporary database/schema called "Sandbox.Ellis". All objects are created in that db.schema thus, it's now time to migrate to production. In the past I haven't had nearly as many steps. To avoid having to open every stinkin' once of these containers, is there a way to make a bulk change?

Thanks In advance.
Crusty.

Post #1393213

Evil Kraig F

Posted Wednesday, December 05, 2012 2:25 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:03 PM
Points: 5,658, Visits: 6,099

Yes, but you have to prep to do it from the start, using configurations. However, in theory, you should only need to change the Data Source object. What steps do you have that are avoiding the Data Source?

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions | Forum Netiquette
For index/tuning help, follow these directions. |Tally Tables
Twitter: @AnyWayDBA

Post #1393219

CptCrusty1

Posted Thursday, December 06, 2012 6:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 01, 2013 1:17 PM
Points: 158, Visits: 252

In this example I'm pushing lots of flat files into lots of tables. They're all in the Sandbox.Ellis db/schema. When I open the OLE DB Destination container, I see that I'm using the OLE DB Connection called Sandbox, but it's not specific to a schema. The table name I'm pointed to has the Schema and the table name. If I create a new OLE DB connection with the new db as well as the schema...... Not sure if that's going to work.....

Crusty..

Post #1393495

Evil Kraig F

Posted Thursday, December 06, 2012 11:06 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 6:03 PM
Points: 5,658, Visits: 6,099

The only way I can think of modifying the schema components is to open it as XML, find/replace, then reload the XML. Sorry, I just brainfarted on the fact that you can't schema hook in the OLE DB component yesterday, I almost never use schemas.

Post #1393657

« Prev Topic | Next Topic »

Permissions