Hi. I have a simple DTS package set up with a datasource, transform data
(for my query) linking to a destination text. I also have a global
variable of type decimal, which I use a parameter in my query.


If I run my query in QA it works fine or if I replace the parameter with
a hard-coded value.Otherwise it does not.

What is even weirder is if I replace the query with a different one
using the same parameter it also works.

Finally, the filter column, which is used for comparison with the param,
is also decimal.

I call the package like this:

dtsrun /S "MyServer" /Uuser /Ppwd /N "Test Package" /A
"client_id":14=22222

I would really love any suggestions.

Thanks.


*** Sent via Developersdex http://www.developersdex.com ***

"Wierd" <> to an Error message

Redirect the DTSRUN stdio to a text file and post error?



Rick Bond wrote:

Hi, thanks for the reply. I really did not think that I needed to
include logs since I was not getting errors generated. I was just not
getting any data transferred...even though the query works in QA.

However, I got a work around by calling a SP, in the transform data
task. I just found that with the joins in the query the package was not
returning data but if I removed them, then it worked. Not sure why. I
would still like to know what is wrong but at least the work around
works.


*** Sent via Developersdex http://www.developersdex.com ***