|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Sunday, May 24, 2009 8:42 PM
Points: 6,
Visits: 33
|
|
| You're welcome. Glad to be of help!
|
|
|
|
|
Right there with Babe
Group: General Forum Members
Last Login: 2 days ago @ 2:10 PM
Points: 731,
Visits: 443
|
|
| Most of the problems people are experiencing with using the FTP task here have nothing to do with the FTP task settings. I suggest that everyone look up the protection levels for SSIS packages.
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Monday, July 28, 2008 12:22 PM
Points: 87,
Visits: 147
|
|
| If I remember correctly, SSIS has a bug when it comes to 'put'ting data on a UNIX server. The last I heard from MS is that a fix will be in the service pack...Now, when does the service pack come out?
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, June 04, 2009 1:21 PM
Points: 3,
Visits: 12
|
|
Hi, I having that problem now. I am creating a SSIS package from VS 2005, but i 'd already tried the Properties advise but it didn't work, it keeps showing me the Password was not allowed.
Please help this is for a very important project.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Sunday, May 24, 2009 8:42 PM
Points: 6,
Visits: 33
|
|
How about giving some more details.
1 What properties are you setting on the connection manager?
2 Have you checked if your username has been blocked on the unix server due to past connection failures?
3 Can you connect with the same username /password with your usual windows FTP program?
4 Is the FTP Connection manager being configured using config files?
thanks.
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Monday, July 28, 2008 12:22 PM
Points: 87,
Visits: 147
|
|
Are you trying to connect to a UNIX FTP server? If so, I've heard that there's a problem when you try to "put" files. "Get" works fine, but nothing where writing to the server; this is apparently a known bug.
Make sure that you enter the password for the server, change the encryption to either EncryptAllWithPassword or EncryptSensitiveWithPassword, enter a password for the solution and save the solution BEFORE you try to run.
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, June 04, 2009 1:21 PM
Points: 3,
Visits: 12
|
|
Hi,
Thank you for your replies.
Well, here are my answers:
1. It is not a Unix FTP server it is a Windows server.
2. The user is not blocked.
3. Yes I use the properties of the Connection Manager, but the Encryptation stuff doesn't appear in the properties window.
4. The connection manager is not configured with a config file. How I do that, and where I can put .net Code to read it?
|
|
|
|
|
SSC Journeyman
Group: General Forum Members
Last Login: Monday, July 28, 2008 12:22 PM
Points: 87,
Visits: 147
|
|
| The encryption is one of the solution properties.
|
|
|
|
|
SSC Veteran
Group: General Forum Members
Last Login: 2 days ago @ 9:04 AM
Points: 259,
Visits: 842
|
|
Hi folks,
I haven't read in detail everything thats been said in this topic, but here is what I do to set the FTP password at runtime. I store the password in a variable and set the variable through a configuration. I always set my package encryption to DontSaveSensitive, so that other developers and accounts can execute the package provided they have access to the config tables in SQL Server.
Public Class ScriptMain
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Public Sub Main()
Dim FTPConnectionManager As ConnectionManager
'Set variable to an existing connection manager
FTPConnectionManager = Dts.Connections("FTP Server")
'Set connection manager property "ServerPassword"
FTPConnectionManager.Properties("ServerPassword").SetValue(FTPConnectionManager, Dts.Variables("FTPPassword").Value)
Dts.TaskResult = Dts.Results.Success
End Sub
End Class
Also, just wanted to add, that if you need full FTP functionality in your SSIS packages (Like ability to move a file from one FTP folder to another), you can use a script component implementing the wininet.dll
Kindest Regards,
Frank Bazan
proteanit.com
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Thursday, June 04, 2009 1:21 PM
Points: 3,
Visits: 12
|
|
Hi everyone,
Finally, it worked, but I am fighting with a new issue.
Let me explain the picture.
I receive a Flat file from a FTP server (the last issue), then i should import the information to a Table where the record will be send to Stored procedure.
One of the field in the Flat File it is a Date, and when i try to insert the record the error message says:
The Column OrdDate cannot be inserted because the convertion between DT_Date and DT_TIMESTAMP is not supported.
It is importan to say that the column in the table is a datetime value and no a time stamp.
Please advise.
|
|
|
|
