vb script help on an integration

[Luvsql]

I have 2 sources that are sql datasources. I am trying to have a script that prompts a user for a Batch ID and that prompt will then restrict the source data to that Batch ID. I have found the vb script that does this, but it doesn't seem to work if I have more than one source.

Here is what I have so far:

Dim Input
Input = InputBox("Enter a Batch ID to Import","Batch")
Query.AdditionalCriteria = "[Source1.Batch] = '"+Input+"'"

Batch is the column name in Source1.

 

[Luvsql]

I have this script in the Before integration:


dBatch = InputBox("Please enter a Batch ID to Import.")
SetVariable "dBatch", dBatch

I have this one setup in the Before Query on my primary source

dBatch = GetVariable("dBatch")

Query.AdditionalCriteria = "Batch=" & dBatch

The error I'm getting is invalid column name 'xx' where xx is the Batch ID I've entered.

 

[GreatPains]

Have you enclosed the batch in single quotes...

Query.AdditionalCriteria = "Batch='" & dBatch & "' "




An expert is one who knows more and more about less and less until eventually he knows absolutely everything about nothing.

 

[rgittins]

Have you ever tried to import the data directly into the database backend. It runs much faster and you can write a frontend in .Net that will allow you to select a specific batch very easy.