Hi, I am comparing the data and manually inserting via ssis package, so I can see one or two been inserted into the table.

I will try more with the data...

Sorry, I am not able to deploy it as a package. I have to create a different solution etc to make it do.

I had done error handling also, but there...

I am running the package via file system.

I have server admin access to the server.

If I execute the package via SSDT or from the folder(after double clicking on it) ,...

yes

I cannot see any difference between the data. Its consistence with the ignore list of the data.

I had checked the data.

When I run the ssis package via SSIS package it runs without any issues.

But the same package I am running, its not getting the full data....

Thank you Steve.

I have live SQL 2000 servers as the application is too old one and cannot be upgraded with newer version of the application. I am not sure if...

Thank you for the suggestion. Appreciate your response.

I am trying to make the SQL 2014 ODBC(SIC) subscriber, but not able to so.

The link is not the thing what I am...

Hi,

Thank you all for  all  replies.:-) 

1. The database size got increased by 160 GB because of the Change Tracking tables. Change tracking has been disabled.
2....

I know i also hve lots of questions based on this. Thats why I am looking or seeking help to know from other experiences that we can use.

SSIS is the only option I have know what will be helpful for me. I wanted to know, if anybody had used any other tool for data migration and merge.:-)

Thank you Steve. But this tool is not the solution what i am looking for.

1. The Redgate tool did not supported SQL 2000 :crying:

2. Its comparing the database. I...

Thank you Luis for the quick reply.

The query does give me a count, but i wanted historical growth. Like, we can get for the database growth from the backupset....