Solved

Copy the file Using Script Task.

Posted on 2012-04-12
1
930 Views
Last Modified: 2012-04-15
Hi Experts,


I want to copy the file (located in ftp share folder) to my local machine using the script task in C#(SSIS 2008).

I have tried using the File System Task and used the operation Copy , it is moving the file instead of copying the file.

FTP task , I don't want to use as I need to set up the FTP Connection and  our company policy doesn't allow to  use ftp .

So could you please provide me the custom  code to copy a file from  a FTP Share Folder
to my local machine using the Script Task (C#)

Regards,

Sreekanth.
0
Comment
Question by:n_srikanth4
1 Comment
 
LVL 11

Accepted Solution

by:
SThaya earned 500 total points
Comment Utility
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now