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