Running of SSIS package on other server, say, Unix
-
Hi,
I am new to SSIS.
How can SSIS packages be run on other servers, say, Unix?
Earlier, I worked on Informatica & know; its workflows can be run on other servers...
I just need to know, from where can these configurations be done on Sql Server 2005
Thanks
-
prsd_06 (2/7/2009)
Hi,I am new to SSIS.
How can SSIS packages be run on other servers, say, Unix?
Earlier, I worked on Informatica & know; its workflows can be run on other servers...
I just need to know, from where can these configurations be done on Sql Server 2005
Thanks
You cannot run SSIS package on Unix servers. The SSIS technology is strictly Windows technology, which requires also installation SQL 2005/2008 and SSIS framework.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
In fact, I would go one step further and say that if you are using the 64-bit SQL 2005 version you may not have much luck running an SSIS package from the client on another machine WITH the SQL Client interface... and you may have to run SSIS packages from jobs using a command line call, calling the 32-bit .exe.
Seems Microsoft didn't quite have everything sorted for the 64-bit version before they rolled it out. It's an odd sensation when a package runs fine, and then you stick it in a job and it won't run and throws up weird errors.
They may have fixed these things now, but I'm not sure. I know 6 months ago when I setup much of our SSIS processing, this was a problem.
But I agree with the other responder... SSIS is very Microsoft specific and can't be run from another platform... at the very least.
-
Another option would be to execute the SSIS package from a SQL Agent job if your server-client is capable of executing sp_start_job.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply