﻿<?xml version='1.0' encoding='UTF-8'?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/"><channel><title>SQLServerCentral / SQL Server 2005 / SQL Server 2005 Integration Services  / Getting Error for Dynamic file name / Latest Posts</title><generator>InstantForum.NET v2.9.0</generator><description>SQLServerCentral</description><link>http://www.sqlservercentral.com/Forums/</link><webMaster>notifications@sqlservercentral.com</webMaster><lastBuildDate>Mon, 20 May 2013 05:49:21 GMT</lastBuildDate><ttl>20</ttl><item><title>RE: Getting Error for Dynamic file name</title><link>http://www.sqlservercentral.com/Forums/Topic1367861-148-1.aspx</link><description>[quote][b]n79799 (10/9/2012)[/b][hr]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.[/quote]I think you meant Read/Write variables. Write-only variables have limited use.</description><pubDate>Wed, 10 Oct 2012 04:09:55 GMT</pubDate><dc:creator>Phil Parkin</dc:creator></item><item><title>RE: Getting Error for Dynamic file name</title><link>http://www.sqlservercentral.com/Forums/Topic1367861-148-1.aspx</link><description>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.</description><pubDate>Tue, 09 Oct 2012 12:36:23 GMT</pubDate><dc:creator>n79799</dc:creator></item><item><title>Getting Error for Dynamic file name</title><link>http://www.sqlservercentral.com/Forums/Topic1367861-148-1.aspx</link><description>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.......</description><pubDate>Wed, 03 Oct 2012 10:55:02 GMT</pubDate><dc:creator>murali.ms18</dc:creator></item></channel></rss>