What parameters are we talking about here?

The answer will depend on what you are trying to achieve.

The offending code is~:

and (numsubmission,numquote) in (

select a00_snum, A06_QNUM

from cmsi_prod ..CMSI.SCOMMON

WHERE A0R_UW_Territory = '02')

You cannot use two values for an in clause in this method. Trying concatenating them:

cast(

What were the hash hash Match/inner join steps?

A couple of things to investigate are:

You have aliased the table in the first sql script as i:

FROM dbo.[Interactions] i

Also, you are storing...

Look up global variables in dts packages.

You can populate a global variable in your sql script and use it anywhere in your package. In your case, the activex script.

This will do it for you but is not too efiificent:

------------------------------------------------------------

declare @i as integer

declare @mystring as nvarchar(255)

create table #tmp_results

(results nvarchar(255))

DECLARE column_name_cursor CURSOR FOR

SELECT column_name FROM table_name

OPEN column_name_cursor

FETCH NEXT FROM column_name_cursor

INTO...

Not too sure what you want to retrieve but this will return yes/no on a character by character basis

declare @i as integer

declare @mystring as nvarchar(50)

set @mystring = 'aad+asa'

set @i =...

Glad to hear you have a working solution. Definitely very strange behaviour. Obviously the dts package treats the insert differently, but I cannot understand how or why.

You need to research package properties. I have the code at home so I will post it here tomorrow for you.

An example is this:

DTSGlobalVariables.Parent.Connections("Text File Source()").DataSource = "C:\" & date...

You are going to need to do it in vb script. Friend of mine gave me this link but I did not end up trying at as the infrastructure guys...

Aplogies, there. I was thinking of dts packages within activex code. I have been working on them for the last couple of weeks and completely lost my marbles.

Thanks for pointing...

Just a stab in the dark, but it sounds like a timeout problem in the sql that is causing a rollback of the transcations.

Not too sure how you would go...

As far as I know there is no difference between the two statements. The only benefit I can see in using exec in a sql insert statement is to dynamically...

There is quite a bit of difference between these data types. Rather than try to answer it myself you will find more of a definitive refrence in sql server books...

I'm not 100% certain here, but I believe that the value of 000000000 will be treated as null by the db for a column type of numeric, hence the errors...

 By so on....

I meant that you can add additional children tables further down the rows. Again all hard coded with joins to the previous child.

i.e

left outer join tmp_child3 c3

on c2.id...