• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 223
  • 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!!!

  • 2
1 Solution
Alpesh PatelAssistant ConsultantCommented:
To Deploy the package you need the SQL Server without that you cannot do this.
Alpesh PatelAssistant ConsultantCommented:
Other way deply on other server and call from Production server.
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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