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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2007-07-10 : 17:16:41
|
| Before in DTS, I used to using ActiveX scripts to setup simple Global Variables that would later be used by the package, let's say a give state or a date. I'm completely lost how to do the same in SSIS, can someone give me a hand?I'm not sure what component to use and how to read this variable. |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-07-11 : 11:41:26
|
| Update:I've made some progress on this, I was able to dynamically create and change a package variable using the script task, that task is going to write the correct state to my variable (which is going to be used on my next step), now I'm doing something wrong when I try to read that variable on the next step, which is a execute sql task.I've mapped my user variable (User::State, Input, Varchar, PState) to this task and am trying to use that as it follows:exec mystoreproc ?If I try to parse my code, I get this error message:The query failed to parse. Attempted to read or write protected memory. This is often an indication that other memory is corrupt.What am I missing? |
 |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-07-12 : 09:40:27
|
| On Execute SQL Task Editor, under General, I changed the Result Set to "None" and it works, I had it set to "Single Row" before. |
|
|
|
|
|
|
|
|
SSIS Global Variables