Error on Data Stream Out

[gabbie_391]

Hello,

Has anybody seen this issue before?

Error: Data Stream Out (1390): Error SQLExtendedFetch: [Microsoft][ODBC SQL Server Driver]Error in row[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).[Microsoft][ODBC SQL Server Driver][DBNETLIB]General network error. Check your network documentation.

Our workflow ran for 3.5 hrs with 1 error, and it's on the data stream out connector from Connect In-DB. Our SQL script runs fine in Management Studio with about 850k rows. 

Any inputs is appreciated. Thank you!

[paultno]

Have you tried running with just a small sample of rows?

[gabbie_391]

Yes, if I do Select Top # it works

[paultno]

Is it possible to optimize the workflow?  That has helped me with data stream out errors. 

[gabbie_391]

What I ended up doing is on my SQL script I put Select Top 1000000 (to give me wiggle room in case we have more than 850k data) then I deleted data stream out and re-added it again. My workflow ran in 9 mins.