SSIS Expression Builder converting/casting a SQL column Data Type of Int to type: String & Date

Question

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Dan Colbert-387424 SSCrazy Points: 2195 More actions · Answer 1

Here's one I use to create a file name out of a DATEPART extraction:

"\\\\server\\Shared\\dir\\IS\\BI\\LastOrderFiles\\" + "LastOrder" + (DT_WSTR, 2) (DATEPART( "mi", GETDATE() ) ) + ".xml"

The "DATEPART" returns the minute (as an int) and I convert it using the (DT_WSTR, 2).

I do this in an expression srtting a package variable.

Hope this helps.

Dan

Ismail Cassiem SSC-Addicted Points: 484 More actions · Answer 2

Thank You, I used (DT_STR,8,1252)Run_DateFrom

Regards