Forum Discussion

Bharat_Andalam's avatar
Bharat_Andalam
Copper Contributor
Feb 14, 2022

SSIS package Issue

I am trying to migrate the SSIS packages to new environment Azure Cloud, i have changed all the variables pointing to the new location but i get an error message that the location cant be accessed even though its local to the server.

  • deepakgupta86's avatar
    deepakgupta86
    Copper Contributor
    I believe you are using Azure IAAS VM. Please check the following things
    1) if backup file exists at the location under E drive path
    2) if you are running ssis under agent account then that agent account has access to the required file and location.

  • olafhelper's avatar
    olafhelper
    Bronze Contributor
    Which exact error message do you get?
    What is the package doing?
    Please provide more detailed information; just one sentence is really to less.
    • Bharat_Andalam's avatar
      Bharat_Andalam
      Copper Contributor

      olafhelper 

      Package is trying to backup and restore the SQL db, currently we are moving to Azure Cloud servers.

       

       

       

      • olafhelper's avatar
        olafhelper
        Bronze Contributor
        Please post the complete error message as text, not as a small, unreadable screenshot.

Resources