October 16, 2016 at 12:44 am
Hi Sir,Madam,
we are doing our SSIS jobs in one of the AWS server and we are copying/ moving into other machines.what is the process to create generic connection in SSIS?
currently we are facing issue when we copied assets in to my local machine because of database name and connection properties are being different.
version is MS SSIS VISUAL STUDIO 2010.
Thanks for your help
October 17, 2016 at 1:54 am
What do you "Generic" connection manager? If you mean something that could connect to anything (SQl Server, Excel, CSV, ADO), then there is no such thing. If you're going to be connecting to a variety of different source types, you have to have a connection manager for each type (minimum), as they all handle data differently.
Can you elaborate?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 17, 2016 at 11:49 am
No, i am asking about database connection manager.
in my production server connection name is abc but in my local machine connection name is aaa then if i over right assets in my machine then it will not work why because connection manager name is different,
how can we solve it?
October 17, 2016 at 12:01 pm
ranala (10/17/2016)
No, i am asking about database connection manager.in my production server connection name is abc but in my local machine connection name is aaa then if i over right assets in my machine then it will not work why because connection manager name is different,
how can we solve it?
One way would be to use Package Configurations as they were designed for this type of thing.
https://msdn.microsoft.com/en-us/library/ms141682.aspx
Sue
October 18, 2016 at 1:55 am
ranala (10/17/2016)
No, i am asking about database connection manager.in my production server connection name is abc but in my local machine connection name is aaa then if i over right assets in my machine then it will not work why because connection manager name is different,
how can we solve it?
You shouldn't be changing the name of the connection manager. You would have one connection manager that is parameterised. See Sue's link for details.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply