MS SQL 2005 SP2 x64 & SSIS Packages

On my local desktop, I can create and run ssis packages, when I try to do the same thing on server I get he following error right clicking on running packages or stored packages.

failed to retrieve data for this request. Library not Registered. (exception from HRESULT: 0x8002801D

there are 2 instances of SQL on this server. Both are named with one being use by SQLExpress and the other by SQL2005 Std

Give this a try; Integration Services installs just once no matter how many instances are installed on the machine. For the instance you are wishing to work with you can change the instance viewed by modifying C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml

Change the entry below to match your instance name.

--Prior to change

<ServerName>.</ServerName>

--After change

<ServerName>MySQLServer\MySQLInstancename</ServerName>

|||

Hi,

This is setup problem, partially discussed in this KB: http://support.microsoft.com/kb/919224

If reapplying SP2 to both instances does not work, please run the following command to manually fix it (the KB is to be modified soon):

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll”

|||Still no luck|||

I'm still getting same error. I do not have the hotfix installed do I need it?

Microsost SQL Server Management Studio

Failed to retrieve data for this request. ( Microsoft.SqlServer.SmoEnum)

Additional Information:

Library not registered.( Exception from HRESULT: 0x80002801D(TYPE_E_LIBNOTREGISTERED))

(Microsoft.SqlServer.DTSRuntimeWrap)

Library not registered.( Exception from HRESULT: 0x80002801D(TYPE_E_LIBNOTREGISTERED))

(Microsoft.SqlServer.DTSRuntimeWrap)

MS SQL 2005 SP2 x64 & SSIS Packages

On my local desktop, I can create and run ssis packages, when I try to do the same thing on server I get he following error right clicking on running packages or stored packages.

failed to retrieve data for this request. Library not Registered. (exception from HRESULT: 0x8002801D

there are 2 instances of SQL on this server. Both are named with one being use by SQLExpress and the other by SQL2005 Std

Give this a try; Integration Services installs just once no matter how many instances are installed on the machine. For the instance you are wishing to work with you can change the instance viewed by modifying C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml

Change the entry below to match your instance name.

--Prior to change

<ServerName>.</ServerName>

--After change

<ServerName>MySQLServer\MySQLInstancename</ServerName>

|||

Hi,

This is setup problem, partially discussed in this KB: http://support.microsoft.com/kb/919224

If reapplying SP2 to both instances does not work, please run the following command to manually fix it (the KB is to be modified soon):

%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll”

|||Still no luck|||

I'm still getting same error. I do not have the hotfix installed do I need it?

Microsost SQL Server Management Studio

Failed to retrieve data for this request. ( Microsoft.SqlServer.SmoEnum)

Additional Information:

Library not registered.( Exception from HRESULT: 0x80002801D(TYPE_E_LIBNOTREGISTERED))

(Microsoft.SqlServer.DTSRuntimeWrap)

Library not registered.( Exception from HRESULT: 0x80002801D(TYPE_E_LIBNOTREGISTERED))

(Microsoft.SqlServer.DTSRuntimeWrap)

MS ReportViewer 2.0 Control Print Issue

The first attempt to print a report by clicking the print button on the MS
report viewer icon does not print. Subsequent clicks will print the report!
This is happening on all computers the application is deployed to. I look at
the print queue and I see that the job is spooled and I also get the taskbar
notification. I have tested numerous other applications and all print on
first attempt.
Thanks in advance,
AshkanOn Tue, 18 Apr 2006 17:39:13 -0700, "Ashkan Daie" <adaie@.nospam.com>
wrote:
>The first attempt to print a report by clicking the print button on the MS
>report viewer icon does not print. Subsequent clicks will print the report!
>This is happening on all computers the application is deployed to. I look at
>the print queue and I see that the job is spooled and I also get the taskbar
>notification. I have tested numerous other applications and all print on
>first attempt.
>Thanks in advance,
>Ashkan
>
You're right, it doesn't work the first time. It is apparently a bug.
I'm not sure if it works for anyone the first time but it sure doesn't
for me or these other people. It looks like the focus is stuck
somewhere else and any activity will move it to the print button,
includng pressing the print button, but that needs to be done first:
http://forums.microsoft.com/MSDN/showpost.aspx?postid=197115&siteid=1