August 8, 2011 at 3:49 pm
Guys need help/advise,
I created Package that has 12 data flows in all data flows I am using SCD Transformation. This package is in my local machine. I want to transfer this package in Client Machine. In client machine I am gonna use new source (same structure and table name) and new destination (same table and fields). I don’t want to create this package in client machine from scratch. I heard you can do through Configure the package. I tried but didn’t work out mean I didn’t success. I know how to configure package. I want to know what steps I should use on client machine. I am using sql server 2005. Thanks for help.
August 8, 2011 at 4:14 pm
rocky_498 (8/8/2011)
Guys need help/advise,I created Package that has 12 data flows in all data flows I am using SCD Transformation. This package is in my local machine. I want to transfer this package in Client Machine. In client machine I am gonna use new source (same structure and table name) and new destination (same table and fields). I don’t want to create this package in client machine from scratch. I heard you can do through Configure the package. I tried but didn’t work out mean I didn’t success. I know how to configure package. I want to know what steps I should use on client machine. I am using sql server 2005. Thanks for help.
Make your life easier until you're used to working with this and use an XML file for the configuration. Then, in the configuration screens, go to the sources and turn on servername and initial catalog.
Make a copy of the XML file, and adjust the names as required. they should be pretty easy to determine by the XML attribute names. Deploy both XML and package to target server.
Once done, you'll have to re-align the XML file if the folder pathing isn't exactly the same (or you don't have environmental variables deal with this) via the designer on the target system, but that's it.
Without configurations, or without dealing with all the setup of environmental variables, you're going to have to edit the package for the foreign machine somewhere, but this is usually one of the easiest ways.
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
August 9, 2011 at 8:45 am
Thanks for help. I config my package on my machine and copy it to client machine, Here is my problem, i want to know how i can change my xml that i transfer to my client machine? Any help would be great. Thanks.
August 9, 2011 at 12:00 pm
rocky_498 (8/9/2011)
Thanks for help. I config my package on my machine and copy it to client machine, Here is my problem, i want to know how i can change my xml that i transfer to my client machine? Any help would be great. Thanks.
Open it (the XML file) in any text editor and change the values inside the XML attributes. Can do it with notepad.
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