December 9, 2008 at 10:48 am
When I click over Preview button in the Transform Data Task Properties window, I'm getting this error message.
My SQL sentence is SELECT * FROM F4101 WHERE IMLITM=?
Of course I've associate a global variable to the parameter.
I've tried to delete the package and make it again, changed the Global Variable names, used another table, but nothing solves the problem. Even I'm having the same problem across SQL Servers. Test, Production, etc.
I really Appreciate if someone can give me some direction about this matter.
Thanks!!!
December 9, 2008 at 3:32 pm
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
December 9, 2008 at 3:40 pm
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!!!
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply