• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • Last Modified:

deploy SSIS package in a server which doesn't have SSIS server

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!!!

0
chandrasekar1
Asked:
chandrasekar1
  • 2
1 Solution
 
Alpesh PatelAssistant ConsultantCommented:
To Deploy the package you need the SQL Server without that you cannot do this.
0
 
Alpesh PatelAssistant ConsultantCommented:
Other way deply on other server and call from Production server.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now