jsheldon (1/29/2008)

---

Absolutely stumped on this...I am a bit of the novice in SSIS. I have a flat file where the date is formatted as 12312007.

In my source flat file...

If all else fails, you can apply a type cast in a Derived Column component in your data flow to change the inbound DT_STR to an outbound DT_WSTR:

Derived Column Name:...

You might be able to accomplish this using a script component in your data flow which finds the length of the longest output line, then pads all of the others...

Is it the sorting, or the physical output that's failing?

One thing that I would suggest is to implement error handling in your packages. Instead of the default fail component on an error, select the redirect option, and route...

I was asked some time ago to do this in SSIS, but I was able to convince my upstream data provider to use SAS on their mainframe to convert the...

Since it looks like you have {CR}{CR}{LF}, try selecting the Row Delimiter, and putting that in rather than accepting one of the choices in the pulldown. I don't know...

To peel the first row without grabbing the others, have you tried just the {LF} or the {CR} alone as a row delimiter? I've had the former in some...

I believe that what you're asking about in SSIS terminology is Parent Package Variables. If so, there's an MSDN article: http://msdn2.microsoft.com/en-us/library/ms345179.aspx that gives an overview. This...

In the connection manager for your flat file, under the Advanced heading, you can specify the internal data type for each incoming column to match the desired output type, e.g....

I can't tell from the error descriptor which part of the conversion is throwing the error. I can suggest that for dealing with date fields which may contain null...

If you re-order the date string into the format 'mm-dd-yy' and then run a year( ) function call on it, it will convert the two-digit year into a four-digit year....

The expression looks right to me, is there any possibility that the incoming field is not formatted correctly in the source data? The error message seems to indicate a...

To go from a varchar date: 'dd/mm/yy' to a mm/dd/yy datetime in SSIS, you could use something like the following as the expression in a derived column transformation:

ISNULL(CHAR_DATE) ? NULL(DT_DATE)...

The sites that I used the most when learning SSIS were:

Marcin Policht's Column at http://www.databasejournal.com/article.php/1503191

Jamie Thomson's blog - http://blogs.conchango.com/jamiethomson/

SSIS Stuff MSDN Blog - http://blogs.msdn.com/mattm/default.aspx