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?