Post reply

Deploying my SSIS packages.

  • October 15, 2014 at 3:03 pm

    #297512

    I'm pretty new to all this so please bear with me. I developed an SSIS package that imports data from an Access database to a table in sql server. The package and all its connection work fine and I am able to run the package from Visual Studio itself however when i go through the Import Package and Deploy Package wizards in SSMS and I try to execute said package it wont work citing a failure in connection. I have also tried running in 32 and 64 bit with the same result. Additional notes. Using SQL Server 2012 and developed the package locally. I know I'm missing something major here i just dont know what it is. Any advice would be much appreciated.

    THANK YOU!

  • October 16, 2014 at 1:16 am

    #1752740

    When you run the package locally you obviously have the required permissions to access the databases involved. When you run it from the server that you exported it to, the account that it runs under will also need those permissions. Check that first.

    Steve Hall
    Linkedin
    Blog Site

  • October 16, 2014 at 1:21 am

    #1752742

    What is the exact error message?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 16, 2014 at 7:17 am

    #1752852

    Thank you very much. I will address that right away!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply