How To Rename SQL Server 2010 Import Package in msdb Database

How can I rename a SQL Server 2010 Import package in the msdb database?
LVL 16
Chuck WoodAsked:
Who is Participating?
Vitor MontalvãoMSSQL Senior EngineerCommented:
I see. Then you need to change the SSIS Package name and update all jobs that is calling that package:
USE msdb

UPDATE sysssispackages
SET name='ImportPsPayrolltrans'

UPDATE sysjobsteps
SET command=REPLACE(command,'iMPORTpSpAYROLLTRANS','ImportPsPayrolltrans')
WHERE subsystem='SSIS'

Open in new window

The process will require copying the job then deleting the previous.  The instructions for copying and deleting are on  The easier way is to use SQL Business Intelligence Development Studio.
Chuck WoodAuthor Commented:
Unfortunately, I do not have the SQL Business Intelligence Development Studio and I can only access the server through SQL Server Management Studio. I there a way to do it with an SQL query?
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Vitor MontalvãoMSSQL Senior EngineerCommented:
How did you create the import package? Using Import/Export wizard?
And how are you calling it?
Chuck WoodAuthor Commented:
Yes, I used the Import/Export wizard. I tried to call it ImportPsPayrollTrans but forget the caps lock was on and it was saved as iMPORTpSpAYROLLTRANS. If I could delete the improperly named package, I can easily recreate the package with a new name.
Chuck WoodAuthor Commented:
Perfect answer. Thank you so much.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.