SSIS Problem with Script Task
-
I wrote a fairly simple ssis package to check the existance of a file using the Script Task. I'm not sure why I'm getting the following error message:
SSIS package "Package.dtsx" starting.
Error: 0xC0014054 at Does File Exist: Failed to lock variable "\\10.2.1.50\usr\ftpsta\Prod\Outbound\WeeklyDelivered_07232012.txt" for read access with error 0xC0010001 "The variable cannot be found. This occurs when an attempt is made to retrieve a variable from the Variables collection on a container during execution of the package, and the variable is not there. The variable name may have changed or the variable is not being created.".
Error: 0x5 at Does File Exist: The script files failed to load.
Task failed: Does File Exist
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (3) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "Package.dtsx" finished: Failure.
The program '[24112] Package.dtsx: DTS' has exited with code 0 (0x0).
-
Did you add your variable to the Script Task's 'ReadOnlyVariables' property?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin -
It looks like you are modifying a reference to a variable with expression, which is incorrect. You have to setup variable which value is dynamically modified with expression.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
thanks for your help. I'm sure you are correct.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply