Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

scheduling and executing the dts packages Expand / Collapse
Author
Message
Posted Thursday, January 20, 2011 5:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Thursday, January 20, 2011 5:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 9:48 AM
Points: 5,415, Visits: 10,069
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
Posted Thursday, January 20, 2011 6:01 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 10:39 AM
Points: 1,194, Visits: 787
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
Posted Friday, January 21, 2011 1:55 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-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
Posted Friday, January 21, 2011 2:27 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 6, 2014 1:47 AM
Points: 292, Visits: 1,084
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
Posted Friday, January 21, 2011 2:28 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, January 6, 2014 1:47 AM
Points: 292, Visits: 1,084
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 #1051390
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse