August 7, 2012 at 1:22 pm
Hi,
My issue is I need a package which tests connection to SQL server.
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 package 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. I mean which SSIS task I need to use? And whiin the task how do I establish the object.
Thank you.
August 7, 2012 at 2:44 pm
Duplicate post. Please direct all replies here. http://www.sqlservercentral.com/Forums/Topic1341531-391-1.aspx
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy