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

Converting Existing SSIS Packages to Biml

David Stein shows off a conversion tool built into BimlExpress: BimlExpress is a free Visual Studio add-in created by the good folks at┬áVarigence. Its a full featured Biml editor which allows you to dynamically create SSIS packages. It was first released back in 2017, and the latest version is 2019 (of course). The current version […]

Read More

Generating SELECT Statements with Biml

Cathrine Wilhelmsen shows the easy way to build out a SELECT statement with Biml: Biml column methods return code fragments. These code fragments can be used as building blocks to generate custom T-SQL statements. For example, the GetColumnList method returns a┬álist of columns, separated by commas, that you can use in a SELECT statement. You […]

Read More

Categories

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