SSIS Requirement: We have to Load .txt file to SQl Table. Step1: Check File is exist or not in folder, If not Send a mail to User “File does not Exists”. Step2 : Load the File on the basis of First come First Load, Below is the sample file name … More Real Time SSIS Secnario.
Let see how to do Transations in SSIS Package. I have Created one Simple Package in that I have used Four Execute Sql Task to Create the table and Insert data into that table. Below I have attached the Screen Shot for more details. After Configured all four Execute Sql Task , Now we will run … More Handle Transactions In SSIS