SSIS - dataflow task stuck

I had a strange issue with TFS and SSIS project solution file in my current project. SSIS package have multiple task in it which includes loop container, execute sql task, dataflow task etc. this package was running successfully and ran multiple times locally as well as from the server.


TFS contain multiple projects under same solution file. One fine day when I opened solution file, I could see all the projects except one project. I tried different methods  described in blogs and msdn to get back my project but I not succeeded.


Finally I have deleted the files from TFS and created new project under the solution and added all the packages into new project.


As usual I tried to execute the package from my local machine and it was executing till the data flow task but not moving ahead and completing the project.







after scratching my head for an hour, I found the issue with the package. when I deleted the package from TFS to get back the project under project solution file, shared connection also deleted from the project. I have recreated the shared connection and assigned to all the task in which this connection was associated. But forgot to assign back the connection to the data flow task called under error handler event.


I was expecting error here for not assigning the right connection but somehow SSIS ignored this one and was executing infinitely.







Once the database connection link breaks, this session will be filled with alpha numerical characters.


I did replace this error handler connection with newly created shared connection and made sure that the package is not referenced this alpha numeric value anywhere inside the package by searching the xml code.




after above fix, I was able to run the package smoothly and loaded the data in respective tables.









Comments

Popular posts from this blog

Hadoop - Hive - Load data from csv/xls files

Microsoft BI Implementation - Cube back up and restore using XMLA command