So, local temp tables only matter when they are part of the result, isn’t it? I mean, we could use other temp tables in the stored proc as auxiliaries, correct?
@learnssis5 ай бұрын
Correct.
@user-ib4kc7jq3j5 ай бұрын
Sir, I am interested in utilizing SSIS to compare two Excel files, with the intention of managing errors based on a checklist. My plan is to export the errors as separate Excel files or alternatively, to add a new column into the original Excel file to capture remarks. Could you please guide me on how to proceed with this?
@learnssis5 ай бұрын
You can use lookup transformation to compare the data between 2 excel files based on either a single column or based on multiple columns. Although I would suggest if possible import the files to sql server tables and then do the comparison in sql and then accordingly you can export the data to a new excel file.
@user-ib4kc7jq3j5 ай бұрын
Thank you for your suggestion. Upon importing the Excel data into tables, I can use SQL commands to identify errors and then export each error type into separate Excel files. Furthermore, when it comes to checking and handling errors in two Excel files, Is Python more suitable? I have to check more than 25 lakhs of data and one excel file has more than 50 columns. I am thinking to automate this process.
@learnssis5 ай бұрын
@@user-ib4kc7jq3jActually I have not worked with Python thus I don't know how suitable it will be.