SSIS YYYYMMDD date format using SSIS expression

Updated on June 18, 2026 by ZappySys

Format Date – SSIS YYYYMMDD from date Often, you need to create file paths with a timestamp using an SSIS Expression. You can use SSIS Expressions Below is a simple expression that will produce a file path with the current timestamp

"C:\\Folder\\MyFile_"
+ (DT_STR, 4, 1252) DATEPART("yyyy" , GETDATE())
+ RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , GETDATE()), 2)
+ RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , GETDATE()), 2) + ".json"

"C:\\Folder\\MyFile_"

+ (DT_STR, 4, 1252) DATEPART("yyyy" , GETDATE())

+ RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , GETDATE()), 2)

+ RIGHT("0" + (DT_STR, 2, 1252) DATEPART("dd" , GETDATE()), 2) + ".json"

Sample Output C:\Folder\MyFile_20151231.json Convert Date – SSIS YYYYMMDD to Date

--// For Control Flow //---
(DT_DATE)(SUBSTRING(@[yourDateAsStr],1,4) 
+ "-" + SUBSTRING(@[yourDateAsStr],5,2) 
+ "-" + SUBSTRING(@[yourDateAsStr],7,2))

--// For Data Flow //--
(DT_DATE)(SUBSTRING([field],1,4) 
+ "-" + SUBSTRING([field],5,2) 
+ "-" + SUBSTRING([field],7,2))

--// For Control Flow //---

(DT_DATE)(SUBSTRING(@[yourDateAsStr],1,4)

+ "-" + SUBSTRING(@[yourDateAsStr],5,2)

+ "-" + SUBSTRING(@[yourDateAsStr],7,2))

--// For Data Flow //--

(DT_DATE)(SUBSTRING([field],1,4)

+ "-" + SUBSTRING([field],5,2)

+ "-" + SUBSTRING([field],7,2))

Set the SSIS […]

How to read Zendesk data in SSIS with REST API

Updated on March 11, 2026 by ZappySys

Introduction Zendesk is one of the most popular customer service platforms available today. Zendesk offers a REST API to interact with its cloud-based service programmatically (to manage or read data). The problem is that not everyone is a programmer, and not everyone has time to learn how to write C# or JAVA code to access a […]

How to read Twitter data in SSIS using REST API Call

Updated on December 7, 2019 by ZappySys

Introduction In this article you will how to Read Twitter data in SSIS using SSIS JSON Source and SSIS REST API Web Service Task. You will also learn about latest OAuth 2.0 Protocol to simplify REST API access. Twitter REST API Authentication In order to fetch any data from twitter using OAuth REST API calls […]

JSONPath Expression Examples – JSON Cheatsheet (SSIS / ODBC)

Updated on September 23, 2025 by ZappySys

What is JSONPath expression JSONPath expression is an expression language to filter JSON Data. Its a similar concept to XPath expression in XML but has limited features compared to XPath. If you are extracting data from REST API Services using SSIS JSON / XML Source or ODBC JSON / XML Driver then you will quickly realize […]

Working with HTTP Cookies in SSIS or ODBC

Updated on October 17, 2025 by ZappySys

Introduction In this post, you will learn how to Parse Cookies from a Response and Pass Cookies to any Web Requests. SSIS PowerPack v1.8.2 introduced a new feature that allows sending and receiving cookies with HTTP Web Request/Response. We will use the SSIS REST API Task to parse cookie values and then send cookies along with […]

SSIS REST API Task – Mapping Response Header to Variable

Updated on March 12, 2026 by ZappySys

In this post, you will learn how to save the response header value to an SSIS variable using the SSIS REST API Task SSIS PowerPack v1.8.2 introduced a new feature for mapping the Response Header to a variable. When you click the Test Request/Response button, all response headers will be parsed into the Response Header […]

SSIS export to excel dynamically (supports multiple tables)

Updated on October 2, 2025 by ZappySys

Limitations of the SSIS Excel Source/Destination SSIS comes with out-of-the-box support for reading and writing to Excel. However, it’s very restrictive if you want to make things dynamic, as any metadata inside DataFlow cannot be changed at runtime. Here are a few problems with using the native Excel Source or Destination. Metadata cannot be changed […]

How to read OData in SSIS – REST API Example

Updated on October 2, 2025 by ZappySys

Introduction In this article, we will learn how to utilize the SSIS JSON Source Component to retrieve JSON data from an OData service and perform OData pagination on significant results. According to the OData specification, data can be presented in either JSON or XML format. For the XML format, refer to this article. This article primarily […]

How to set SSIS Data Flow component property using expression and variable

Updated on October 1, 2025 by ZappySys

Introduction SSIS PowerPack supports various methods for making things dynamic. Sometimes you have to consume JSON Data from a Dynamic URL. There are 3 different ways you can make JSON Source URL Dynamic. Use Expression on the DirectPath property of the JSON Source (SSIS Data Flow Expression) Use variable placeholders directly inside URL (Only works […]

Calling REST API in SSIS with Basic Authentication / Userid-Password (BASE64 Authorization header)

Updated on March 19, 2025 by ZappySys

Introduction In this blog post you will explain how to pass basic credentials (i.e. UserID/Password) along with your web request. You will also learn about setting up Authorization Header for HTTP Web Request in Base64 manually. To learn more about how to consume / call REST API in SSIS check this article. HTTP Authorization Header […]