Click here to Skip to main content
15,867,835 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am new to SSIS package in Visual Studio. I have to transfer some tables from Client server SQL database to my Local server SQL database in order to do the same task i am using Transfer SQL Server Object Task what here i am encountering is that I have Read only Access in client Server database So that I am unable to select required tables from the SQL object Task.

What I have tried:

I am new to SSIS package in Visual Studio. I have to transfer some tables from Client server SQL database to my Local server SQL database in order to do the same task i am using Transfer SQL Server Object Task what here i am encountering is that I have Read only Access in client Server database So that I am unable to select required tables from the SQL object Task.
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900