Post reply

SSIS Configuration Help on 3 node Cluster

  • November 10, 2008 at 4:53 pm

    #132071

    We have built a new 3 node SQL 2005 Cluster environment and have not configured SSIS as a clustered resource. Can anyone please help with some suggestions as to how to setup SSIS.

    I have read that it's possibly better to setup a folder structure like, the one below to store package configurations; log files etc.

    SSIS

    |---- CheckpointFiles

    |---- Configurations

    |---- ErrorFiles

    |---- Logs

    |---- Packages

    |---- RawFiles

    We were advised by the consultants implementing the SQL Cluster that it was best to use MSDB to store SSIS packages, is this true?

    Best to use XML configuration files or database?

    The above folder structure best to be setup on shared drive, setup as a cluster resource?

    Any help or pointers in the right direction would be appreciated.

    Cheers

    Stephen

    Kindest Regards,

    Steph

  • November 11, 2008 at 4:52 am

    #896861

    We are using the setup that you have described and its working well.

  • November 11, 2008 at 11:40 am

    #897099

    Thanks for the reply but can you please clarify.

    Where did you implement that folder structure? As a shared folder setup as a clustered resource or on c: drive?

    Are you storing packages in folder structure or in msdb?

    Thanks

    Kindest Regards,

    Steph

  • November 12, 2008 at 12:17 am

    #897360

    We have the packages stored on msdb. The other folders which store log files, error files, temp storage etc are on a separate physical drive which is shared between the nodes.

    Hope that helps.

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

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