Error on Deploying the SSIS packages to MSDB Store in 2008

• sabarichandru

  SSCommitted

  Points: 1704

  More actions

  December 28, 2010 at 10:38 pm

  #229103

  Hi Friends,

  How are you .. hope everybody doing good .

  Todat i tried deploying the SSIS packages in MSDB Store . but while deploying it shows some errors. i have pasted below.

  But i have deployed many packages in the same MSDB store but only this particular package throwing this kind of error .

  Error:

  Error : BIDS Helper encountered an error when deploying package DIM_COLLECTOR.dtsx!

  "C:\Program Files\Microsoft SQL Server\100\DTS\binn\dtutil.exe" /FILE "C:\HEXAWARE_BI\Sabari\TFS\SSIS\IT\InformationSystem\AR_REPO_PROJECT\AR_REPO PROJECT\DIM_COLLECTOR.dtsx" /DestServer GLS1DESQL01 /COPY DTS;"MSDB\MIS\AR Reports\DIM_COLLECTOR" /Q

  exit code = 6

  Microsoft (R) SQL Server SSIS Package Utilities

  Version 10.0.1600.22 for 32-bit

  Copyright (C) Microsoft Corp 1984-2004. All rights reserved.

  Error (0x80040E14) saving package "MSDB\MIS\AR Reports\DIM_COLLECTOR" to the SSIS package store.

  Description: Access to Integration Services package 'DIM_COLLECTOR' is denied.

  Source: Microsoft SQL Server Native Client 10.0

  Anybody help me out from this issue .

  Thanks in Advance

  Regards,

  Sabarinathan

• Marimuthu-129612

  Hall of Fame

  Points: 3266

  More actions

  December 28, 2010 at 11:56 pm

  #1267035

  are you member of db_dtsadmin role for that instance ?

  Please refer below link for further details

  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/8b491f05-8af1-4e74-8cb3-972aea20cce5/