Im using BIML to dynamically create load packages for SSIS to load data from Informix to SQL Server. The problem is that this BIML code produces the SQL below
<DirectInput>SELECT <#=table.GetColumnList()#> FROM <#=table.GetTag("SourceSchemaQualifiedName")#></DirectInput>
SELECT [column1], [column2], [column3], FROM [mySchema].[mySrcTable]
But that doesnt work in my source database because of the brackets. Any way i can get the columnlist & tablename without the brackets dynamically?