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