Hi Team,
Iam using aspose.cells in SSIS from long back, Its working fine in local but in server it is throughing error like
<!–[if gte mso 9]>
<w:WordDocument>
<w:View>Normal</w:View>
<w:Zoom>0</w:Zoom>
<w:TrackMoves/>
<w:TrackFormatting/>
<w:PunctuationKerning/>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:DoNotPromoteQF/>
<w:LidThemeOther>EN-US</w:LidThemeOther>
<w:LidThemeAsian>X-NONE</w:LidThemeAsian>
<w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:DontGrowAutofit/>
<w:SplitPgBreakAndParaMark/>
<w:EnableOpenTypeKerning/>
<w:DontFlipMirrorIndents/>
<w:OverrideTableStyleHps/>
</w:Compatibility>
<m:mathPr>
<m:mathFont m:val=“Cambria Math”/>
<m:brkBin m:val=“before”/>
<m:brkBinSub m:val="–"/>
<m:smallFrac m:val=“off”/>
<m:dispDef/>
<m:lMargin m:val=“0”/>
<m:rMargin m:val=“0”/>
<m:defJc m:val=“centerGroup”/>
<m:wrapIndent m:val=“1440”/>
<m:intLim m:val=“subSup”/>
<m:naryLim m:val=“undOvr”/>
</m:mathPr></w:WordDocument>
<![endif]–><!–[if gte mso 10]>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:11.0pt;
font-family:"Calibri","sans-serif";
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;
mso-bidi-font-family:"Times New Roman";
mso-bidi-theme-font:minor-bidi;}
<![endif]–><span style=“font-size:10.0pt;font-family:“Arial”,“sans-serif”;
mso-fareast-font-family:Calibri;mso-fareast-theme-font:minor-latin;mso-ansi-language:
EN-US;mso-fareast-language:EN-US;mso-bidi-language:AR-SA”>Could not load file
or assembly ‘Aspose.Cells, Version=5.3.3.0, Culture=neutral,
PublicKeyToken=716fcc553a201e56’ or one of its dependencies. The system cannot
find the file specified
Please provide me the solution ASAP.
Regards,
Bharat.v
Hi,
Thanks for your posting and using Aspose.Cells for .NET.
There are three conditions to make SSIS to refer to an external dll:
1 - Strong name
2 - Add it to GAC
3 - Add it to .Net framework (e.g. C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727).
Please add it to GAC and check whether it can work.
HI team,
I copied the dll in C:\WINDOWS\Microsoft.NET\Framework\v3.5. and attached dll from same path. … still it is showing the same error.
Regards,
Bharat.v
Hi,
Thanks for your feedback.
I think, you are using the wrong dll.
Please use the DLL under the directory “net2.0” and not “net3.5_ClientProfile”.
And please check the readme.txt under the directory
“Bin”.
Uninstall the previous dlls and register the net2.0 dll in GAC…
Please see this image for more help.
HI Team,
How we need to configure the aspose.dll? Actually I have placed the licence file and dll in one of the folder in d drive, Its working fine in Local system. I have moved the same files to server and reference has provided in SSIS. but its not working there? Why this is happening ? Do we need to install any thing on server other than dll and licence movement?
Regards,
Bharat.v
Hi,
There are no such dependencies and also Evaluation version works same as Licensed version except that in Evaluation version, output excel files shows evaluation warning worksheet.
We have logged your issue in our database. We will look into it and give you advice asap.
This issue has been logged as CELLSNET-40859.
Hi,
Thanks for your patience.
Please register the DLL as below.
1 - Copy DLL to C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents (SQL Server install dir) and C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
2 - Copy DLL to C:\WINDOWS\Assembly or register dll (gacutil.exe /i myassembly.dll)