Dear all, I have some curiosity, Suppose i have manifest file which i will install on a server where SQL Server is not present Can i run this pkg from a machine where there is no SQL server installed ? Is it prerequisite to have both SQL server and Integration services running before we can execute the pkgs from that machine ? waiting for a qquick reply Thanks Anky

you need to have SSIS installed on the machine you want to deploy the package. but if you don't want to deploy it on msdb in sql server, so you can have it without sql server installed.http://www.rad.pasfu.com

You don't have to install the SQL Server database engine to use SSIS or run a package. That said, you DO require a SQL Server license for the machine that is running the package. Is you want to schedule the package to run as a SQL Agent Job, you will need to install SQL Server on the machine.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

1) To run the SSIS package , you just need the client tools for SQL Server to be installed.Client tools are BIDS and associated components. 2) You could use manifest to deploy the packages onto file system. 3) Even when SQL server is not installed as mentioned in the point 1, the package can run with database connections pointing to different server other than where pakcage is deployed. 4) As there is no SQL server server side components installed, you cannot run pakcages in msdb , or agent. Hope it is clear.Happy to help! Thanks. Regards and good Wishes, Deepak.

you need to have SSIS installed on the machine you want to deploy the package. but if you don't want to deploy it on msdb in sql server, so you can have it without sql server installed. http://www.rad.pasfu.com You don't need to have SSIS installed, just SQL Server Client tools or BIDS. http://msdn.microsoft.com/en-us/library/ms162810.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

You don't need to have SSIS installed, just SQL Server Client tools or BIDS. http://msdn.microsoft.com/en-us/library/ms162810.aspx Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/134585b4-7960-4b1c-938b-d5421a4d0fdbhttp://www.rad.pasfu.com

You don't need to have SSIS installed, just SQL Server Client tools or BIDS. http://msdn.microsoft.com/en-us/library/ms162810.aspx Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/134585b4-7960-4b1c-938b-d5421a4d0fdb http://www.rad.pasfu.com That thread is from 2006. 5 years ago! I suggest you have a read of the more "Up-to-date" information at http://msdn.microsoft.com/en-us/library/ms162810.aspxJeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

You don't need to have SSIS installed, just SQL Server Client tools or BIDS. http://msdn.microsoft.com/en-us/library/ms162810.aspx Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/134585b4-7960-4b1c-938b-d5421a4d0fdb http://www.rad.pasfu.com That thread is from 2006. 5 years ago! I suggest you have a read of the more "Up-to-date" information at http://msdn.microsoft.com/en-us/library/ms162810.aspx Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD I recommend you to run a quick test before referencing any "up-to-date" material! just to let you know: I tried with a Clean Windows7 , and just installed sql server 2008 client tools ( all client tools ) without BIDS. and then when I tried to run a package with dtexec command line, I got this : "The SQL Server Execute Package Utility requires Integration Services to be installed .... " http://www.rad.pasfu.com

You don't need to have SSIS installed, just SQL Server Client tools or BIDS. http://msdn.microsoft.com/en-us/library/ms162810.aspx Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/134585b4-7960-4b1c-938b-d5421a4d0fdb http://www.rad.pasfu.com That thread is from 2006. 5 years ago! I suggest you have a read of the more "Up-to-date" information at http://msdn.microsoft.com/en-us/library/ms162810.aspx Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD I recommend you to run a quick test before referencing any "up-to-date" material! just to let you know: I tried with a Clean Windows7 , and just installed sql server 2008 client tools ( all client tools ) without BIDS. and then when I tried to run a package with dtexec command line, I got this : "The SQL Server Execute Package Utility requires Integration Services to be installed .... " http://www.rad.pasfu.com This will explain why it works for me and not you http://support.microsoft.com/kb/961126 I was running a maintenance plan package on a machine that only had client tools installed. This machine has CU7 installed which includes CU3.Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD