Hi ,

I am having probelm with Global Variables in my DTS Package.
Data Transform Task is defiend between 2 SQL Server. I have defined Global
variable in my Package and trying to pass variable value to SQL Statement
defined in Data Transform Task.

For Example

1) Gloabal Var : OrderNo, value is assign through Dynamic task
2) SQL1 qry : select * from xyz where Orderno= ?
3) Transfering above qry data to SQL 2.

Erro : Microsoft OLE DB Provider for SQL Server
Syntax Error or access Voilation

I am admin on both the server.

Any Idea ?

Thanks
-Kris

When do you receive this error?

On hitting the parameters button?

The query looks fine to me.

Check the value of the GV after you have assigned a value in the DP
task.

Datatype mismatches?

Allan

"Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote

Thanks for your reply.

I receive error when, I hit ok after selecting Variable..data type is not a
problem it is same field and variable ..

Thanks


"Allan Mitchell" wrote:

So you have defined your query with a ?
You have hit the parameters button
You go to the input parameters tab
Map the GV to the ?

This is when it goes bang?

What datatype are you expecting in the query and what is the datatype
passed in the GV. I'll see if I can replicate. Also what SP are you
using?


"Kris" <Kris (AT) discussions (DOT) microsoft.com> wrote