• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Project Extension Points

The Project category has the following available Extension Points defined.

Project Parameter

Add additional parameters to a Project. This only applies to SSIS deployments.

Template

<#@ extension bundle="BimlFlex.bimlb" extensionpoint="ProjectParameter" #>

<Parameter Name="ServerName" DataType="String" IsRequired="true">localhost</Parameter>
<Parameter Name="UserName" DataType="String" IsRequired="true">varigence</Parameter>
<Parameter Name="UserPassword" DataType="String" IsRequired="true">P@ssw0rd!</Parameter>

Project Script File

Add a ScriptTask or ScriptComponent to a Project. This only applies to SSIS deployments.

Parameters

Name
Type Description
project BimlFlexModelWrapper.ProjectsWrapper Contains all information related to the project to which the script will be added

Template

<#@ extension bundle="BimlFlex.bimlb" extensionpoint="ProjectScriptFile" #>
<#@ property name="project" type="BimlFlexModelWrapper.ProjectsWrapper" #>


<ScriptTaskProject ProjectCoreName="SC_SAMPLE_SCRIPT" Name="SC_SAMPLE_SCRIPT">
	<AssemblyReferences>
		<AssemblyReference AssemblyPath="Microsoft.SqlServer.ManagedDTS.dll" />
		<AssemblyReference AssemblyPath="Microsoft.SqlServer.ScriptTask.dll" />
		<AssemblyReference AssemblyPath="System.dll" />
		<AssemblyReference AssemblyPath="System.AddIn.dll" />
		<AssemblyReference AssemblyPath="System.Data.dll" />
		<AssemblyReference AssemblyPath="System.Windows.Forms.dll" />
		<AssemblyReference AssemblyPath="System.Xml.dll" />
	</AssemblyReferences>
	<Files>
		<File Path="ScriptMain.cs">using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;

[Microsoft.SqlServer.Dts.Tasks.ScriptTask.SSISScriptTaskEntryPointAttribute]
public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase
{
	#region VSTA generated code
	enum ScriptResults
	{
		Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
		Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
	};
	#endregion

	public void Main()
	{
		MessageBox.Show("Sample Script File");
		Dts.TaskResult = (int)ScriptResults.Success;
	}
}
		</File>
	</Files>
</ScriptTaskProject>

© Varigence