Post reply

SSIS in cluster

  • December 17, 2008 at 5:54 am

    #197319

    Hi all,

    I have a MS SQL server installed in cluster, node1 sql1 and node2 sql2, i have some ssis jobs in sql1

    which are executed where comes any file in folder for inserting files in db.

    Is it possible to make ssis in cluster when first node fails to take these files second node and insert in db. Does ssis support clustering.

    Thanks

  • December 17, 2008 at 6:22 am

    #913771

    The install for SSIS is not cluster-aware. MS has some solutions for this that work just fine. Check the MSDN website.

    As far as the folder - you should be using some kind of connected storage for folders on a windows cluster group. Do not use the local hardware, use a folder on a shared device and add the drive to your cluster group. SSIS on both servers should see the same drive so all of your files should still be available.

  • December 17, 2008 at 8:40 am

    #913897

    I have read this article

    http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/07/06/16015.aspx

    but i don't understand so much. If my server1 in node fails which executes the jobs for inserting the data from flat file in db, in shared disk e.g T:\FTProot etc, how second server2 will take this files to proces and insert in db. Do i need to make the same jobs in second server2, how to make the schedule to rise the jobs when the server1 fails.

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply