• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 226
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

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