Error with Output Data to DB -> OutboundNamedPipe::WriteFile: The pipe is being closed

[vasanthan]

Hi,

I am getting the following error while inserting the records to SQL server database.

My .csv file got 179,000 records with 11 fields (max 24 chars). I was successfully load the records from the file.

But, when I try to insert to DB, getting the above error. 

Searched through the forum and was able to find three threads. They mentioned about memory. But, none of them are descriptive enough.

Please help !

[s_pichaipillai · Accepted solution]

thats interesting

Did you try the bulk connection option for sql server

 

[vasanthan · Accepted solution]

Hi,

This is great. Thanks for helping. Bulk Loader has solved the problem. 170,000 recorded get inserted in few seconds.

[s_pichaipillai]

not a problem

Glad to see its working :)

Happy Data Blending and Have fun with Alteryx :)