Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 using SSIS config files for scheduling agent job

Author  Topic 

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2010-02-26 : 06:23:38
I want to schedule agent jobs using three SSIS config files to run same package for three different servers. I tried this in SQL Server 2008 but it is failing. I read somewhere this is not possible in SQL Server 2008 but I find it hard-to-believe and I am unable to locate such statement in Books Online.
What I am looking for?
1)If anyone of you tried this in SQLServer2008 let me know if there is any tweak which I am missing.(I already diabled Encryptsensitive...property)
2) If this doesn't work and you read it on books online or some relaible source please provide that link.

Thanks
Saurabh

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2010-03-05 : 00:20:48
What I was trying to achieve using SSIS config files is possible in 2008 as well..
Go to Top of Page
   

- Advertisement -