Posted by: STUPIDA May 22, 2008
For Each Loop Container in SSIS
Login in to Rate this Post:     0       ?        

HEllo to ALl SQL guys, . I need help..

I am using a Foreachloop container and i have a bulk insert task inside it. Everything works fine, but the file connections seems to throw error during dynamic connection.

what i am trying to do is loop over a folder , find all .txt files and do bulk insert to sql table.

this works with dataflow task.

So my question, how can we do this when using bulk insert,.

? can someone help me? i get this error:- the connection"............" is not valid or pointing to an object that doesn't exists.

thanks

Read Full Discussion Thread for this article