Getting Error for Dynamic file name

• murali.ms18

  SSC Journeyman

  Points: 98

  More actions

  October 3, 2012 at 10:55 am

  #282511

  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.......

• n79799

  SSC Eights!

  Points: 804

  More actions

  October 9, 2012 at 12:36 pm

  #1547336

  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.

• Phil Parkin

  SSC Guru

  Points: 247158

  More actions

  October 10, 2012 at 4:09 am

  #1547564

  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.

  ---