Content

• Introduction
• Step-By-Step
• All - Function List
• Date Time Formatting Functions
• Number Formatting Functions
• HTML Table Formatting Functions
• Encode/Decode Functions
• JSON Encode/Decode Functions
• XML Encode/Decode Functions
• MD5 Hashing Functions
• HMAC Hasing Functions
• File Operation Functions
• Using direct string rather than variable
• Using variables inside direct string (Mixed mode placeholders)

Introduction

1. Input value from SSIS Variables.
2. Direct value.
3. Mixed mode Examples:

   {{User::varOrderDate, yyyy-MM-dd}}	
   	
   <<my lowercase string, FUN_TRIM>>
   {{User::varInputStr, FUN_TRIM}}
   
   <<a2V5MTIz||my input string, FUN_HMAC_MD5>>
   {{User::varInputStr, FUN_HMAC_MD5}}
   
   <<FUN_GETDATE>>
   <<yyyy-MM-dd, FUN_GETDATE>>
   
   <<{{User::varUserId}}:{{User::varPassword}}, FUN_BASE64ENC>>
   {{User::varUserIdAndPassword, FUN_BASE64ENC}}
   
   	

Step-By-Step

1. Firstly, You need to Download and Install SSIS ZappySys PowerPack.
2. Once you finished first step, Open Visual Studio and Create New SSIS Package Project.
3. Now, Drag and Drop ZS Logging Task from SSIS Toolbox.
   
4. Now, lets create a Variable and store value.
   
5. Double click on Logging Task to configure it.
6. Here Input Value from SSIS Variables. Set Log Mode to MEssageBox, Click on Insert Variables and select Function Examples and You can see MD5 Hash function.
   

   ----- OR -----

   You can use Hardcoded direct value.

   <<hello,FUN_HASH_MD5>>
   <<hello,FUN_HASH_MD5_HEX>>
   

   

   ----- OR -----

   You can use variable with Hardcoded for value.

   <<varMyData,FUN_HASH_MD5>>
   <<varMyData,FUN_HASH_MD5_HEX>>
   

   
7. Click on OK button to save Logging Task Configure Setting UI.
8. Now, Execute or run project package.
   

Function List

Along with format specifiers you can also use functions. See below list.

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Append --non-base64 option after secret if your key is not base64 encoded

Date Time Formatting

You can use DateTime format specifiers like below as long as variable DataType is DateTime. Click here to see full list of datetime format specifiers. Click Here to see list of predefined standard date time formats.

Numeric Formats

You can use numeric format specifiers like below as long as variable DataType is Numeric (e.g Int32, Decimal etc). Click here to learn how to use custom numeric format specifiers.

RecordSet Format Specifier

Few tasks support really easy way to dump ResultSet variable (e.g. ADO.net DataTable or DataSet) as HTML code which you can view in browser. This feature can be very handy with tasks such as ZS Logging Task, Send HTML Email Task. You can save recordset as HTML File or use inside email body.

URL Encode/decode functions

UserID={{User::varUid,FUN_URLENC}}&Pass={{User::varPass,FUN_URLENC}}

JSON Encode/decode functions

{ ErrorMessage : {{User::varMessage,FUN_JSONENC}} }

XML Encode/decode functions

<ErrorMessage>{{User::varMessage,FUN_XMLENC}}</ErrorMessage>

MD5 Hashing functions

HMAC functions

<<a2V5MTIz||Hi my name is A,FUN_HMAC_MD5>>

<<a2V5MTIz||Hi my name is A,FUN_HMAC_MD5_HEX>>

<<a2V5MTIz||POST\nx-csod-api-key:ABCD12345\nx-csod-date:2012-09-08T11:27:32.000\n/services/api/sts/session,FUN_HMAC_MD5_HEX>>

File Operation functions

<<c:\url.txt,FUN_READFILE>>

Using direct string rather than variable

	To apply placeholder function on direct string you must enclose data in double angle brackets (not curly brackets) and function name must start with FUN_ (e.g. <<myuser1:mysecretpass123,FUN_BASE64ENC>>).
	

Authorization: <<mysecretpass123,FUN_BASE64ENC>>

Authorization: bXlzZWNyZXRwYXNzMTIz

Using SSIS Variables inside Direct String Placeholders

Here is an example of how you can mix static string and dynamic string inside placeholder.

	<<Basic {{User::vUserId}}:{{User::vPassword}},FUN_BASE64ENC>>