SQL Server Agent Service enables you to schedule administration tasks. This can include tasks such as backing up a database or executing SQL Server Integration Services (SSIS) packages. This video demonstrates how to schedule a SSIS package to run at a predefined time. This is useful for executing packages at times when server loads are particular light, or out of normal working hours.
Scheduling SSIS packages to run using SQL Server Agent Service
« Microsoft Visio Data Mining Add in for Excel
Google Motion Charts: Presenting multidimensional data in dynamic graphs »
2 Responses to “Scheduling SSIS packages to run using SQL Server Agent Service”
Leave a Reply
I have some SSIS packages debuged sucessfuly. I follow your video and Scheduling SSIS packages to run using SQL Server Agent Service. But it is not sucessful. It have Message “Executed as user: NT Service\SQLAgent$SQLEXPRESS. Microsoft (R) SQL Server Execute Package Utility Version 11.0.2100.60 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 10:21:58 PM DTExec: The package execution returned DTSER_SUCCESS (0) but had warnings, with warnings being treated as errors. Started: 10:21:58 PM Finished: 10:22:22 PM Elapsed: 23.962 seconds. The command line parameters are invalid. The step failed.”
Can you help solve it.
Hi, I suspect this could be related to 1) either a 32 -64 bit conflict or 2) a permissions issue / conflict. However I would suggest you post the same message above on on the SQL MSDN forum – http://social.msdn.microsoft.com/Forums/en-US/sqlkjmanageability/threads .Lots of very experienced experts check these threads and you should get an answer fairly quickly. Regards Steve