August 7, 2012 at 2:04 pm
Hi All,
We have a table 'Servers' which lists all the Servers in our Company.
My scenario is that we have a a Dynamic as well as static FQDN to connect to a database server.
I need the script or packgae(SSIS) to first test if we are able to connect using the static name if 'Yes' then I need to update a column 'IsConnectStatic' in a table Servers to 1 and then test connection using Dynamic name if that connection is also successful then I need to update the column 'IsConnectDynamic' column to 1.
in Servers table.
I am wondering how I can establish this logic. If I can use SSIS which SSIS task I need to use? And whiin the task how do I establish the object.
Thank you.
August 8, 2012 at 11:52 am
na1774 (8/7/2012)
Hi All,We have a table 'Servers' which lists all the Servers in our Company.
My scenario is that we have a a Dynamic as well as static FQDN to connect to a database server.
I need the script or packgae(SSIS) to first test if we are able to connect using the static name if 'Yes' then I need to update a column 'IsConnectStatic' in a table Servers to 1 and then test connection using Dynamic name if that connection is also successful then I need to update the column 'IsConnectDynamic' column to 1.
in Servers table.
I am wondering how I can establish this logic. If I can use SSIS which SSIS task I need to use? And whiin the task how do I establish the object.
Thank you.
If they are sql servers you can use this article http://sql-bi-dev.blogspot.com/2010/07/dynamic-database-connection-using-ssis.html
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply