October 6, 2008 at 8:38 am
Hi All.
Just wondering whether anyone knows if I can execute a DTS package from within Reporting Services (RS)?
Basically we have a heap of data that doesn't require full-fledged reports but rather just the raw data to be viewed. So I was thinking that maybe I could execute a data-driven DTS package from within RS from a hyper link - just like you do when navigating to another report. This DTS would produce a csv file to be saved to the users desktop?? Wishful thinking??
Thanks.
Dave
October 6, 2008 at 2:02 pm
How's come you want to use DTS. Can't you just pass that data through to a query/stored proc that is setup as a report with the default option of save as text? ot sure if this is possible with SSRS
Or you could look into using sp_startjob to start a DTS job. Check it out in BOL.
-Luke.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply