scheduling and executing the dts packages

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » scheduling and executing the dts packages

scheduling and executing the dts packages

Rate Topic

Display Mode

Topic Options

Author

Message

geetha@in

Posted Thursday, January 20, 2011 5:46 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 19, 2012 4:37 AM
Points: 173, Visits: 565

Hi,

could anybody tell me how to schedule the dts package and how to execute the dts package....

Thanks

Post #1050676

John Mitchell-245523

Posted Thursday, January 20, 2011 5:56 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 4,428, Visits: 7,196

You've posted in an Integration Services forum. Please will you confirm whether you are referring to DTS packages or SSIS packages?

Thanks
John

Post #1050686

sharath.chalamgari

Posted Thursday, January 20, 2011 6:01 AM

Ten Centuries

Group: General Forum Members
Last Login: Monday, September 17, 2012 7:30 AM
Points: 1,038, Visits: 679

if you are talikng about the ssis packages you can execute and schedule it using sql job agent.

The below URL might help
http://www.sql-server-performance.com/articles/biz/Scheduling_a_SSIS_Package_in_SQL_Server_Agent_p1.aspx

Post #1050691

geetha@in

Posted Friday, January 21, 2011 1:55 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 19, 2012 4:37 AM
Points: 173, Visits: 565

Iam talking about dts packages only...
How to scheduling (jobs)and executing the dts pakages.....i will be happy if anybody reply for this....

Thanks

Post #1051380

Satnam Singh

Posted Friday, January 21, 2011 2:27 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 05, 2013 3:42 AM
Points: 291, Visits: 1,064

Whenever u save the DTS package as SQL Server a job gets created automatically for it. Once that job gets created then u can schedule it as per your convenience.To schedule a job just Right Click on it and select Properties, u shall be able to view the schedule option.

Hope this helps u.

Satnam

Post #1051389

Satnam Singh

Posted Friday, January 21, 2011 2:28 AM

SSC Veteran

Group: General Forum Members
Last Login: Friday, April 05, 2013 3:42 AM
Points: 291, Visits: 1,064

Post #1051390

« Prev Topic | Next Topic »

Permissions