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.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy