none
Multi server job

    Question

  • Hi, 

     

    I am new to SSIS. I created a package that grabs some data from SQL Box(SQL Box1(SQL Server 2008)) and puts it in another SQL Database(SQL BOX2 (SQL 2000)). If I run the package from BIDS, it runs fine.

    I can not schedule the job on either of the servers. So I am trying to Schedule the Job on a 3rd SQL Server 2008 box.

    I am getting an error saying "You must specify the Target Servers on which this multi server job will execute". Where Should I specify the target servers?

    Friday, December 03, 2010 7:49 PM

Answers

  • Katie,

    The package you've discribed can be executed on any server running an appropriate version of SSIS. In your case, 3rd Server would be a target server. However, you don't have to create this job as multi-server. "Target local server" would be the option you need.

    Regards,

    Akim

    Friday, December 03, 2010 8:39 PM

All replies