May 6, 2011 at 12:00 pm
We have some SSIS packages on one server. We are request to migrate these packages from it to another server.
We do not have any information on these packages, such as dtsconfig files. What is the best approach in implementing it?
Many thanks in advance for any input.
May 6, 2011 at 12:27 pm
SQL ORACLE (5/6/2011)
We have some SSIS packages on one server. We are request to migrate these packages from it to another server.We do not have any information on these packages, such as dtsconfig files. What is the best approach in implementing it?
Many thanks in advance for any input.
Crack them open in BIDS/VS of the right version, check under SSIS-Configurations and see if any are setup, and check the bottom and go through each connection for all non-config'd ones and review what servers they look at.
No easy button on this one, you've got to get into the designer.
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
May 9, 2011 at 12:26 pm
Also keep in mind that you can export the packages to xml files and then do a search/replace using a text editor and then re-import. Perhaps this could help depending on the specifics of your packages.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply