Error: The Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state. Error: The Data Flow task engine failed at startup because it cannot create one or more required threads. Hi i am tranfering data from source to target, i am using Source --> look up --> lookup --> target when i do this it is giving me the above error please help me.

Error: The Data Flow task failed to create a required thread and cannot begin running. The usually occurs when there is an out-of-memory state. Error: The Data Flow task engine failed at startup because it cannot create one or more required threads. ... That is the issue, I guess you are hitting the memory limits. Is it on your dev machine? You will need to revise your approach: 1) May want to use partial cache and/or 2) Limit the number of columns to process, etc.Arthur My Blog

Hi, Please check SSIS has been installed properly by designing simple package to read and write data from flat file. Best regards, SengwaBest regards, Sengwa