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
GO

UPDATE sysssispackages
SET name='ImportPsPayrolltrans'
WHERE name='iMPORTpSpAYROLLTRANS'

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

Open in new window

0
 
BlueYonderCommented:
The process will require copying the job then deleting the previous.  The instructions for copying and deleting are on
http://www.mssqltips.com/sqlservertip/1428/import-export-copy-and-delete-ssis-packages/.  The easier way is to use SQL Business Intelligence Development Studio.
0
 
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?
0
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?
0
 
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.
0
 
Chuck WoodAuthor Commented:
Perfect answer. Thank you so much.
0
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.