Setting up parameters in Look-up component
Hi All,
I have a task which is taking lot of time but not getting anywhere :(.
Task is, I have a table A with "Status" as one of the column. I get a new feed everyday and might have the same number of records or sometimes less number of records. I need to compare the new feed records with the existing records in the table A and
set the non existing records status in the table to 'INACTIVE'. I have followed the below approach.
LE DB Source: Take a max load date using where condition --> Lookup: Lookup the records from the OLE DB Source to the original table on ID and set the non existing records to 'INACTIVE'. --> Load the records into OLE DB Destination.
When I setup the process everything looks good but all of a sudden my Query in the lookup is changing everytime I run the package and getting the error msg "The Parameterized SQL statement contain an in correct number if parameters" . Pls let me
know how to troubleshoot this.
Some one please help me.
VSP
May 15th, 2012 3:07am
Can you post the lookup query?
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 7:12am