TOOL: SSIS 2008 (SQL Server Integration Services 2008)
Problem: It's not reading the parameters from the SSISConfiguration table. OR
SSIS not overwriting design time values with Config entries in Table/XML.
Solution:
Setup: I have my DW connection details in a XML file using "Indirect XML Configuration setting*". And rest all configuration parameters I am storing in the DW dbo.SSISConfigurations Table.
* Whether you use indirect or indirect doesn't really matter. Below solution is still relevant.
Below is how I had them when I was facing the problem. Observe, the connection details to my DW is 2nd in the list. This is reason for all problems.
Once I changed it to be the first entry like below. It started to read the entries from the table.
CONLCUSION:
If you are using the DW dbo.SSISConfiguration settings to store your configs.Then the Configuration storing the DW entries should be the topmost entry in the Package Configuration List.
Problem: It's not reading the parameters from the SSISConfiguration table. OR
SSIS not overwriting design time values with Config entries in Table/XML.
Solution:
Setup: I have my DW connection details in a XML file using "Indirect XML Configuration setting*". And rest all configuration parameters I am storing in the DW dbo.SSISConfigurations Table.
* Whether you use indirect or indirect doesn't really matter. Below solution is still relevant.
Below is how I had them when I was facing the problem. Observe, the connection details to my DW is 2nd in the list. This is reason for all problems.
Once I changed it to be the first entry like below. It started to read the entries from the table.
CONLCUSION:
If you are using the DW dbo.SSISConfiguration settings to store your configs.Then the Configuration storing the DW entries should be the topmost entry in the Package Configuration List.
No comments:
Post a Comment