July 21, 2005 at 8:35 am
Hi All,
I'm trying to create a DTS package. Basically I want to run a stored procedure on a server and the output must be saved as a CSV file.
I open DTS designer, and add a SQL Server object, the Text file (destination) object, and the Data Transform Task. When it asks me in the Data Transform Task to enter the SQL query, I enter: exec MyStoredPoc 0,0,0
When I click preview, I get an error message saying that "No rowset was returned". When I run exec MyStoredPoc 0,0,0 in QA it returns the correct data.
I'm using memory tables in the stored proc, and also reference different databases (all on the same server).
If some can help me, or point me in the right direction I would greatly appreciate it.
F.
July 21, 2005 at 1:05 pm
I've seen that message when using 'memory tables' i.e. local temporary tables. Try changing the stored procedure to use global temp tables (## as the first characters of the name). You may still get "No rowset was returned" but you'll still be able to map the columns to the destination.
Greg
Greg
July 22, 2005 at 12:46 am
I solved the poblem by creating a table, then scheduling a job that populates the table through using the stored proc. I then just use the table directly in DTS.
F.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply