1

Closed

Does not register

description

Hi Todd,
 
Thank you for creating the File Properties Task. It worked great on my laptop. But it does not work on the server. When dragged into a Foreach Loop Container, right clicked, and edit the following error occurs:
The task with the name "File Properties Task" and the creation name "ToddMcDermid.SSIS.FilePropertiesTask, FilePropertiesTask90, Version=1.0.0.0, Culture=neutral, PublicKeyToken=6c005605b216cf47" is not registered for use on this computer.
 
But the following error occurs when going to start, run, regsvr32 "C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\FilePropertiesTask90.dll" and clicking ok to register it:
The module "C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\FilePropertiesTask90.dll" was loaded but the entry-point DllRegisterServer was not found. Make sure that "C:\Program Files\Microsoft SQL Server\90\DTS\Tasks\FilePropertiesTask90.dll" is a valid DLL or OCX file and then try again.
 
Your assistance in resolving this will be greatly appreciated.
 
Sheryl
Closed Mar 25, 2010 at 8:27 AM by toddmcdermid

comments

toddmcdermid wrote Sep 16, 2009 at 8:39 PM

It appears as though you haven't properly installed the Task on your server. Here are the (manual) steps required to install it:
  1. Copy the FilePropertiesTask90.DLL to a subfolder in the SQL Server Program Files folder. In a standard installation, that's located at "%ProgramFiles%\Microsoft SQL Server\90\DTS\Tasks\"
  2. If your server is 64-bit, you will also need to copy the DLL to the 32-bit SQL Server Program Files folder. In a standard installation, that's located at "%ProgramFiles(x86)%\Microsoft SQL Server\90\DTS\Tasks\"
  3. Last but definitely not least, you need to register the DLL with Windows. However, this isn't a COM component, it's a .Net assembly. (A new world order for Windows.) Regsvr32 is for COM, and it registers DLLs into the Registry for Windows to locate. .Net components use the GAC (Global Assembly Cache), and need a program called GACUtil to install them. GACUtil is available as part of the .Net Framework SDK, downloadable from Microsoft. You may already have it on the server, or on another machine. All you need to do is run "GACUtil -i FilePropertiesTask90.DLL" from an administrator command line.

toddmcdermid wrote Oct 5, 2009 at 12:57 AM

I recently discovered an issue (haven't solved it yet) with my Pause Task - I'll be rechecking this task soon as well. It seems to have been an issue with the 2005 version.

toddmcdermid wrote Mar 25, 2010 at 8:27 AM

** Closed by toddmcdermid 3/25/2010 12:26 AM

toddmcdermid wrote Mar 25, 2010 at 8:27 AM