Hello everyone
I need to extract data from a DB2 database to a SQL Server. I need to create my query based on a excel file I have 176 records, which I need to create repeating queries & put in SQL server
So for example;
I have an excel with a number, From date, To date ,and a country
So the query should use these information from the records
SELECT *
FROM dbo.Test
WHERE Number = excel.Number1 AND Date BETWEEN excel.fromDate1 AND excel.toDate1 AND Country = excel.country1
And then another query with
SELECT *
FROM dbo.Test
WHERE Number = excel.Number2 AND Date BETWEEN excel.fromDate2 AND excel.toDate2 AND Country = excel.country2
Etc...
How should I do something like this in SSIS?