Data Stream In

[keithr197]

Hi All 

First time im using the Data stream in tool and im getting the following errors, could anyone please shed some light... Thanks in advance

Error in the Data stream out tool 

Browse in db tool error

[Qiu]

@keithr197 

Just a confirmation, have you tested the queries in DB tools?

[keithr197]

@Qiu Yes, Previously I did the connect in DB, then stream that out to join with a csv file, now i streamed the csv file in to create a temp table then joined in db. I never received that error message before

[atcodedog05]

Hi @keithr197 

Is it possible to show the complete error message.

[danilang · Accepted solution]

hi @keithr197 

The collation can be set on column by column basis in SQL Server.  To work around this try adding the collation information directly into the SQL Editor in your Connect In-DB tools

Dan

[keithr197]

@danilang Thanks this really helped 🙂