Everytime I use shared datasources in a SSIS package and configure the connectionstring with a package configuration I've noticed that my package configuration connectionstring is being overwritten by the connectionstring that is present in the shared datasource (the synchronize connection strings popup). This can be very confusing.
I've done some research on the internet and discovered that this behaviour is a bug in BIDS, and only in BIDS. When you deploy your SSIS packages to a server the package configuration connectionstring will overrule the connectionstring in the shared datasource.
1 Shared datasources
2 Datasources within SSIS package
No comments:
Post a Comment