Friday, March 23, 2012

intergration services comportant

Can you creat a SSIS package and run the package without installing the SQL server intergration services?

During the SQL server installation, you can choose which component you want to install ( SQL server services, intergration services, and analysis services, etc..)..

I didn't check to install the intergration services comportant..but I can still be able to create a intergration services project thru the business intelligent studio... ( but i don;t see it under SQL server configuration maanger)

what the intergration services if for? is it seperated from SQL server services.. why i can still create a SSIS package even though i didn;t install the intergration services?

You may have installed Workstation Components which includes the designer support, but you have not installed the engine. Do your packages run properly? Probably not, see http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

No comments:

Post a Comment