<div>
Other way deply on other server and call from Production server.
</div>


Other way deply on other server and call from Production server.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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.. <br />
<br />
Thanks in advance!!!<br />
<br />

</div>
</div>


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


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

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).