I set up a sql express database to import data from our production server (AS400). I don’t want to constantly be pulling in entire tables of data to update my reporting database, so I created a script to handle the initial load, which then logs a load date and time (in separate columns, due to the way AS400 captures update date and time). I then want to use these as variables in an automation script to go get the updated records. So, I created 2 automation variables using sql queries selecting the logged date and time from the sql express database. Within the update query to be run against the AS400, I added two statements in the WHERE clause using the variables. However, when I try to add the import wizard, I cannot get past the Add Query section, because I get an error stating that the number of parameters is incorrect. I am able to do the same thing but instead exporting the query results to a CSV if I only use 1 variable - I actually get a different error here if I use 2.
Is there any way to use 2 bind variables and an import wizard as part of an automation script without getting the error? I can try to recreate and post the specific message.