June 25, 2012 at 12:13 am
Hi Karthik,
Please try below points.
1.If you are storing SQL connection string in database table.
In case of SQL authentication please check the ConfiguredValue(Password and all are correct).
2.Encrypt the package with "EncryptSensitiveWithPassword" or "EncryptAllWithPassword" and provide a package password each time User wants to edit/manipulate the package.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 25, 2012 at 12:19 am
ard5karthick (6/23/2012)
Hi Koen,We are using Package Configuration to store the details in the Configuration table...
Thanks,
Karthick.
That doesn't answer my question.
You have a connection manager pointing to the SQL Server database where the configuration table is stored. How is this connection manager configured?
Environment variable, XML config file, hard-coded,... ?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
June 25, 2012 at 12:58 am
Hi bhuvneshk,
I have tried those methods already but still i am getting the error...
June 25, 2012 at 1:02 am
Hi Koen,
The Configuration Table is Placed in MSDB system database.
As far as Configuration goes we are giving the server details and other required information and saving the data in the Table using Package Configuration into the Configuration Table...
June 25, 2012 at 1:17 am
Can you please tell me what are the properties you are saving in the table and if possible please provide the dummy values as well.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
June 26, 2012 at 7:45 am
Hi rhythmk,
I have listed the properties i am storing below.
FILE Path(File name):C:\Users\testuser\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\OEZNMMLB\FlatFile.data
Server Name: 10.58.56.964
User Name:TestUser
Password:********
Initial Catalogue:Data Source=10.58.56.964;User ID=TestUser;Initial Catalog=msdb;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-dtsTrailerPoolLoad-{E108C483-DA03-486D-BD30-697C8548FB7E}10.48.253.28.msdb.TestUser;
Database Name:TrailTest
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply