SSIS multi configuration in a single SQL Server table

Question

SSIS multi configuration in a single SQL Server table

vanka.sravanthi

Grasshopper

Points: 22
More actions
October 20, 2015 at 4:26 am

#321563

Hi,
I want to maintain all configurations in Single table can u suggest me the best way to approach it.
Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 1

when storing the configurations in SQL Server you need to enter a configuration filter value as well, this filter value helps differentiate between configurations for one package vs others

https://www.mssqltips.com/sqlservertip/1405/sql-server-integration-services-ssis-package-configuration/

Jayanth Kurup[/url]

vanka.sravanthi Grasshopper Points: 22 More actions · Answer 2

configuration should be the sql server configaration.

eg:

I have a generic package which holds multiple configurations. i need to differentiate those configurations while setting the value

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 3

define configurations ? Are you referring to connection strings and file paths or different control flow logic?

Jayanth Kurup[/url]

vanka.sravanthi Grasshopper Points: 22 More actions · Answer 4

it is sql server configuration. and it refers connection strings and file paths etc not control flow logic.

Jayanth_Kurup SSC-Insane Points: 22967 More actions · Answer 5

in that case the link mentioned in the first reply should work , you simply need to pass the values into variable and use those variables within the child package.

Jayanth Kurup[/url]