Error Output's Description

Question

Error Output's Description

vithasun

Mr or Mrs. 500

Points: 538
More actions
February 12, 2010 at 1:23 pm

#141282

Hi,
I have download Error Output's Description custom component from codeplex.
following is the link
http://eod.codeplex.com/
I copied the erroroutputdescription.dll in the C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\
and ran the "Install" bachfile.
then from the BI studio, when to "Tools " tab and then "Choose Toolbox Items" then when I am tryin to add that errordescriptioncomponent from ssis dataflow items, I could not find that.
I am I doing anything wrong in adding this custom component.
please tell me if anybody have idea about it.
Thanks alot for your help.
veena

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

anna.ellis@getronics.com Default port Points: 1465 More actions · Answer 1

First, check your Windows\Assembly directory (usually C:\Windows\assembly) to see if the dll is present.

If it isn't you need to open a command prompt with Run As Administrator, then use gacutil to register the dll. The syntax is gacutil /i "<pathname of dll>". Running gacutil in a non-admin command prompt won't work.

You should then be able to see your new dll when you re-open BIDS and select Choose Items within the Toolbox.

vithasun Mr or Mrs. 500 Points: 538 More actions · Answer 2

Thanks Rookie,

I tried alot,but I am going somewhere wong in the path.

Could you please check this.

In my system, I have gacutil.exe file is there in this path "C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322"

and my errorOutputDescription.dll and is in this path

"D:\migrationproject\ErrorOutputDescription_2008_V2.0.0\"

I tried with this command in the command prompt.

D:\migrationproject\ErrorOutputDescription_2008_V2.0.0\ErrorOutputDescription.dll gacutil/i "C:\windows\Microsoft.NET\Framework\v1.1.4322"

but the error it is throwing is gacutil is not a recognized command.

Could you please correct me where I made mistake.

Thanks

Veena.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 3

vithasun (2/15/2010)
I tried with this command in the command prompt.
D:\migrationproject\ErrorOutputDescription_2008_V2.0.0\ErrorOutputDescription.dll gacutil/i "C:\windows\Microsoft.NET\Framework\v1.1.4322"
but the error it is throwing is gacutil is not a recognized command.

Maybe you could try the following command:

C:\windows\Microsoft.NET\Framework\v1.1.4322\gacutil /i D:\migrationproject\ErrorOutputDescription_2008_V2.0.0\ErrorOutputDescription.dll

(I'm not really sure, I have never used gacutil before)

After that, you could try to restart the Integration Services-service in your SQL Server Configuration Manager, sometimes that helps with issues like these.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

anna.ellis@getronics.com Default port Points: 1465 More actions · Answer 4

Very true, if gacutil isn't in your system path (C:\Windows\System32, for example), you need to provide the full pathname. Alternatively, copy gacutil.exe to your system path.

If you are using the dll as a SSIS component you do need to place that dll in the SSIS components directory, such as C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\ and you need to reference that directory in the gacutil commandline.

So, you need to run the command prompt as administrator, which should give you a prompt of:

C:\Windows\System32:>

and you type in either (command prompt location shown in italics, what you type is shown in bold):

C:\Windows\System32:>C:\windows\Microsoft.NET\Framework\v1.1.4322\gacutil /i "C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\ErrorOutputDescription.dll"

or (if you've copied gacutil to your system path):

C:\Windows\System32:>gacutil /i "C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\ErrorOutputDescription.dll"