January 13, 2012 at 12:40 am
hi
i am creating project in ssis..by using variable (ie,:@dbconn) can i change environment -provider for that project(like sql server to oracle)
is there any way to do this in ssis
January 13, 2012 at 5:14 am
sql Anand (1/13/2012)
i am creating project in ssis..by using variable (ie,:@dbconn) can i change environment -provider for that project(like sql server to oracle)is there any way to do this in ssis
I'm a little confused by your question. I can't tell if you're asking about variables or connection managers. But I'm going to give this a shot.
I use XML config files. SSIS allows me to save both variables and connection manager properties in the config file. I can use this functionality to change environments without opening the package. For instance, I can make a SQL Server connection manager that is pointing to server DEV point to server QC by just changing the connection string in my XML config file.
However, I don't know if you can change providers using this method because different connection managers have different properties. You can't change an OLEDB connection into an Excel File connection manager, for instance.
If both are OLEDB connection managers (for example), you might be able to fudge it. I'm not seeing the Provider listed as a separate property. However, the ConnectionString property does have a Provider section internally, which can be editing in an XML config.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply