Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rsreddych
Starting Member
2 Posts |
 Posted - 2005-08-25 : 19:10:48
|
| Hi,I have a stored procedure "CALL_DETAIL_PROC" in my SQL Server. In the DTS import/export wizard screen I selected "Use a query to specify the data to transfer" and in the "Type SQL Statement" screen I entered "Execute CALL_DETAIL_PROC" query. After saving DTS package I tried to run this DTS package. SQL Server is throwing "Results table not found" error. I already defined results table in the stored procedure. When I selected destination table in the "Select Source Tables and Views" screen I am getting "Invalid Pointer" error.Can some one please tell me How to run stored procedures in batch scheduling or how to run stored procedures in SQL Server Data Transformation Services.Thanks in advance.rsreddych |
|
|
rsreddych
Starting Member
2 Posts |
Posted - 2005-08-25 : 20:22:47
|
| Thanks Guys.It seems I figured it out how to schedule a Stored procedure in DTS.You need to define single connection and one task.In the task you can the query stored procedure execution command. Save it and schedule it. It seems this working for me. I need to verify that one tomorrow morning whether DTS actually copied data from DB2 data base to SQL Server data base.Thanks,rsreddy |
 |
|
|
|
|
|
How to a schedule a stored procedure in DTS