Hi, thanks for the reply.
I am not familiar with SSIS. Is there other way to transfer the data maintaining the structure of the tables?