shahzadazizpk (10/4/2015)
I am new in SSIS, i would appreciate if anyone can provide me solution to my problemMy requirement as mentioned below...
1. Read records from a source table using SQL Query (e.g Select * from MyTable where Status='S')
2. If record(s) found, write to a text file
3. If record(s) found, Execute an external executable with some arguments to process text file data (i have an application which will process the records)
4. Once above is done, records's status should be updated e.g Status = 'D'
Thanks in advance
1. Data Flow Task with an OLEDB or ADO.Net Source
2. RowCount Transform after the Source. Conditional Split after the RowCount with RowCount > 0 as the check then with that OUtput sent to a flat file destination
3. In the Control Flow after the data flow task an Execute Process Task with a Precedence Constraint set to SUCCESS and Expression with the Expression set to RowCount > 0
4. Execute SQL Task after the Execute Process Task with a precedence constraint of succeess that Updates teh Source Set Status = 'D' where Status = 'S'.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question