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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics