• david.alcock (3/18/2013)


    Apologies, I am not sure what you are asking.

    If it what action to take next, then it depends on the requirements of the business perhaps. Is the data that you have moved still 'active', if so then yes you want the up to date data on there and perhaps some form of audit trail to determine the changes.

    As for saving the package, there is a specific area in msdb for packages that you can utilise when saving packages.

    David, can you tell me how did u perform this activity via SSIS... please explain in details

    ************************************
    Every Dog has a Tail !!!!! :-D