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

converting to numeric (6,3)

Hey guys,

I am trying to achive the following:

Truncate the values 1680.390000000000000000

to numeric (6,3)

All works ok until i hit a value over 1000, (as above)

The code i was using is:

cos1 = 1680.390000000000000000000

CONVERT (NUMERIC(6 , 3), ROUND(COS1, 3))

I have tried a few others, but nothing seems to work..

I get the following error. "Arithmatic Overflow"

Has anyone got any suggestions?

Thanks guys,

Scotty

A numeric(6,3) would only accept a number as large as 999.999 -six digits total, three digits to the right of the decimal.

Your value, 1680.xxxx exceeds the maximum size and creates an overflow condition -resulting in an error.

Perhaps you need a larger number, like maybe, just guessing here, numeric(8,3)?

|||

Brilliant!!!!

thanks vry much Archie.. this has been confusing me all day,, the way they explain it looks to me as 6 to the left, and 3 to the right...

Thanks again

Scotty