The SSIS flat file source cannot read this if the columns change each time.

You need to parse this with a script task.

Posting the actual errors might help.

Great question, thanks!

Very nice question, thanks.

Hmmm, so I'm not the only...

There's a problem with the column system_date:

"The value violated the integrity constraints for the column"

My guess is you're trying to insert some value that violates a primary key, a unique...

Nice question, thanks.

An oldie but a goodie. Thanks.

Lynn Pettis (7/17/2012)

---

rodjkidd (7/17/2012)

---

Lynn you beat me to it! They will just have to hire someone new to fill the B.A. position.

Grant, I did think about you and Murdock but...

L' Eomot Inversé (7/15/2012)

---

Thanks to "El" Jerry, Jason, Lynn, Paul, Stefan, Gianluca, Bex, Grant, Brandie, Greg, Kiara, Revenant, Sean, Craig, Rodders, Dwain, Ray, Jeff, Jack, Wayne, Jan, and Gus ...

Ah ok.

No I haven't created a linked server to SQL2000.

I replied to this thread originally because I know the 2012 native client is unable to connect to 2000.

SQLRNNR (7/13/2012)

---

Koen,...

Tatsu (7/15/2012)

---

Koen, you might want to get Developer Edition if you really want to check out the new features. I have a simple laptop with dual-core processor, 8 GB RAM,...

Thanks for the question.

This weekend I'll be trying out the "Chouffe Dobbelen IPA tripel". 9% alcohol, type Indian Pale Ale.

Was nominated as one of the best belgian beers (top 18 of 210 contestants)...