Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSIS - copyied original package, changed name, but still reading original dtsConfig file


SSIS - copyied original package, changed name, but still reading original dtsConfig file

Author
Message
cgivens
cgivens
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 27
I have an SSIS package, that I did not write. It is used to transfer production data from a configurator to a production MRP system. I copied the origin QuoteTransfer.dts to QuoteTransferDEV.dts so that it would flow from development configurator package to development MRP system. However when I did that it still reads from the QuoteTransfer.dtsConfig rather than QuoteTransferDEV.dtsConfig. Does anyone have any suggestions? I checked all the variables, but I just don't see where it points to the file.

Thanks in Advance

Charles

SQL 2008
John Mitchell-245523
John Mitchell-245523
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7532 Visits: 15175
Charles

The config file is specified by right-clicking on the design surface in BIDS and choosing Package Configurations. You can specify a different config file at run-time when running a package through the command line or a job step (and, I think, with the Package Execution Utility).

John
cgivens
cgivens
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 27
Thanks John, I will look at that.

I did find that it is using a variable called QTE_XFER_Config. However, when I review the variables it is not in there. When I do the Package Configuration that variable shows up, but has nothing in it. Does it default to a name somehow?

Still looking

Thanks

Charles
John Mitchell-245523
John Mitchell-245523
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7532 Visits: 15175
Charles

Not sure I understand. If your variable takes its value from the config file, you should have a line something like this in the file:

<Configuration ConfiguredType="Property" Path="\Package.Variables[User::MyVariable].Properties[Value]" ValueType="String">
<ConfiguredValue>MyValue</ConfiguredValue>

Do you have anything like that?

John
cgivens
cgivens
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 27
John,

I don't have anything in the QuoteTransferDEV.dtsConfig file for that line. That is what is confusing. I would assume that a variable pointing to a dtsConfig file wouldn't be in the dtsConfig file. As this QuoteTransferDEV.dtsConfig is pulling up the QuoteTransfer.dtsConfig, even though I have the appropriate config file.

It is confusing.

Thanks

Charles
John Mitchell-245523
John Mitchell-245523
SSCertifiable
SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)SSCertifiable (7.5K reputation)

Group: General Forum Members
Points: 7532 Visits: 15175
Charles

You're right - you don't set the location of the config file in the config file. See my first post above for how you do that.

John
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search