|
Home > Archive > MS SQL Server DTS > January 2006 > SSIS - FTP Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| 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
@& #91;User::sRemotePat
h] in my FTP task. Why isn't this working?
Thanks.
| |
| Laura Zhang [MSFT] 2006-01-12, 7:23 am |
| 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 @& #91;User::sRemotePat
h].
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/te...erview/40010469
Others: https://partner.microsoft.com/US/te...upportoverview/
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:
> 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 @& #91;User::sRemotePat
h].
>
> 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/te...erview/40010469
> Others: https://partner.microsoft.com/US/te...upportoverview/
>
> 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.
>
>
>
| |
|
| 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,
>
> 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 @& #91;User::sRemotePat
h].
>
> 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/te...erview/40010469
> Others: https://partner.microsoft.com/US/te...upportoverview/
>
> 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.
>
>
>
| |
| Michael Cheng [MSFT] 2006-01-13, 7:23 am |
| 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.
| |
| Michael Cheng [MSFT] 2006-01-16, 7:23 am |
| 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@ONLINEmicroso
ft.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.
| |
| Jason 2006-01-17, 11:23 am |
| 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,
>
> 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@ONLINEmicroso
ft.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.
>
>
| |
| Michael Cheng [MSFT] 2006-01-18, 8:24 pm |
| 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,
>
> 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.
>
>
| |
| Michael Cheng [MSFT] 2006-01-23, 7:23 am |
| 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.
| |
| Jason 2006-01-23, 11:24 am |
| Michael,
I think my project must be corrupt. I did change it and I got the same
error. When I went back to check the variable, it was changed backed to what
I had prior to changing to User::sRemotePath.
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.
>
>
| |
| Michael Cheng [MSFT] 2006-01-24, 3:23 am |
| Hi Jason,
Do you have a backup? If you create a new project with the script, can you
execute the FTP task successfully?
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.
| |
|
| Michael,
It seems to be working fine now that I have create a new project. Thanks
for your help.
Jason
"Michael Cheng [MSFT]" wrote:
> Hi Jason,
>
> Do you have a backup? If you create a new project with the script, can you
> execute the FTP task successfully?
>
>
> 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.
>
>
>
>
| |
| Michael Cheng [MSFT] 2006-01-25, 3:27 am |
| Hi Jason,
You are welcome.
If you have any questions or concerns next time, 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.
|
|
|
|
|