Indirect SSIS Config
ok, have been reading on project real ssis package config schema , have been trying implement it. have few questions remaining confusing me. far have done following things: created env. variable holding location of sql server configuration info. created .dtsconfig file holding connection string sql server configuration table. created package with: xml config variable set in package configuration, ole db connection corresponding .dtsconfig file, , sql server configuration in package configuration.
here things tricky, when went setup package configuration sql server didn't want read info ole db connection xml file until closed , reopened project. did , inserted rows of connection information wanted ssis configuration table. set sql server config use filter used in rows. however, not want export information table, want package read connection information table.
my questions are:
when add ole db connection correct naming convention package , dummy information, how keep connection exporting info table? when reload package information connection, not want write database. read.
is there way make package (in vs or bids) update configuration sql server without reloading package together?! extremely annoying.
here things tricky, when went setup package configuration sql server didn't want read info ole db connection xml file until closed , reopened project. did , inserted rows of connection information wanted ssis configuration table. set sql server config use filter used in rows. however, not want export information table, want package read connection information table.
my questions are:
when add ole db connection correct naming convention package , dummy information, how keep connection exporting info table? when reload package information connection, not want write database. read.
is there way make package (in vs or bids) update configuration sql server without reloading package together?! extremely annoying.
SQL Server > SQL Server Integration Services
Comments
Post a Comment