Home Forums Data Warehousing Integration Services package doesn't run when moved to production server RE: package doesn't run when moved to production server

  • February 11, 2016 at 6:26 am

    #1857995

    I am running it from a stored procedure, not a job so I think it is using the SQL Server service, not the agent service.

    I did notice that the package in BIDS had the CreatorComputerName set to the QA machine and the CreatorName set to my username. Once I changed that to the production server and the system account many of the errors were removed but they were replaced by the following which I am investigating now.

    An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.".