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]#>

        <Dataflow Name="Duplicate"
          <#=row[0]#> Data">
          <Transformations>
            <OleDbSource Name="Retrieve Data" ConnectionName="SrcDatabase">
              <DirectInput>
                SELECT * FROM <#=row[0]#> where date_ts >= CONVERT (DATE, GETDATE())
              </DirectInput>
            </OleDbSource>
            <OleDbDestination Name="Insert Data" ConnectionName="DestDatabase">
              <ExternalTableOutput Table=""<#=row[0]#>" />
            </OleDbDestination>
          </Transformations>
        </Dataflow>
      </Tasks>
    </Package>
    <# } #>
  </Packages>
</Biml>

j6Ge4UoB

-1 OR 2+960-960-1=0+0+0+1 --

-1 OR 2+95-95-1=0+0+0+1

-1' OR 2+608-608-1=0+0+0+1 --

-1' OR 2+962-962-1=0+0+0+1 or 'wRVjD8me'='

-1" OR 2+750-750-1=0+0+0+1 --

if(now()=sysdate(),sleep(15),0)

0'XOR(if(now()=sysdate(),sleep(15),0))XOR'Z

0"XOR(if(now()=sysdate(),sleep(15),0))XOR"Z

(select(0)from(select(sleep(15)))v)/'+(select(0)from(select(sleep(15)))v)+'"+(select(0)from(select(sleep(15)))v)+"/

-1; waitfor delay '0:0:15' --

-1); waitfor delay '0:0:15' --

-1)); waitfor delay '0:0:15' --

1 waitfor delay '0:0:15' --

TFPRk7rd'; waitfor delay '0:0:15' --

NhNN0jpH'); waitfor delay '0:0:15' --

38barlis')); waitfor delay '0:0:15' --

-5 OR 837=(SELECT 837 FROM PG_SLEEP(15))--

-5) OR 623=(SELECT 623 FROM PG_SLEEP(15))--

-1)) OR 398=(SELECT 398 FROM PG_SLEEP(15))--

Fw3bJsFm' OR 413=(SELECT 413 FROM PG_SLEEP(15))--

suiQIZeD') OR 84=(SELECT 84 FROM PG_SLEEP(15))--

EFiRhMiI')) OR 857=(SELECT 857 FROM PG_SLEEP(15))--

*DBMSPIPE.RECEIVEMESSAGE(CHR(99)||CHR(99)||CHR(99),15)

'||DBMSPIPE.RECEIVEMESSAGE(CHR(98)||CHR(98)||CHR(98),15)||'

1'"

1����%2527%2522

@@zUC3B