Getting Error for Dynamic file name

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Getting Error for Dynamic file name

Getting Error for Dynamic file name

Rate Topic

Display Mode

Topic Options

Author

Message

murali.ms18

Posted Wednesday, October 03, 2012 10:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, November 16, 2012 2:00 AM
Points: 7, Visits: 57

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

Post #1367861

n79799

Posted Tuesday, October 09, 2012 12:36 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 13, 2013 10:30 PM
Points: 35, Visits: 81

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.

Post #1370534

Phil Parkin

Posted Wednesday, October 10, 2012 4:09 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:13 AM
Points: 4,227, Visits: 9,460

n79799 (10/9/2012)

I think you meant Read/Write variables. Write-only variables have limited use.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1370815

« Prev Topic | Next Topic »

Permissions