August 18, 2014 at 4:30 am
Hi All,
I am using a SSIS Package where configurations are saved in SQL Table.
The SQLServer (where the configuration is stored) connectionstring (Which includes username and password) is saved in a Config file.
So I have an XML Configuration which points out to SQL Configuration Table And a SQL Config which reads the configuration value.
However, After opening the page I see 2 OnInformation Messages which says attempting to read configuration.
But I also see error with login failed for SQL Configuration Server.
Why the SSIS is not reading SQL configuration settings from XML Config file ?
August 18, 2014 at 4:42 am
er.mayankshukla (8/18/2014)
However, After opening the page I see 2 OnInformation Messages which says attempting to read configuration.But I also see error with login failed for SQL Configuration Server.
Which page?
Can you post the actual error message?
Does SSIS have access and permissions to read the XML config file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 18, 2014 at 5:08 am
Hi,
Kindly check the screenshot attached
August 18, 2014 at 5:15 am
Does SSIS have access and permissions to read the XML config file?
Is the XML config correctly configured? Is the password correct? (not *******, you need to replace it with the actual password)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 18, 2014 at 6:26 am
Thanks Champion,
I didn't notice it.
In my Config File a semicolon was missing after password field.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply