Delimiters And Qualifiers In Biml

Kevin Feasel

2017-06-01

Biml

Ben Weissman explains three different techniques for specifying delimiters and qualifiers for flat files in Biml:

2. Use the Hex Code
If you know the ASCII Code of your qualifier, you can use it starting with “_x” and ending with “_”.
A ” would be described by “_x0022_” for example.

Click through for the other two, as well as a bonus side-by-side German translation.

Related Posts

Biml Enrichment With Annotations

Bill Fellows shows why it’s useful to include annotations in your Biml scripts: In many of the walkthroughs on creating relational objects via Biml, it seems like people skim over the Databases collection. There’s nothing built into the language to really support the creation of database nodes. The import database operations are focused on tables and schemas […]

Read More

Dealing With Limited Rights In Biml

Shannon Lowder walks through a scenario where he wants limited rights to process metadata changes, separate from any data transfer: My development environment has a local instance of SQL Server with AdventureWorks2014 on it.  I’m going to use that as my source.  I also created a database on this instance called BimlExtract to serve as […]

Read More

Categories

June 2017
MTWTFSS
« May Jul »
 1234
567891011
12131415161718
19202122232425
2627282930