Copy Flat File between two server; Help me please.

Hello All,

I want to copy flat file(.txt) from server to another server.

server A(Source Folder) ====> server B(Achive Folder)

Can I do it?

Please, help me.

Thank you very much.

Chonnathan

Do you want to perform this copy once or on a regular schedule? There are probably better utilities out there to perform this server-to-server copy, other than SSIS regardless.|||

Hi again,

Now, I want to use SSIS to process data from text(banking transactions, credit card) in daily process.

but source file was in another server.

In this case how can i do to get source file to precess in ssis on other server.

thank you very much.

My english skill is not well, sorry.

|||You'll have to use FTP or some other means of getting that file off of the source server. There is an FTP task in the control flow of SSIS. Or, if you can map a network drive to the source server, you can simply use a flat file source connection in the data flow against that mapped drive/file.|||

Great job,

Thank you for your helpful,

Regards,

Chonnathan

|||

Chonnathan Parnprom wrote:

Great job,

Thank you for your helpful,

Regards,

Chonnathan

I've I've answered your question, please mark it as answered using the "Mark as Answer" button.

Thanks,

Phil