EldoS | Feel safer!

Software components for data protection, secure storage and transfer

Connection String not updating with Package Parameters

Also by EldoS: CallbackFilter
A component to monitor and control disk activity, track file and directory operations (create, read, write, rename etc.), alter file data, encrypt files, create virtual files.
#36939
Posted: 06/08/2016 14:20:03
by Brad Austin (Basic support level)
Joined: 06/07/2016
Posts: 1

I have built an SSIS Package with package parameters to update the SFTP BizCrypto SFTP upload Task dynamically based on the Project level parameters. This works perfect in SQL Server Data Tools 2012 but when I build and deploy the project and Create a SQL Job to call it with the desired parameters; it will not update the connection string:( It maintains the string for the parameters that were set when I built the project for deployment. Can you help?
Here are a few pics:
[img]https://goo.gl/photos/pFyLsY6LMqoTSgYWA[/img]
#36945
Posted: 06/09/2016 07:04:15
by Dmytro Bogatskyy (EldoS Corp.)

Thank you for contacting us,

I’ve noticed there is no Support Access Ticket linked to your user account on EldoS site. Technical Support is provided to customers with the linked Support Access Ticket. You will find your Support Access Ticket together with all the details about how to use it in the registration e-mail that we’ve sent to you upon the purchase.

If you are evaluating the product and don't have a license yet, please let us know and then you can have support according to Basic support level. Basic support level includes answering basic technical questions that appear during product evaluation period. We also offer Premium support for a purchase from https://www.eldos.com/support/calc.php . You can use Premium Support to get higher level of assistance during your evaluation of our products.

Quote
I have built an SSIS Package with package parameters to update the SFTP BizCrypto SFTP upload Task dynamically based on the Project level parameters. This works perfect in SQL Server Data Tools 2012 but when I build and deploy the project and Create a SQL Job to call it with the desired parameters; it will not update the connection string:( It maintains the string for the parameters that were set when I built the project for deployment.

Possible, that's because of the way how SQL Job executes the package, it uses dtexec utility to execute it.
Did you try your approach with standard SSIS connections such as File connection or FTP connection? Is it working?

P.S. There is a nice post at https://www.mssqltips.com/sqlservertip...iguration/ that details a way how to parameterize connection strings.

Reply

Statistics

Topic viewed 1081 times

Number of guests: 1, registered members: 0, in total hidden: 0




|

Back to top

As of July 15, 2016 EldoS Corporation will operate as a division of /n software inc. For more information, please read the announcement.

Got it!