SSIS Expression Builder - cannot conver to string

  • 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

     

  • 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

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

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