October 3, 2012 at 10:55 am
Hey I am also working on same task like this In SSIS ftp task...
Here I created a variable for getting dynamic file name path for
"LOCAL PATH"..
@[User::LDirectoy] = "E:\LocalFilefolder\"
@[User::LZipFilePrefix] = "KK_"
@[User::LZipFileEndExtension] = ".rar"
@[User::LDirectoy]+ @[User::LZipFilePrefix] + (DT_STR, 4, 1252) DAY( DATEADD("dd", -1, GETDATE() ) )+"-"+RIGHT("0"+(DT_STR, 4, 1252) MONTH( GETDATE() ),2)+"-"+(DT_STR, 4, 1252) YEAR( GETDATE() )+ @[User::LZipFileEndExtension]
op: for this expression.." E:LocalFilefolder/KK_26-09-2012.rar"
while debugging i am getting
Error: Failed to lock variable "E:\LocalFilefolder\KK_26-09-2012.rar" 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.".
Any help will be apreciated.......
October 9, 2012 at 12:36 pm
I am assuming you are getting the error in a script task. That happens when you are trying to access a vraibale inside the script without first specifyinf it on the container in the
'ReadOnly Variables' and the 'WriteOnly Variables' section.
October 10, 2012 at 4:09 am
n79799 (10/9/2012)
I am assuming you are getting the error in a script task. That happens when you are trying to access a vraibale inside the script without first specifyinf it on the container in the'ReadOnly Variables' and the 'WriteOnly Variables' section.
I think you meant Read/Write variables. Write-only variables have limited use.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply