Yup, still here.  Jeff, THANK YOU for the rant, however in this case the time was available to document.

What was also present was an extremely insecure person who used NO...

Steve -

Already been through that.  The issue is that the project is going badly and both are loosing money because their work was on a fixed bid.  They are right...

Thanks for the suggestions.  Michael, I agree this whole thing is not best practice, but when you try to integrate from several competing vendors, you do what you must, and...

Thanks all.  I'll get the plan just as soon as possible.  You've all been of great help.  Thanks again.

Works great, thanks.

James -

Your original example had double-quotes (") around the company name.  If that's consistant then setting that as your text qualifier will handle things okay.  The only time this will...

Nope, didn't work.  I still get the trancation error message.  I did come up with a work-around by comparing YEAR([LaborRateEffectiveDate]) < 1900.

Right now it's a new construct.  The file is a delimited flat file.  The data is coming from a varchar() column and contains commas, double-quotes and most any other special...

Thanks, I'll give it a try.

Yes.  I need the SQL 2000 Client Tools.  However, when I do get to look into the package it's empty. 

These are packages that run as SQL Agent jobs; they fail there which is why I tried to open them.  I've just had the back file restored from tape onto...

I have seen in other places that deleteing files from an FTP server, using the SSIS FTP Task, is apparently a problem when the server is not Windows-based.  There are...

I've tried this both with and without passive mode, it doesn't make a difference.

Well, it's been 8 months and apparently the problem remains...I have the same thing.