I live and work in Indianapolis, Indiana. I was born in Washington D.C.

You'll need to set up your script component to take the entire row in as input, and add an output column to pass out the corrected row. Since each...

You could use a script in the data flow that passes in each row and loops through the characters, writing all but CRs to the output row. If there...

Are each of the data inserts contained within their own data flow tasks? If so, ensure that the FailPackageOnFailure property on the data flow container is set to False....

One possibility is to redirect error rows into a separate error table for review. If you have key fields on the data that you are importing, maintain these keys...

The extra quotes inside the file name in...

Have you tried wrapping quotes around the output data source name variable?

All of my SSIS configurations are done via XML file, not table, so I don't know if this will help at all, but Robert Davis did an article about...

The chair at my current job is the best desk chair I have ever used. It's a Highmark Modela. It's got a mesh back, a fabric base, and...

As I have shifted career focus over the past 15 years from straight-up application development, to systems analysis, to data management and administration, it's always been about finding something to...

I use an error re-direct scheme on all key transforms in a package. In each case, the process directs the offending source data row into an error queue table,...

For flat file viewing, especially files of over 4Gb in size, I use and recommend the "V" viewer written by Charles Prineas. It is not an editor, but it...

I can think of a few that I'd recommend:

SSISudio - Phil Collins

B-Trees - Rush

Mean Mr. Clustered - The Beatles

OLE Driver - Dio

In the ER question, I think the OP's actual answer to whomever is asking him should be something along the lines of "No, I've not worked with ER diagrams." :unsure:

Then...

When the SQL Agent job fails, is it throwing the same odbc error as when it fails in BIDS? Are there any events in your server error log that...