Deployed package is not picking up dtsconfig file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Integration Services » Deployed package is not picking up dtsconfig...

Deployed package is not picking up dtsconfig file

Rate Topic

Display Mode

Topic Options

Author

Message

aaron.reese

Posted Wednesday, February 06, 2013 3:17 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:33 AM
Points: 234, Visits: 441

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

aaron.reese

Posted Wednesday, February 06, 2013 3:31 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:33 AM
Points: 234, Visits: 441

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

aaron.reese

Posted Wednesday, February 06, 2013 3:58 AM

SSC Veteran

Group: General Forum Members
Last Login: Monday, May 13, 2013 7:33 AM
Points: 234, Visits: 441

Resolved but not happy Angry

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

Phil Parkin

Posted Wednesday, February 06, 2013 4:06 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 4,247, Visits: 9,500

aaron.reese (2/6/2013)

Resolved but not happy Angry

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:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1416392

« Prev Topic | Next Topic »

Permissions