RE: SSIS - FTP Error
- From: "Jason" <Jason@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2006 06:30:05 -0800
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 @[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/technicalsupport/supportoverview/40010469
> Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/
>
> 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.
>
>
>
.
- Follow-Ups:
- RE: SSIS - FTP Error
- From: Michael Cheng [MSFT]
- RE: SSIS - FTP Error
- References:
- RE: SSIS - FTP Error
- From: Laura Zhang [MSFT]
- RE: SSIS - FTP Error
- Prev by Date: RE: SSIS - "Import Column" failing with "Memory Error" ??
- Next by Date: RE: SSIS - FTP Error
- Previous by thread: RE: SSIS - FTP Error
- Next by thread: RE: SSIS - FTP Error
- Index(es):
Relevant Pages
|
