lduvall (8/3/2016)

---

Would you share your code? I'd love any help. What I have now will already return me the entire line that failed but I have not parsed it into...

Eirikur Eiriksson (8/3/2016)

---

Phil Parkin (8/3/2016)

---

Eirikur Eiriksson (8/3/2016)

---

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error flow to...

Eirikur Eiriksson (8/3/2016)

---

A while back I did an import system that used a staging table with x number of varchar(xxx) column and a error flow to insert to a table...

lduvall (8/3/2016)

---

I'm using SSIS to load tab-delimited text files into a SQL staging db. Naturally, I'm having to deal with truncation issues. I'm using the newly-introduced GetIdentificationStringByID method to get...

Nusc (8/3/2016)

---

--snip

I want to try what you did. The xlsx file is supposed to be saved as a csv but the forum wont' allow me to upload csv files. I...

You'll need to register that external assembly with SQL Server first.

I'm no expert in this, but perhaps this link will help you.

I cannot see a question here. What is the 'issue', exactly?

Can you provide some test data and expected results? That is, a working test harness, rather than just code fragments.

yujinagata72 (8/2/2016)

---

Hi,

When I run an SQL query, sometimes I got the error,

and sometimes is okay....

It must have taken some serious research to track this one down, John 😉

pnr8uk (8/2/2016)

---

Hi All

I found the solution right here on SQL Central, after lots of heartache, frantic Googling and numerous SSIS testing.

The answer is here:

We had this on this site however...

What happens when you try to read it in SSIS? Will it parse, or do you get an error?

I just read a post on another site which suggested using a 'carrot' as a column delimiter, rather than a comma.

Took me a moment to realise that the writer intended...

Brandie Tarvin (8/2/2016)

---

Whoever posted or proofed this is not a native English speaker. Or it's a translation program gone rogue.

We don't...

J Livingston SQL (8/1/2016)

---

but in this thread its also been called "cleandata" and the column "year" is now called...

A quick side note: it's hurricane, not hurracane, I think.