Posted Tue, 18 Dec 2018 16:59:35 GMT by
Hi, I am getting error while generating the SSIS Package from BIML studio command line option using bimlc.exe command. If anyone can help me in resolving the issue would be very great-full. Please see the below error message: Error:: Metadata file 'Microsoft.SqlServer.DTSRuntimeWrap, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91, processorArchitecture=AMD64' could not be found Message: Could not find file 'C:\Users\Bharat.Bhandari\AppData\Local\Temp\115\tlkfpqul.uhn\SC8901dc85f5b24939aa1bd6aa82cb07e9.csproj.dll'. StackTrace: at System.IO.Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITYATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.File.InternalReadAllBytes(String path, Boolean checkHost) at Varigence.Biml.SsisEmitter.Translator.Components.ScriptComponentUtility.GetBinaryCodeProperty(AstNamedNode node, String projectCoreName, AstComponentScriptProjectNode scriptProject, Context context) at Varigence.Biml.SsisEmitter.Translator.Components.ScriptComponentUtility.ProcessScriptProperties(AstNamedNode node, String projectCoreName, AstComponentScriptProjectNode scriptProject, Component component, Context context) at Varigence.Biml.SsisEmitter.Translator.Components.Transforms.ScriptTransformationTranslator.Translate(AstScriptComponentTransformationNode node, IFrameworkItem parentItem, Context context) at Varigence.Biml.SsisEmitter.Translator.PlugIns.TranslatorManagement.Lower[TReturnType](AstNode node, IFrameworkItem parentItem, Context context) at Varigence.Biml.SsisEmitter.Translator.Tasks.DataflowTranslator.ProcessComponents(AstDataflowTaskNode node, Context context, IExecutable executable, Pipeline pipeline) at Varigence.Biml.SsisEmitter.Translator.Tasks.DataflowTranslator.TranslateDataflowTask(AstDataflowTaskNode node, IFrameworkItem parentItem, Context context) at Varigence.Biml.SsisEmitter.Translator.PlugIns.TranslatorManagement.Lower[TReturnType](AstNode node, IFrameworkItem parentItem, Context context) at Varigence.Biml.SsisEmitter.Translator.Containers.ContainerTranslator.ToSsisModel(IContainer container, AstContainerTaskBaseNode containerNode, Context context, Container designerContainer) at Varigence.Biml.SsisEmitter.Translator.ExecutableTranslator.ProcessExecutable(IExecutable executable, AstTaskNode taskNode, Context context, Container designerContainer) at Varigence.Biml.SsisEmitter.Translator.Containers.PackageTranslator.ToSsisModel(AstPackageNode packageNode, Context context, Boolean needsDesignerFile) at Varigence.Biml.SsisEmitter.SsisTranslatorPhase.EmitPackage(Context context, SsisProject project, AstPackageNode package, Int32 packageIndex, Int32 packagesCount) at Varigence.Biml.SsisEmitter.SsisTranslatorPhase.Execute(IIR predecessorIR) at Varigence.Flow.FlowFramework.Engine.Kernel.PhaseExecutionHost.Execute(EventWaitHandle executionWaitHandle) Fatal:: Internal Compiler Error: Workflow EmitSsis contains fatal errors. Phase execution halted. For assistance, please send Biml Compiler error messages to support@varigence.com. See other errors for more information. Thanks, Bharat Bhandari
Posted Sat, 11 May 2019 03:49:03 GMT by jacob alley
It appears as though you are trying to build a scriptcomponent or scripttask for a target version of ssis that you do not have on your machine. You either need to install the correct version of SSIS or lower the target version in the Project Settings to match the version that is currently installed on your computer.
Posted Sat, 11 May 2019 03:49:05 GMT by
Thanks Jacob for the clarification.

You must be signed in to post in this forum.