I have a DTS package that has several Transform Data Tasks that copy data
from SQL Server to SQL Server in based on a global parameter retrieved from a
query. The queries are all of a form similar to:
SELECT
JOB_NUMBER_ALLOC,PO_NUMBER_ALLOC,DATE_ISSUED_ALLOC ,EXTENDED_TOTAL_ALLOC
from JOBSCOPEDB.IPALLOC
WHERE LEFT(JOB_NUMBER_ALLOC, 5) = ?

And it runs fine going from SQL Server to SQL Server. This is just for dev,
though. In production, we need to go from an i5 (AS400) to SQL Server using
the iSeries ODBC connection. When I attempt to run the exact same query, I
get the following error:
[IBM][iSeries Access ODBC Driver]SQLBindParameter has not been called for
parameter 1.

I've Googled for that error message and get different results. They all
seem to want to run that command in the context of a compiled program,
though. Does anyone have experience doing this or aware of a way to do it
using a straight SQL Statement?

Thanks in advance.

Hello Mike,

Some drivers are just funny when it comes to parameters. A way around it
would be to use something like this article

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

Allan

Allan,

Thanks for the link; I didn't find that one. I'll give it a go and let you
know how it goes.

--Mike

"Allan Mitchell" wrote:

It is a little cumbersome and I had to do a little additional research to
find the proper naming of my data transform tasks, but this is what I need to
get it working.

For anybody else who might be experiencing a similar issue, the link Allan
provided is what got me over the hump. Also, this MS page helped:
http://support.microsoft.com/default...242391&sd=tech

Specifically the part that says:
NOTE: The description of a task is displayed in the DTS designer, but it
cannot be used to directly reference a task in an ActiveX script. The name of
the task should be used to reference the task from an ActiveX script. To get
the name of the task look at the workflow properties for the step name. The
task name is the same as the step except the word 'Step' is replaced with
'Task'. For example, DTSStep_DTSDataPumpTask_1 becomes
DTSTask_DTSDataPumpTask_1.

Thanks for the help,
Mike

"Mike" wrote: