• nihal9200_kwada (4/1/2013)


    Open ssis package in BIDS

    Package properties

    creator name is old DBA

    creator name is different than owner name?

    No, different. I thought that might be what you were looking at. The value of that Package property is irrelevant. You could set it to anything you like, even an empty string, and it wouldn't affect anything in terms of security during execution.

    More important is that the previous DBA's Server Login does not own any databases or SQL Agent jobs.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato