Error when using dtutil to deploy SSIS packages

Posted: February 3, 2010 in dtutil, SQL 2005, SQL Error Messages, SSIS
BIDS Helper is deploying packages…
Deploying to SQL Server MSDB on server: NAMEOFSERVER
Error : BIDS Helper encountered an error when deploying package PACKAGENAME.dtsx!
“c:\Program Files\Microsoft SQL Server\90\DTS\binn\dtutil.exe” /FILE “PATHTOPACKAGE.dtsx” /DestServer NAMEOFSERVER /COPY SQL;”Package” /Q
exit code = 6
Microsoft (R) SQL Server SSIS Package Utilities
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2004. All rights reserved.
Could not save package “PACKAGE” because of error 0x80004005.
Description: Cannot open database “msdb” requested by the login. The login failed.
Source: Microsoft SQL Native Client

Had to give the user’s account access to msdb and the dts_admin and dts_operator roles.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s