SSIS task to test connection to SQL Server

• na1774

  SSCrazy

  Points: 2301

  More actions

  August 7, 2012 at 1:22 pm

  #260443

  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.

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  August 7, 2012 at 2:44 pm

  #1522849

  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/