I am not sure if this is possible within an SSIS package
1) I have a txt file coming in [source] .
2) Data coming in goes through a number of transformation [Data Conversion / Sorting / Derived Column]and is loaded to a Staging table in SQL.
3) This Staging table is loaded back into a txt file.
4) Text file is sent out through [Send Mail Task] to respective party.
My company has purchased an Address Cleansing Tool[3rd party software].This tool is to perform cleansing on my staging table in SQL on a column [Address].After tool is executed, Staging table in SQL is updated with corrected values for the [Address] column.
My task is to, call the 3rd party software within my SSIS package after task 2) and before task 3) takes place.Task 3) should only be executed if [3rd party software] execution is a success.
The Address cleansing tool is written in .Net.
Greatly appreciate suggestions as I have not got a clue on how to solve this and if this is possible.Thank You in advance !
“I haven't failed, I've found 10,000 ways that don't work”........Thomas Alva Edison