Hi Phil,

I think you are saying configure in the SSDT Project how I want and then deploy to server. I have that set as my current setting. I think the...

Hi Phil,

I think these are the settings:

• local>Programs and Features>Microsoft SQL Server Integration Services Projects: 15.0.2000.180
• server>Microsoft SQL Server 2019>SQL Server 2019 Configuration Manager>SQL Server Services>SQL Server Integration Services 15.0

I am doing the less complex option right now.

so I think the difference is that I don't have these connection string parameters in use, I'm setting the environment variables on the actual project connections, connections tab in the...

Thanks for your input, conceptually I am having a block in what is being suggested vs my SSIS Development experience.

• I'm good with this part: have a variable e.g. @[User::oracleConnectionString]...

Thanks yes I think this is the route, using that input parameter, I like the name of it as well. The only challenge I face is reading those package connection...

• This reply was modified 2 years, 10 months ago by  47u2caryj.

1. I'd prefer not to do this as our best practice is to have a single spot with the connection strings.
2. This would be a non-started because of duplication
3. Can...

It's a little different,

2. You have created a SQL Agent job to run a package, using its default connection (that is, the one which it was configured in a different...