SSIS package run on sql job

Posted on 2014-08-25
Last Modified: 2016-02-11
 i try to run a SSIS package on sql server 2005, the package runs on SSIS, but when i put into server and run from the server i got  ConnGetProxyPassword error,
i create a Proxy account, it's my network ID, and i have admin rights on the server, thanks for your help.
Question by:tristonyip
    LVL 3

    Expert Comment

    having admin rights on the server does not always mean you have admin rights in SQL Server. If your AD/network id was not added as an admin during sql server installation then you may not have full admin rights.

    this kb should help:
    LVL 21

    Expert Comment

    by:Alpesh Patel

    you can check my below article to run ssis package from SQL agent using proxy.

    Accepted Solution

    i finally go this  work. upgrade sql service pack.

    Author Closing Comment

    this works finally.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    732 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now