 | |
Dynamic Data Source Connection
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Dynamic Data Source Connection -
11-27-2006
, 09:26 AM
#2
| |||
| |||
|
|
Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
#3
| |||
| |||
|
|
Hello Sudhakara.T.P., Can I take it you are using SSIS? Ok So what I would do is this Have variables that will hold each connectionstring. Assign them to the ConnectionString property of the relevant connection manager. Create two file connection managers that point to the files wherein lies the connection strings. Using a Script task retrieve the Connection String values from the files and assign to the relevant variable. Should be OK. Regards Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
#4
| |||
| |||
|
|
Hi Allan, Thank you very much for the reply. Well I got hold of the solution after doing some more research on that. Thank you very much. Regards, Sudhakara.T.P. "Allan Mitchell" wrote: Hello Sudhakara.T.P., Can I take it you are using SSIS? Ok So what I would do is this Have variables that will hold each connectionstring. Assign them to the ConnectionString property of the relevant connection manager. Create two file connection managers that point to the files wherein lies the connection strings. Using a Script task retrieve the Connection String values from the files and assign to the relevant variable. Should be OK. Regards Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
#5
| |||
| |||
|
|
Hi Allan, Thank you very much for the reply. Well I got hold of the solution after doing some more research on that. Thank you very much. Regards, Sudhakara.T.P. "Allan Mitchell" wrote: Hello Sudhakara.T.P., Can I take it you are using SSIS? Ok So what I would do is this Have variables that will hold each connectionstring. Assign them to the ConnectionString property of the relevant connection manager. Create two file connection managers that point to the files wherein lies the connection strings. Using a Script task retrieve the Connection String values from the files and assign to the relevant variable. Should be OK. Regards Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
#6
| |||
| |||
|
|
Hi Allan, Thank you very much for the reply. Well I got hold of the solution after doing some more research on that. Thank you very much. Regards, Sudhakara.T.P. "Allan Mitchell" wrote: Hello Sudhakara.T.P., Can I take it you are using SSIS? Ok So what I would do is this Have variables that will hold each connectionstring. Assign them to the ConnectionString property of the relevant connection manager. Create two file connection managers that point to the files wherein lies the connection strings. Using a Script task retrieve the Connection String values from the files and assign to the relevant variable. Should be OK. Regards Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
#7
| |||
| |||
|
|
Hi Allan, Thank you very much for the reply. Well I got hold of the solution after doing some more research on that. Thank you very much. Regards, Sudhakara.T.P. "Allan Mitchell" wrote: Hello Sudhakara.T.P., Can I take it you are using SSIS? Ok So what I would do is this Have variables that will hold each connectionstring. Assign them to the ConnectionString property of the relevant connection manager. Create two file connection managers that point to the files wherein lies the connection strings. Using a Script task retrieve the Connection String values from the files and assign to the relevant variable. Should be OK. Regards Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
#8
| |||
| |||
|
|
Hi Allan, Thank you very much for the reply. Well I got hold of the solution after doing some more research on that. Thank you very much. Regards, Sudhakara.T.P. "Allan Mitchell" wrote: Hello Sudhakara.T.P., Can I take it you are using SSIS? Ok So what I would do is this Have variables that will hold each connectionstring. Assign them to the ConnectionString property of the relevant connection manager. Create two file connection managers that point to the files wherein lies the connection strings. Using a Script task retrieve the Connection String values from the files and assign to the relevant variable. Should be OK. Regards Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
#9
| |||
| |||
|
|
Hi Allan, Thank you very much for the reply. Well I got hold of the solution after doing some more research on that. Thank you very much. Regards, Sudhakara.T.P. "Allan Mitchell" wrote: Hello Sudhakara.T.P., Can I take it you are using SSIS? Ok So what I would do is this Have variables that will hold each connectionstring. Assign them to the ConnectionString property of the relevant connection manager. Create two file connection managers that point to the files wherein lies the connection strings. Using a Script task retrieve the Connection String values from the files and assign to the relevant variable. Should be OK. Regards Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
#10
| |||
| |||
|
|
Hi Allan, Thank you very much for the reply. Well I got hold of the solution after doing some more research on that. Thank you very much. Regards, Sudhakara.T.P. "Allan Mitchell" wrote: Hello Sudhakara.T.P., Can I take it you are using SSIS? Ok So what I would do is this Have variables that will hold each connectionstring. Assign them to the ConnectionString property of the relevant connection manager. Create two file connection managers that point to the files wherein lies the connection strings. Using a Script task retrieve the Connection String values from the files and assign to the relevant variable. Should be OK. Regards Allan Mitchell Konesans Ltd T +44 7966 476 572 F +44 2071 008 479 http://www.konesans.com Hi, I need to connect to Oracle 9i Server & Sql Server 2005 datasources dynamically, wherein the connection strings needs to be retreived from an text file specified. I am trying this by using Expressions and specifying that in the Connection Manager-->Expressions box, but no luck. Does anyone has any ideas. Regards, Sudhakara.T.P. sudhakaratp (AT) hotmail (DOT) com |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.