CODEWITHSUNDEEP
sqlsql-serverssis
Naruhina
Naruhina

Reputation: 43

Connection string and variables in SSIS package

I'm new to SSIS package creation. I have created a SSIS package. But facing with two questions now

  1. The package would be imported to SQL server and from SQL server it would connect with another system using connection string. In the connection string the password must be encrypted also I need to have the connection string dynamic since this package would run in different environments. Is it possible to decrypt the password on triggering the SQL job?

  2. The package has variables in it, is it possible to pass values for those variables while starting the job using the T-SQL query EXEC msdb.dbo.sp_start_job or is there any other way to pass values while triggering the SQL job

Upvotes: 0

Views: 605

Answers (1)

abolfazl sadeghi
abolfazl sadeghi

Reputation: 2368

first you must Made a connection in SSDT Project that better connection in Project LEvel

then you can made Environment in SSIS Catalog

then you can Set connection based on Environment Operation and decrypt the password

example: https://www.mssqltips.com/sqlservertip/4810/setup-environment-variables-in-sql-server-integration-services/

Upvotes: -1

Related Questions