Error Compiling transformation Sfc.ISfcSupportsDesignMode

Dec 20, 2011 at 6:42 PM

Dear All --

I am getting this error message...

Error 6 Compiling transformation: The type 'Microsoft.SqlServer.Management.Sdk.Sfc.ISfcSupportsDesignMode' is defined in an assembly that is not referenced. You must add a reference to assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'.c:\Code\Team\Framework\CodeGeneration\_T4CodeUtility03Generator.tt 219 16 Team.Framework.CodeGeneration

...using T4ToolBox and T4 Templates and I cannot seem to find the right reference to use anywhere...

...do you have any clues?

Please advise.

Thanks.

-- Mark Kamoski

Dec 22, 2011 at 9:15 PM
Edited Dec 22, 2011 at 9:18 PM

All --

For anyone listening out there...

....I found a solution using absolute path referencing, as follows...

...I found references that I needed (for SMO), copied them out of the GAC, put them in a safe place, then used those locations in my references and here is what works now for me...

<#@ assembly name="C:\Code\SharedReferences\Microsoft.SqlServer.ConnectionInfo.dll" #>

<#@ assembly name="C:\Code\SharedReferences\Microsoft.SqlServer.Management.Sdk.Sfc.dll" #>

<#@ assembly name="C:\Code\SharedReferences\Microsoft.SqlServer.Smo.dll" #>

<#@ assembly name="System.Data" #>

<#@ import namespace="System" #>

<#@ import namespace="System.Data.SqlClient" #>

<#@ import namespace="System.Diagnostics" #>

<#@ import namespace="System.Collections" #>

<#@ import namespace="System.Collections.Generic" #>

<#@ import namespace="System.Collections.ObjectModel" #>

<#@ import namespace="System.Reflection" #>

...so I hope this helps.

(BTW, this is a cross-post duplicate that I made in another thread on this site because it turns out that 2 seemingly unrelated problems were solved by the same solution.)

Post Title: assembly with the same identity has already been imported

http://t4toolbox.codeplex.com/discussions/283625

Post Title: Error Compiling transformation Sfc.ISfcSupportsDesignMode


http://t4toolbox.codeplex.com/discussions/283641

 

Thanks and Merry Christmas!!!

-- Mark Kamoski