Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deployed package is not picking up dtsconfig file Expand / Collapse
Author
Message
Posted Wednesday, February 6, 2013 3:17 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:34 AM
Points: 386, Visits: 624
Still learning SSIS.
I have built a really simple package in BIDS2005

SMTP server connection
SendMailTask

Sends me an email (bob@myaddress.com) - Works a treat in BIDS

Build puts a copy of the dtsx in the Bin folder. Copied to the server and ran with DTEXEC - works a treat.

In BIDS, Package configuration to get the TO address from the XML (fred@myaddress.com)

Run from BIDS - works a treat

Build puts the dtsx in the Bin folder, but not the dtsconfig

Copy the dtsx from Bin and the dtsconfig from the project folder(i have put them in the same folder)

Run with DTEXEC - Sends the email to Bob@myAddress.com, NOT Fred@myAddress.com


What have I done wrong?
Post #1416362
Posted Wednesday, February 6, 2013 3:31 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:34 AM
Points: 386, Visits: 624
OK, update.

opening the dtsx in notepad on the deployed version shows the dtsconfig path as being the full path of my laptop (the development machine). When I change the path to the server path, the config was picked up correctly.

How do I build a package and have the dtsonfig be in a relative or different specified path?
Post #1416370
Posted Wednesday, February 6, 2013 3:58 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:34 AM
Points: 386, Visits: 624
Resolved but not happy

from the command line I have to use the /conf[iguration] switch to specify the location of the config file which will then override the location specified in the dtsx. I can understand why you would want that functionality in the DTEXEC armoury, but it shouldn't be the default method - you would have to specify it for every config file for every package - makes it a right PITA for support!
Post #1416385
Posted Wednesday, February 6, 2013 4:06 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:11 AM
Points: 5,029, Visits: 11,760
aaron.reese (2/6/2013)
Resolved but not happy

from the command line I have to use the /conf[iguration] switch to specify the location of the config file which will then override the location specified in the dtsx. I can understand why you would want that functionality in the DTEXEC armoury, but it shouldn't be the default method - you would have to specify it for every config file for every package - makes it a right PITA for support!


Which is probably why most people use an SSISConfig db to contain all config settings & indirect XML config to point to the SSISConfig db to use (dev/QA/Prod etc).



Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this link.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.
Post #1416392
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse