June 2, 2011 at 2:44 pm
Hi I am completely new to SSIS. I started creating a customer package with all the tools available. Everything works fine till now. Another user wants to test my package with different data. I don't know how to make it portable and searched online. I end up with ProtectionLevel as 'DontSaveSensitive' and using a configuration file. But, he is not satisfied as to use this he needs to setup userid, password, server etc and asking how a new user can execute withought having any idea about all these setups. Am I in right way or any other option I can have to execute my package in different server/system. Please help me.
June 2, 2011 at 3:02 pm
Create a config file and provide him with the config file.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 2, 2011 at 3:27 pm
Thank you for the reply. I have created the config file with the password option:
\Package.Connections[sqldev01.lac.authenticom.com.AUTHENCustomer.rnayani].Properties[Password]" ValueType="String"><ConfiguredValue>test123</ConfiguredValue></Configuration><Configuration ConfiguredType="Property" Path="\Package.Connections[SQLDEV01.lac.authenticom.com.AUTHENCustomer.rnayaniADO].Properties[Password]" ValueType="String"><ConfiguredValue>test123</ConfiguredValue></Configuration></DTSConfiguration>
But, it is not executing at his end as the server name and user information differs. And also he says that he need to create the config file with all setups which should not be required for a new user.
June 2, 2011 at 3:30 pm
How many people are you expecting to be executing this package?
An ssis package is typically not run by several people but by administrators and IT staff.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 2, 2011 at 3:59 pm
Not many I guess. But, who ever is using is there any way that their account information (server name, uid, pswd ...) will be updated automatically. Thank you.
June 2, 2011 at 4:01 pm
Do you have access to deploy the package to a location on the server for this other person?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
June 3, 2011 at 10:06 am
No, is it the only solution? Thank you for your response.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply