March 21, 2018 at 9:51 am
Dear all,
We have small requirement in project. Would like to know how it can be done using SSIS.
Requirement – summary:
1. The SSIS package should read files from folder. It should be a continuous pooling and should support multi treading.
2. Call stored procedure and send File data which is read in step 1
3. There should be provision to monitor logs and etc if case of failures.
4. The emails should trigger in case of failure.
Please let me know if it can be done using SSIS, if possible brief the steps.
March 21, 2018 at 10:09 am
Yes, all of this is possible in SSIS. Describing the steps would not be much different to what you have listed here, so why don't you start with the development and let us know if you have any specific questions or issues.
March 22, 2018 at 5:26 am
durga.palepu - Wednesday, March 21, 2018 9:51 AMDear all,
We have small requirement in project. Would like to know how it can be done using SSIS.Requirement – summary:
1. The SSIS package should read files from folder. It should be a continuous pooling and should support multi treading.
2. Call stored procedure and send File data which is read in step 1
3. There should be provision to monitor logs and etc if case of failures.
4. The emails should trigger in case of failure.Please let me know if it can be done using SSIS, if possible brief the steps.
I do not know what 'continuous pooling' is, and the multi-threading part needs to be engineered carefully.
The rest of what you mention is straightforward, though usually I would expect that the file would be read first and then the proc would be called.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply