Not sure why it wasn't working.....but I ended up deleting my package variables and re-creating them. And now it works. Go figure!

Thanks CozyRoc!!

CozyRoc (1/14/2009)

---

Scott,

If you define a variable in the script dialog, you should not use variable dispenser to access it. Just use the following code to write to the variable:

Dts.Variables("requestString").Value =...

ok...but how do I write to my User::requestString variable?

Thx.

Update to this thread:

Looks like you can't call a sybase stored proc with parameters using OLEDB.

But you can using ODBC. Create a dsn.......and this was how I...

also why does the SQL Statement on the general properties stay there when you have the expression? Or is it because it is tied to the SqlStatementSource expression property?...

I was running in ADO.Net and changed it back to OLE DB....and this is the error message after I got rid of the parameters...and hardcoded the SQL Statement.

Execute SQL...

thanks for the response.

I'm fairly new to SSIS......so here i tried the following.

on the execute sql task editor 'expressions' option I added the following under SqlStatementSource

"exec oracle_to_sybase @[User::metercode], ...

Justin Stephens (1/8/2008)

---

Jacq,

I have the same problem. I am trying to run a Stored Procedure with input parameters (@startDate,@endDate) on a Sybase server from SSIS using the ASE Ole...