You've provided one example file.  Could you provide a couple more that represent some of the other files that have different delimiters,  etc?

Also, how many "columns" do these files generally...

Heh... you said a mouthful. 😀

Cool.  Thanks for the feedback.  To be sure, though, do you understand how and why Phil's good code...

Not to detail the thread,...

Totally agreed about the usefulness of standards but I have to say that bad standards are as bad and sometimes worsen than no standards.

That creates an index.  If you modify that index to include the...

Cool.  Thanks for the info, Jeffrey. You should write an article on this stuff.  I think it would be a big help to folks that use SSIS, especially people that...

Getting back to your original problem... I think that a large part of the pain you're going through is that the inclusion of which "fields" changed in the VARCHAR(MAX) constitutes...

Heh... let the silliness continue.  I just got an email saying...

KILL 99.9% OF BACTERIA & HARMFUL MICROBES

FORMS A PROTECTIVE SHIELD THAT DELAYS GROWTH OF HARMFUL MICROBES ON INTERIOR SURFACES

Reg $129.95

2...

There is no hierarchical REFERENCES clause in SQL Server.  If that's not what you meant, the only other thing that I can think of is some form of DRI and...

I've always felt that it was worth it to pay for a second audit tool that is external to the database. Auditing in the same database mixes both data...

If you go back and read it, I wasn't suggesting going to SQL Server to do it.  I said that there has to be a way in the language of...

I'm talking about people using the front end designers to create tables.  Some people do it right but, for the most part, it's done by people that have...

There is no umbrella big enough or strong enough to protect anyone from such a s**t storm as that. ...

I'm not sure what the equivalent in the language of SSIS is but I have to believe that you shouldn't need to resort to a C# component.  Here's how I...