Hello, I'm having trouble with the SQL 2008 Package Installation Wizard. When I try and deploy the packages using the wizard (I have about a dozen and want to save time by using the wizard), I get the following error: =================================== Unexpected error occurred. (Package Installation Wizard) =================================== Unable to find an entry point named 'DTSSKUIsWKGorUnder' in DLL 'dts'. (DTSInstall) ------------------------------ Program Location: at Microsoft.SqlServer.Dts.Deployment.NativeMethods.DTSSKUIsWKGorUnder() at Microsoft.SqlServer.Dts.Deployment.PackageInstallationWizardForm..ctor() at Microsoft.SqlServer.Dts.Deployment.PackageInstaller.Main(String[] args) Dave SQL Developer

Please try regestering DTS.dll located in C:\Program Files\Microsoft SQL Server\90\DTS\Binn\ folder using REGSVR32.exe Pradeep Adiga Blog: sqldbadiaries.com

Hi Dave, The issue you mentioned is a little similar to the following known issue: http://support.microsoft.com/kb/957803 Could you please try to up the SQL Server Integration Services to date, and check if the issue is solved? The latest hotfix for SQL Server 2008 is: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=8fbfc1de-d25e-4790-88b5-7dda1f1d4e17&displaylang=en Thanks, Jin ChenJin Chen - MSFT

Hi Jin, Although this article is helpful, I am using SQL 2008 R2. This patch is for SQL 2008. I researched SP1 for SQL Server 2008 R2, but it doesn't seem like it has been released yet. ThanksDave SQL Developer

Hi There, Not sure if you still have this issue, but I also had this issue with my local SQL Server 2008 R2 (express) installation. Registering dlls etc didn´t work for me, but running the 32-bit version of dtsinstall.exe did. "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtsinstall.exe" "<path to your .SSISDeploymentManifest file>" By default I think the .SSISDeploymentManifest files are opened by the 64-bit dtsinstall.exe in "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtsinstall.exe" which I haven't been able to get to work, always giving me the "Unable to find an entry point named 'DTSSKUIsWKGorUnder' in DLL 'dts'. (DTSInstall)" error. Hope this helps, Das

Hi, you have to edit that on your registry. go to HKEY_CLASSES_ROOT\IntegrationServices.DeploymentManifest.100\shell\open\command, then change from "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtsinstall.exe" "%1" to "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtsinstall.exe" "%1 thanks

Hi There, Not sure if you still have this issue, but I also had this issue with my local SQL Server 2008 R2 (express) installation. Registering dlls etc didnt work for me, but running the 32-bit version of dtsinstall.exe did. "C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\dtsinstall.exe" "<path to your .SSISDeploymentManifest file>" By default I think the .SSISDeploymentManifest files are opened by the 64-bit dtsinstall.exe in "C:\Program Files\Microsoft SQL Server\100\DTS\Binn\dtsinstall.exe" which I haven't been able to get to work, always giving me the "Unable to find an entry point named 'DTSSKUIsWKGorUnder' in DLL 'dts'. (DTSInstall)" error. Hope this helps, Das This worked for me. Thanks!

Dave, I unmarked this thread as abusive. I can simply delete it. Besides, you may want to mark one or all of the replies as answers.Arthur My Blog