Sean,

If i am using ssis package to copy database from one server to another public server..

how securely i can achieve this...

- Like data will first should be imported into flat file and then it should be imported to public server..

- Another thing for security perspective i was thinking was pushing by one sql user having access to that database only.

Are there any other ways for securely doing ETL.

I was reading about TDE(Transparent Data Encryption). Is that helpful?