Assign a variable (String) directly from Excel Source

Question

Assign a variable (String) directly from Excel Source

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

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

gtschech Ten Centuries Points: 1351 More actions · Answer 1

David,

if your excel sheet has the F2 field formatted as date, you will get a 'datetime' type value from the select statement. If you want to have this value inside a string variable, you hav to cast/convert it yourself into the appropriate format, SSIS can't do this for you because it does not know which format to take.

WM_HOPETHATHELPS

Günter

dave-0 Mr or Mrs. 500 Points: 550 More actions · Answer 2

Thanks for the help

Was definitely the datatype in the excel source:

Resolved by using CSTR(F2)

Cheers