May 15, 2006 at 11:57 am
Does anyone know of an example of executing a Sybase stored procedure from DTS?
I need to process a lot of data in an Excel spreadsheet and then send the data to Sybase and have it run a stored procedure.
I can use DTS to bring in data and process it. I have a ODBC DSN for Sybase already. Is there an example of executing a Sybase stored procedure from DTS?
Thanks,
Tony
Things will work out. Get back up, change some parameters and recode.
May 16, 2006 at 6:20 am
I'd imagine it's like calling any other stored procedure/query from another datasource. Create an other ODBC conniction via your Sybase ODBC driver.
Then create an execute SQL Task and tyep in the sytax to call your Sybase SP just like you normally would using the Sybase client Windows isql.exe app.
The ODBC driver should send those commands through to your Sybase db and all should be well.
If you run into problems you may want to look at the post from Peter Yang here.
May 18, 2006 at 8:24 pm
Thank you!!
That points me in the right direction and gets me started. I appreciate that!
Tony
Things will work out. Get back up, change some parameters and recode.
May 18, 2006 at 8:26 pm
Thank you!!
That points me in the right direction and gets me started. I appreciate that!
Tony
Things will work out. Get back up, change some parameters and recode.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply