Problem installing the component from the source code

May 5, 2009 at 3:42 PM
I really need to update the app_config timeout and security settings of the utility.

Apart from regenerating the snk key files and referencing the sharepointutility dll again the application compiles from source without a problem in vs 2008. Gacutil runs fine also.

<P>------ Rebuild All started: Project: SharePointListAdapters, Configuration: Release Any CPU ------<BR>c:\Windows\Microsoft.NET\Framework\v3.5\Microsoft.Common.targets : warning MSB3061: Unable to delete file "C:\Sharepoint Adapter\main\SharePointListAdapters\Src\SharePointListAdapters\obj\Release\SharePointListAdapters.pdb". Access to the path 'C:\Sharepoint Adapter\main\SharePointListAdapters\Src\SharePointListAdapters\obj\Release\SharePointListAdapters.pdb' is denied.<BR>C:\Windows\Microsoft.NET\Framework\v3.5\Csc.exe /noconfig /nowarn:1701,1702 /errorreport:prompt /warn:4 /define:TRACE /reference:"C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.DTSPipelineWrap.dll" /reference:"C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SQLServer.DTSRuntimeWrap.dll" /reference:"C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.PipelineHost.dll" /reference:..\SharePointUtility\bin\Debug\SharePointUtility.dll /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Core.dll" /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Xml.dll /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Xml.Linq.dll" /debug- /filealign:512 /keyfile:sample.snk /optimize+ /out:obj\Release\SharePointListAdapters.dll /resource:Icons\SharePointSource.ico,Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.Icons.SharePointSource.ico /resource:Icons\SharePointDestination.ico,Microsoft.Samples.SqlServer.SSIS.SharePointListAdapters.Icons.SharePointDestination.ico /target:library Enums\BatchType.cs Enums\TrueFalseValue.cs GlobalSuppressions.cs PipelineProcessException.cs SharePointListDestination.cs SharePointListSource.cs Properties\AssemblyInfo.cs</P>
<P>Compile complete -- 0 errors, 0 warnings<BR>C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin\sgen.exe /assembly:"C:\Sharepoint Adapter\main\SharePointListAdapters\Src\SharePointListAdapters\obj\Release\SharePointListAdapters.dll" /proxytypes /reference:"C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.DTSPipelineWrap.dll" /reference:"C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SQLServer.DTSRuntimeWrap.dll" /reference:"C:\Program Files (x86)\Microsoft SQL Server\100\SDK\Assemblies\Microsoft.SqlServer.PipelineHost.dll" /reference:..\SharePointUtility\bin\Debug\SharePointUtility.dll /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Core.dll" /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.dll /reference:C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Xml.dll /reference:"c:\Program Files (x86)\Reference Assemblies\Microsoft\Framework\v3.5\System.Xml.Linq.dll" /compiler:/keyfile:sample.snk <BR>SharePointListAdapters -> C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\SharePointListAdapters.dll<BR>c:\Windows\Microsoft.NET\Framework\v3.5\Microsoft.Common.targets : warning MSB3061: Unable to delete file "C:\Sharepoint Adapter\main\SharePointListAdapters\Src\SharePointListAdapters\obj\Release\SharePointListAdapters.pdb". Access to the path 'C:\Sharepoint Adapter\main\SharePointListAdapters\Src\SharePointListAdapters\obj\Release\SharePointListAdapters.pdb' is denied.<BR>c:\Windows\Microsoft.NET\Framework\v3.5\Microsoft.Common.targets : warning MSB3061: Unable to delete file "C:\Sharepoint Adapter\main\SharePointListAdapters\Src\SharePointListAdapters\obj\Release\SharePointListAdapters.pdb". Access to the path 'C:\Sharepoint Adapter\main\SharePointListAdapters\Src\SharePointListAdapters\obj\Release\SharePointListAdapters.pdb' is denied.<BR>"C:\Program Files\Microsoft SDKs\Windows\v6.0A\bin\gacutil.exe" /if "C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\SharePointListAdapters.dll"<BR>Microsoft (R) .NET Global Assembly Cache Utility.  Version 3.5.21022.8<BR>Copyright (c) Microsoft Corporation.  All rights reserved.</P>
<P>Assembly successfully added to the cache<BR>Done building project "SharePointListAdapters.csproj".<BR>========== Rebuild All: 1 succeeded, 0 failed, 0 skipped ==========</P>The SharePointListAdapters.dll is output to the C:\Program Files\Microsoft SQL Server\100\DTS\PipelineComponents\ as part of the build.

However integration services cannot detect the dll for some reason from choose toolbox items>SSIS data flow items dialog. It spots it fine when I use the installer but not from the source code.

Any ideas what I am doing wrong here?
Coordinator
May 8, 2009 at 9:17 PM

Due to the way SSIS runs from Agent, a config file can't be used easily.  Those settings are set by the object model inside the adapters, search for Timeout and you'll be able to find them.

As for the build, VS looks at the folder called I think pipelinecomponents under the DTS folder.  Search for the DLL on your hard drive and you'll see where it put it (from the MSI).  Make sure you have the MSBuild copy the file to the proper folder when it's done, then restart VS and you should be able to see it.