It is failing because of truncation. Try changing (DT_STR,100,"1252") to (DT_STR,150,"1252")

Rather than use filters, try using parameters in your dataset query.

Rock Star

This might be useful.

http://www.bidn.com/articles/integration-services/234/handling-complex-text-files-in-ssis

Going at it directly with the width property won't work as you have already discovered. The only solution I can come up with is to get very complicated with...

crush

I would just use a date/calendar table: a table containing nothing but dates and date parts. Here is some sample data of a few of the columns I have...

This isn't really what you are asking for but I consider it a best practice to show the parameter values in the header of each report. Just another approach...

Back to reality (from a short vacation )

Steve Jones - SSC Editor (9/26/2012)

---

dma-669038 (9/26/2012)

---

15 years ago it took two days to get from south of india to Nepal (by train). Our school did an excursion - Nepal...

Woah!

Techapalooza

Have you tried the ConsumeContainerWhitespace property?

Are you saying that Tuesday is the new Monday?

I would use a link in the report to the logo, and build the link dynamically based on the company the report is being run for. You could use...