Ok, so maybe I should have run it in Query Analyzer first. it's failing for some reason, so please ignore the last post(s).
Ray Champagne wrote: > Yea, the procedure that is explained here: > > http://www.pengoworks.com/index.cfm?action=articles:spExecuteDTS > > traps any errors. I am using this exact code, pretty much cut and > pasted, with the server and password changed. > > > > Robertson-Ravo, Neil (RX) wrote: >> Are you error trapping in your SP? Try/catch in the SQL? >> >> What code are you using? >> -- ~~~ Ray Champagne :: [EMAIL PROTECTED] ~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:247708 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
