snippetsqlMinor
What is a "Reporting Task for Subplan" task in SSIS, and how can I create one?
Viewed 0 times
reportingcanwhatcreatessisoneforhowandsubplan
Problem
I'm trying to script a daily full backup to a job using an SSIS package. I've inherited several databases from a previous DBA, and I'm trying to emulate the ones he made in order to be consistent. Most of it is pretty straightforward, but there is one task called "Reporting Task for subplan {GUID}" which I am not sure how to create or use:
No task by that name appears to be in the Toolbox pane in BIDS, nor does any task appear to exist which has that icon. Neither Books Online nor Google searches are returning any real documentation or discussion about it. Presumably it's used for logging, since a logfile is specified in its properties.
What is this task and how can I create one, so that I can build packages similar to what my predecessor was building?
No task by that name appears to be in the Toolbox pane in BIDS, nor does any task appear to exist which has that icon. Neither Books Online nor Google searches are returning any real documentation or discussion about it. Presumably it's used for logging, since a logfile is specified in its properties.
What is this task and how can I create one, so that I can build packages similar to what my predecessor was building?
Solution
Please open them in SSMS Maintenance Plans instead of using BIDS to open them & you won't have to worry about the GUIDs. The task you're asking about is created automatically when you make a maintenance plan in SSIS.
Context
StackExchange Database Administrators Q#23032, answer score: 4
Revisions (0)
No revisions yet.