• What is the alternative if you are calling the package from a stored procedure?

    I use this method becuase you can pass in the variables @@servername and db_name() to the package (via the command line and xp_cmdshell), then you could have 100 different databases all with different names on different servers using the same generic package.

    Regards,

    Andy Jones

    .