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?
View Complete Post