SSIS: Import Packages error

Question

I am on 9.0.4053 EE ,Default instance.

I am trying to import a SSIS package, Connected to the default IS, Right Click, MSDB, Import Package, gives the following error:

Unable to cast object of type 'Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction' to type 'Microsoft.SqlServer.Dts.ObjectExplorerUI.ISimpleAction'. (Microsoft.SqlServer.DtsObjectExplorerUI)

I have tried changing the MsDtsSrvr.ini.xml file to the default servername,reboot IS, nogo, I changed it back to '.', reboot IS, Nogo.

Its a default instance, Any help would be appreciated.

Answer 1

Hello,

Check if you have installed Integration Services on the instance.

I you have Integration Services installed, then try to re-register these two MSXML components using Command Prompt:

regsvr32.exe msxml3.dll

regsvr32.exe msxml6.dll

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hi Alberto,

Again you are the first one to reply to my question, thank you.

IS is installed on the server.
I re-registered the above 2 components which were installed successfully, tried again, no, rebooted IS & Database engine from SSCM, tried again, nogo.

Appreciate your help tho.

Answer 3

Hello,

If you need to import that SSIS package with urgency, then you can use the DTUtil. See some examples of the uses of this utility in the following link:

http://msdn.microsoft.com/en-us/library/ms162820(SQL.90).aspx

Glad to work with you again on solving a new issue.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

Hello Alberto,

I am having a look at the Utility. My Initial issue was:

I created maint plans (chkdb,rebuild & so on) in one prod server & had to replicate them on 4 other servers, the sub plans were diffeent & different maint plans for each db. Tx. jobs from BIDS didn't work as it doesn't tx. the package to the target MSDB in IS. Scripting them out also gave errors on target. I then thought of exporting the pkgs from source, where I encountered this issue.

It could take me some time to look at the utility, I might create the plans manually tho if it doesn't work.

Answer 5

Hello,

See the examples shown in the Web link above. It is no difficult to use the DTUtil, give it just a 15 minutes try.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 6

For now Alberto, I went ahead and created the maint plans manually on all other servers. I did not see many useful examples on MSDN or web for using dtutil, I will do some more research on it later on, time permitted. I am good for now.

Thanks for your help again!

Answer 7

I would like someone from Microsoft to have a look at this error & comment here.

Answer 8

I did not see many useful examples on MSDN or web for using dtutil

huh? i found plenty of useful examples on MSDN: http://msdn.microsoft.com/en-us/library/ms162820.aspx

hth

---

Duane Douglas, MCAD, MCITP | http://www.ssisbi.com | Please mark the post(s) that answered your question.

 

Answer 9

As I said, don't have much time to make dtutil work for me, If you have a cmd for tx. SSIS package from SSIS pkg store of one server to another, you can paste it here.

Answer 10

As I said, don't have much time to make dtutil work for me, If you have a cmd for tx. SSIS package from SSIS pkg store of one server to another, you can paste it here.

i would be more than happy to assist you if you had shown that you made some effort to use dtutil, but you didn't.  i'm a volunteer here, i don't get paid by microsoft, i have a busy schedule, and yet i still have time to help people.  i say this because i find it very hard to believe that you don't have any time to at least try to get dtutil to work...especially being that it's a very simple and easy tool to use.

---

Duane Douglas, MCAD, MCITP | http://www.ssisbi.com | Please mark the post(s) that answered your question.

Answer 11

Hi Duane,

Definately msdn can do a better job with the examples there. This is what I have tried so far:

dtutil /DTS "msdb\maintenance plans\testdtutil" /EXISTS    -- exists in package store, not one eg where they show the folders.

dtutil /DTS "msdb\maintenance plans\testdtutil" /COPY FILE;C:\testdtutil.dtsx 
-- encryption error, The package msdb\maintenance plans\testdtutil can not be saved to the file system since its protection level is server storage.  Use -- the encrypt action to change the protection level.

dtutil /DTS "msdb\maintenance plans\testdtutil" /ENCRYPT dts;"msdb\maintenance plans\testdtutil";0
-- gives option to overwrite the package, y, try copying again, same encryption msg, msdn doc says "DTS - This option is not supported currently", so --- don't think its going to work on package store.


Finally this worked,

dtutil /COPY DTS;"msdb\maintenance plans\testdtutil" /DTS "msdb\maintenance plans\testdtutil" /SOURCESERVER server1 /DESTSERVER server2

Not so straightforward, atleast for me, will do some more research on this, works tho, specially in my case where GUI was giving crazy errors.