deploy SSIS package in a server which doesn't have SSIS server
Posted on 2011-09-21
I created SSIS package in MSSQL 2005 successfully and it executing fine in my local system, but in Production server (windows server 2003, 32 bit) only having MSSQL 2000 without any SSIS 2005 server installed, Please provide any possible way of deploying and executing it.
Other appoarch which i readout from net, by calling the SSIS package through a Windows service which is deployed on Production server, if this is feasible, then what are the supporting files and steps need to be done..
Thanks in advance!!!