December 17, 2009 at 8:26 am
Hello,
Now I can iterate on ForeachLoopContainer.
The datas are inserted in the datawarehouse but there are errors in the final after executing with the type of the variable : User::nom_fic_log.
In each expression, I have put
Expression
Connection String
@[User::nom_fic_log]
After iterating I have the message :
"Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
"
Though it’s all right in executing.
At the end I have the messages
Error: The type of the value being assigned TO variable "User::nom_fic_log" differs FROM the current variable type. VARIABLES may NOT CHANGE type during execution. Variable types are strict, except FOR VARIABLES of type Object.
:blush:I don’t understand !
The variable : User::nom_fic_log is declared as “String”
Thanks if you can help me !:-)
December 17, 2009 at 11:05 am
[font="Comic Sans MS"]
How are you populating the variable values : User::nom_fic_log?
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
December 18, 2009 at 2:50 am
Hi Sabya,:-)
I have a Foreach Loop Container
In Collection
Folder C:\Mag SSIS\files
Files *.*
In Variable Mappings
Variable User::nom_fic_log
Index 0
And I have also a Data Flow Task
In Properties
ExecValueVariable User::nom_fic_log
nothing in Expression
ForceExecuteValueType String
My variable is declared at the package level
Name nom_fic_log
Scope LOAD Cascade sans Archive 3
Data Type String
Some extracts from messages
-----------------------
[Flat File Source [1]] Information: The total number of data rows processed for file "C:\Mag SSIS\files\app1_13-v9-exploit-mag-delegations_serverlog_090915.log" is 4811.
[Flat File Source [1]] Information: The processing of file "C:\Mag SSIS\files\app1_13-v9-exploit-mag-delegations_serverlog_090915.log" has ended.
[DTS.Pipeline] Information: "component "OLE DB Destination" (360)" wrote 4810 rows.
Task Chargement des Tables à partir des logs failed
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
-----------------------
[Flat File Source [1]] Information: The total number of data rows processed for file "C:\Mag SSIS\files\app1_13-v9-exploit-mag-delegations_webapplog_090915.log" is 5721.
[Flat File Source [1]] Information: The processing of file "C:\Mag SSIS\files\app1_13-v9-exploit-mag-delegations_webapplog_090915.log" has ended.
[DTS.Pipeline] Information: "component "OLE DB Destination" (360)" wrote 5721 rows.
Task Chargement des Tables à partir des logs failed
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
-----------------------
[Flat File Source [1]] Information: The total number of data rows processed for file "C:\Mag SSIS\files\app4_13-v9-exploit-mag-delegations_serverlog_090915.log" is 501.
[Flat File Source [1]] Information: The processing of file "C:\Mag SSIS\files\app4_13-v9-exploit-mag-delegations_serverlog_090915.log" has ended.
[DTS.Pipeline] Information: "component "OLE DB Destination" (360)" wrote 501 rows.
Task Chargement des Tables à partir des logs failed
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
-----------------------
[Flat File Source [1]] Information: The total number of data rows processed for file "C:\Mag SSIS\files\app4_13-v9-exploit-mag-delegations_webapplog_090915.log" is 11672.
[Flat File Source [1]] Information: The processing of file "C:\Mag SSIS\files\app4_13-v9-exploit-mag-delegations_webapplog_090915.log" has ended.
[DTS.Pipeline] Information: "component "OLE DB Destination" (360)" wrote 11670 rows.
Task Chargement des Tables à partir des logs failed
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
-----------------------
[Flat File Source [1]] Information: The total number of data rows processed for file "C:\Mag SSIS\files\app5_13-v9-exploit-mag-delegations_serverlog_090915.log" is 142.
[Flat File Source [1]] Information: The processing of file "C:\Mag SSIS\files\app5_13-v9-exploit-mag-delegations_serverlog_090915.log" has ended.
[DTS.Pipeline] Information: "component "OLE DB Destination" (360)" wrote 142 rows.
Task Chargement des Tables à partir des logs failed
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
-----------------------
[Flat File Source [1]] Information: The total number of data rows processed for file "C:\Mag SSIS\files\app5_13-v9-exploit-mag-delegations_webapplog_090915.log" is 11437.
[Flat File Source [1]] Information: The processing of file "C:\Mag SSIS\files\app5_13-v9-exploit-mag-delegations_webapplog_090915.log" has ended.
[DTS.Pipeline] Information: "component "OLE DB Destination" (360)" wrote 11435 rows.
Task Chargement des Tables à partir des logs failed
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
-----------------------
Stop (6)
Validation is completed
Start, 11:28:58
Finished, 11:31:48, Elapsed time: 00:02:49.485
------------------------------------
This message 6 times after executing
------------------------------------
Error: The type of the value being assigned to variable "User::nom_fic_log" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Finished, 11:31:48, Elapsed time: 00:02:49.485
-----------------------
The rows are all in the datawarehouse and the six files are treated,
in "[Flat File Source [1]] Information :" we can find the name of the file which is populating the variable
Thank you 😛
December 18, 2009 at 9:57 am
[font="Comic Sans MS"]
Sorry Pierre - somehow unable to understand it correctly. Can you please state what exactly you are trying to achieve through - I mean what is the requirement?
Meantime - you can see this useful video to debug :
http://www.sqlservercentral.com/articles/Video/64762/
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
December 18, 2009 at 11:30 am
Hi Sabya,
I found the problem which generated error messages at the end of the loading.:-P
As I could not reload the old packages after the problems of Visual Studio, I have to remake the complete procedures.
In Properties of Data Flow Task, on the Control Flow level, I made a mistake by initializing the item “ExecValueVariable” with my variable “User:: nom_fic_log” whereas it was necessary to leave this item to <none>… PFFFFFFFFFF!:Whistling:
If that can help somebody…
Have a good week-end !
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply