Hey Jeff Can you have a scheduled job set up on the sql server to run your dts package? If you need on-demand exports, rather than scheduled, you could make a special table that has a flag that you set via your CF application. You could set up the job to run every five minutes, and the first thing it does is check if the flag has been set. If it has, it runs the package, if it doesn't, it doesn't. The last step would be to set the flag to 'off' as the job finishes. Almost on-demand. On a side note - doesn't the concept of exporting production data to the test system undo the whole 'removed access to production data' concept? Or is your data time sensitive? Just curious. HTH Antony
On 8/3/05, Pratte, Jeff <[EMAIL PROTECTED]> wrote: > > As a result of SOX legislation my access to production data has been > taken away. I don't mind that much, except that they took away the > ability to run a DTS package to copy prod data to test. They will run it > for me (when they are around). If they are not around I am out of luck. > SQL admin says to run this package I would need to be admin. That does > sound right. Is there a way I can kick off job to copy data from prod to > test without admin access? > > Thanks, Jeff ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213568 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
