dtsrun /? is a good place to start, but here is the syntax to send a dynamic parameter to the dts package.
dtsrun /SsqlServerName /NLoad pr_Labor Table /E /Apayrolldt:=dateString /E is for trusted connection, otherwise you will need to supply username and password in the command line. -- jon mailto:[EMAIL PROTECTED] Tuesday, July 15, 2003, 4:55:22 PM, you wrote: TD> Hello All, TD> I'm trying to use cfexecute to run a dts job. Can somebody help me with the TD> syntax? Also, how would the cf server access the dtsrun on the sql server? TD> jobname:Load pr_Labor Table TD> global variable: payrolldt (date) ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
