I am facing problem while using Transfer SQL Server Object Task in SSIS, it is not importing table & its attributes.
The details settings of Transfer SQL Server Object Task as follows:
clicking edit - Objects(left pane) 
Right pane
 Connection 
 Source Connection existing server name 1
 Source Database ganny1
 Destination Connection existing server name 1
 Destination Database ganny2
 Destination copy objects
 Objects to copy - copy all tables - true
 Table Objects
 CopyPrimaryKeys - True
 CopyForiegnKeys - True
After setting all this configurations, Executing task, I am not able to get table in my destination database.
Please suggest me to solve the issue.
Thanks in advance
Karna
What is the value of CopySchema? If it's false, trying setting it to true.
 
No comments:
Post a Comment