November 4, 2008 at 11:16 am
2 64 bit SQL 2005 servers, server one running Database and SQL agent and server two running SSIS engine.
the application invokes the job, the job internally called the SSIS package which is on server two and the job throws error message that "DTS package can't be executed"
Is this setup possible ? Doesn't want to grant SA access to the account, would like to do it via proxies.
Can any one throw any light on this problem ? any help is appreciated.
Thanks.
November 4, 2008 at 11:29 am
If the SQL Agent is running on Server 1, the SSIS package is being run there, not on Server 2. SSIS does not have built-in remote execution capabilities.
Since you had to purchase two licenses for your configuration, I would recommend you install MSSQL on Server 2 as well and use the local SQL Agent to run your SSIS packages.
November 4, 2008 at 11:55 am
Let the SSIS package run on Server 2 and connects to Server1 using conenction managers inside SSIS.
Licensing is not a problem, we have corporate version. guideline is to deploy all SSIS packages on one box and connect/execute from there.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply