June 29, 2009 at 2:36 am
I have create one dtsx package to export data into text file. When I want run this i wat set server at runtime how can I do this?
June 29, 2009 at 9:48 am
June 29, 2009 at 12:04 pm
or, global variables, a settings XML file....lots of possibilities....
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?
June 29, 2009 at 4:06 pm
I agree, there are lots of ways to handle this, package configurations is the place to start. You can do it with:
1. Registry entry.
2. dtsConfig files.
3. A table
4. Environmet variable.
5. Passed from a parent SSIS job.
In 2005 you can also specify that the location is specified in an environmental variable.
Lots of places and lots of choices.
CEWII
June 29, 2009 at 10:44 pm
I have 3 systems and corresponding to that having 3 servers like A, B, C
and am having one database X in each server
I have created one dts package to export data to text file on Server A.
Here this package is running good.
but am unable to run this in Servers B and C.
How can I run this in B and C servers?
Thank you,
Santosh
June 30, 2009 at 9:22 am
You are 'unable' to run it on your other 2 servers? What does 'unable' mean? Do you get errors, do you not have access to the servers?
Create a pacakge configuration and configure it to hold the servername parameter for your connection manager. This will allow you to change the config file to point your package to a different server. Otherwise, you're stuck with the server name that you've hard coded (by configuring it in BIDS) into your package's connection managers.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply