I have created a simple SSIS package that downloads a file from and FTP site
and inserts the data into a SQL Server DB table. I can get it to work if I
hard code the filename, but once I use a variable I get the following error:

Error at FTP Task: Failed to lock variable "<path and filename to my file on
remote server>" for read access with error 0xC0010001 "The variable cannot be
found"...

I have set the variable in the script task and have stepped through the
package to test the setting of this variable. I have also set the expression
property to
@[User::sRemotePath] in my FTP task. Why isn't this working?

Thanks.

Hi Jason,

Thank you for your posting.

If I understand properly, you created a SSIS package which downloads a file
from a FTP site and then inserts data into a SQL table. If you use a
variable you receive the error message saying that "Failed to lock
variable". You have set the variable in the script task and set the
experssion property to @[User::sRemotePath].

To create and use package variables, you can refer to the "Creating and
Using Package Variables" section of SQL Server 2005 Books Online:

http://msdn2.microsoft.com/en-us/library/ms136082.aspx

If this problem continues, please help us collect some information so that
we can perform further research on this issue:

1. How did you set the variable in the script task? Please describe it in
detail.
2. Please perform the following steps to take a screen shot of the error
message dialog box:

- When the error message appears, press Alt + Pr Scrn to capture a screen
shot. The Pr Scrn is a key on the keyboard. It normally locates above the
Insert key.
- From Start, go to Run, enter MSPAINT in the Open box, and then click OK.
- Use Ctrl + V to paste the screen shot to the canvas.
- From the File menu, go to Save and save as a JPG or BMP file. Please send
it to me at your earliest convenience.

If you have any updates, please feel free to let us know. We are glad to be
of assistance.

Have a nice day!

Best regards,

Laura Zhang
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
Business-Critical Phone Support (BCPS) provides you with technical phone
support at no charge during critical LAN outages or "business down"
situations. This benefit is available 24 hours a day, 7 days a week to all
Microsoft technology partners in the United States and Canada.

This and other support options are available here:
BCPS:
https://partner.microsoft.com/US/tec...rview/40010469
Others: https://partner.microsoft.com/US/tec...pportoverview/

If you are outside the United States, please visit our International
Support page: http://support.microsoft.com/common/international.aspx.

================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Laura,

Yes, you understand what I am trying to accomplish.

I am setting the variable in my script task using the following syntax:

Dts.Variables("sRemotePath").Value = sRemotePath

I did notice that the link you had sent uses a different way of setting a
variable. I tried that as well with the same error:

Dim pkg As Package = New Package
Dim varRemotePath As Variable = pkg.Variables.Add("sRemotePath", False,
"User", "/output/123005.xls")

I will send the error message and my script task code to you shortly.

Thanks,
Jason




"Laura Zhang [MSFT]" wrote:

Laura,

How do I send the image to you? I tried sending via email but it bounced
back because "the recipient's destination email system is unknown or invalid."

Jason

"Laura Zhang [MSFT]" wrote:

Hi Jason,

I have received the email you sent and I am looking into this issue and
will let you updated as soon as possible.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Jason,

Would you please generate a small sample project with which I could
reproduce it on my side? I understand the information may be sensitive to
you, my direct email address is v-mingqc (AT) ONLINEmicrosoft (DOT) com (make sure you
have REMOVE ONLINE before you click SEND), you may send the file to me
directly and I will keep secure. You may compress the project in a zipped
file

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Thanks Michael, I sent you an email a few minutes ago that contains all the
files. Let me know if you need anything else.

Jason

"Michael Cheng [MSFT]" wrote:

Hi Jason,

Yes, I received your email and looking into the project. It seems your
remote variable was used in a wrong way.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Michael,

How did I use it in the wrong way?

Jason

"Michael Cheng [MSFT]" wrote:

Hi Jason,

Please open the project in SQL Server Business Intelligence Management
Studio,
Double click FTP Task,
Click File Transfer on the left side,
Select User::sRemotePath in the RemoteVariable


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.