December 5, 2012 at 2:21 pm
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.
December 5, 2012 at 2:25 pm
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?
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
December 6, 2012 at 6:55 am
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..
December 6, 2012 at 11:06 am
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.
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[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply