SSIS Expression Builder - cannot conver to string

• Brent Landry

  Mr or Mrs. 500

  Points: 504

  More actions

  October 25, 2006 at 1:50 pm

  #174729

  In the expression builder I always get errors that it cannot convert from one type to another.  For example:

  Cannot convert expression value to property type.

  Cannot convert 'System.DateTime' to 'System.String'.

  I have not been able to determine how to CAST to the string, and I can't find the syntax that Expression Builder expects.  Does anyone know how to do this?

  For example I want to do something like this:

  REPLACE(@[User::ExcelFilename], ".xls", YEAR(getdate()) + ".xls")

  Regards,

  Brent

   

• Brent Landry

  Mr or Mrs. 500

  Points: 504

  More actions

  October 25, 2006 at 2:10 pm

  #667997

  I found the solution to my problem on this thread:

  http://www.sqlservercentral.com/forums/printtopic.aspx?forumid=148&messageid=260038

  Microsoft should post what expressions are valid in the expression builder.

  -Brent