SSIS is not installed but maintenance plans seem to be installed on ssis?
Sorry for such a basic question, but I'm confused. We don't have integration services installed on our server, but when I look at the job step of the maintenance plans, it looks like the maintenance plan is stored in integration services. /SQL "CASQL01P\DTS Packages\Copy Database Wizard Packages\CDW_CASQL01P_CASQL01P_0" /SERVER CASQL01P /CHECKPOINTING OFF /REPORTING E are these not the same thing? I thought the /SQL option means that the package is stored in integration services.
November 1st, 2011 7:50pm

You mean you have a working maintenance job on CASQL01P server?Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 1st, 2011 7:56pm

that is correct. The server was setup before i arrived. It is SQL 2008 with SSAS and SSRS installed, but not SSIS.
November 2nd, 2011 1:09pm

I am trying to understand the problem. can you check and let me know if you can create any SSIS project in BIDS?
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2011 2:44pm

Hi maintenance plan creates a SSIS package even if you are not installed SSIS. Maintenance plans are basically SSIS packages which are run by SQL Server agent.Praveen Kumar
November 2nd, 2011 4:42pm

I will clarify the situation: SQL Server 2005 SP2 or above does not require SSIS installation in order to run maintenance tasks (created as packages, it uses SQL Server internal binaries),and SQL Server 2008 CU3 / sp1 or above.Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 2nd, 2011 5:04pm

Hi SteveL, As Praveen indicated, the maintenance plan creates an SSIS package and stores it in msdb database to be executed by SQL Agent. I am uncertain by what you meant by "stored in integration services".
November 2nd, 2011 5:09pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics