Thread: Try it Chap 7
View Single Post
  #1 (permalink)  
Old May 28th, 2017, 08:39 PM
Armand21 Armand21 is offline
Registered User
Points: 15, Level: 1
Points: 15, Level: 1 Points: 15, Level: 1 Points: 15, Level: 1
Activity: 50%
Activity: 50% Activity: 50% Activity: 50%
 
Join Date: May 2017
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Try it Chap 7

Expression can not be evaluated
------------------------------
ADDITIONAL INFORMATION:

Attempt to parse the expression "@[User::DestinationFileLocation] + " \\ " + @[User::SourceFileName] _
(DT_WSTR, 4) DATEPART( yyyy, GETDATE()) + ( DT_WSTR, 2) DATEPART
( mm, GETDATE()) + (DT_WSTR, 2) DATEPART( dd, GETDATE()) + .txt" failed. The expression might contain an invalid token, an incomplete token, or an invalid element. It might not be well-formed, or might be missing part of a required element such as a parenthesis.

(Microsoft.DataTransformationServices.Controls)

------------------------------


PS

@[User::DestinationFileLocation] + " \\ " + @[User::SourceFileName] _
(DT_WSTR, 4) DATEPART( yyyy, GETDATE()) + ( DT_WSTR, 2) DATEPART
( mm, GETDATE()) + (DT_WSTR, 2) DATEPART( dd, GETDATE()) + .txt


PS

Hello all

Begin some help
I did my best checking almost every thing during 1 hour no way. I type it carefully no way. I copy and paste from E book no way

what is wrong with the expression

Page 64 chap 7
Reply With Quote