DTS - No value given for one or more requiered parameters

Question

DTS - No value given for one or more requiered parameters

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Greg Charles SSC-Forever Points: 45403 More actions · Answer 1

I've found that this is expected behavior. Preview doesn't work for a query that contains a parameter because, even if you've assigned a value to the global variable, that value isn't passed to the parameter in the Transform Data task until the package is executed.

What I usually do is replace the '?' with a valid hard-coded value to check the data with preview, then change back to '?' after I'm satisfied that the query works properly.

Greg

diego.adum Grasshopper Points: 22 More actions · Answer 2

Thanks for your response.

Let me tell you that you are right, but if a ran the DTS giving a value to a global variable this value is keep until the DTS finished and them I can check my query. (That's the way I used to test, now something happened and I'm facing this situation). Nevertheless, my main problem is when I run the DTS from a VB .net and I'm getting the same error message.

Thanks!!!