This blog provides MSBI stuff and Interview Questions. And especially you can get a lot of blog's URL on SSIS,SSAS,SSRS &MOSS From different dedicators on MSBI.If you have any queries/concerns,please feel free to contact me at->msbimaster4u@gmail.com
Friday, January 30, 2009
Creating an FTP connection manager thru the Script Task:-
Public Sub Main() Dim result As Integer Dim manager As ConnectionManager Dim ftpClient As FtpClientConnection Dim foldersList As String() Dim filesList As String() manager = Dts.Connections("FTP") ftpClient = New FtpClientConnection( _ manager.AcquireConnection(Nothing)) Try If ftpClient.Connect() Then Call ftpClient.SetWorkingDirectory("/") Call ftpClient.GetListing(foldersList, filesList) ' Store files list in package variable. Call Dts.VariableDispenser.LockOneForWrite( _ "ResultVar", _ vars) Try vars("ResultVar").Value = filesList Finally Call vars.Unlock() End Try End If Catch ex As Exception result = Dts.Results.Failure Call Dts.Events.FireError( _ 0, _ String.Empty, _ ex.Message, _ String.Empty, _ 0) Finally Call ftpClient.Close() End Try Dts.TaskResult = resultEnd Sub ' Main
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment