Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
System123
Starting Member
1 Post |
 Posted - 2009-04-07 : 12:25:36
|
| Hi All,I am new to SSIS. I have a business case, please let me know if it is possible in SSIS. If yes, help me how to do this.CASE: Step1: I have an excel file that has sql queries in column 1 and expected results in column 2. SSIS package has to take this excel file as source and execute the sql queries in database.Step2: Compare the results with column 2 in the excel and update column 3 of excel with PASS or FAIL. |
|
|
svicky9
Posting Yak Master
232 Posts |
Posted - 2009-04-08 : 04:16:07
|
| yes.. It depends on the end column of the Excel source(no datasets with more columns)Step 1:Import Excel to a table,Add a third COlumn..new resultStep 2:You may end up with something in this link http://www.sqlserver007.com/2009/03/31/organising-your-favourite-sql-statments/Step 3:Use Lookups or Case in SQL to compare 2nd and 3rd Column and Update to true or FalseStep 4:Export the table nowhttp://www.sqlserver007.com |
 |
|
|
|
|
|
Excute SQL queries from Excel File