CODEWITHSUNDEEP
ssisetl
Sai
Sai

Reputation: 47

SSIS: How to append the date of last day of the month using getdate() in expressions of SSIS

I want to add the date of last day of current month using expression builer in SSIS

Since it is march

I want the file name to be XXXXXX20210331.csv

Upvotes: 0

Views: 303

Answers (1)

Jatin Morar
Jatin Morar

Reputation: 150

This approach comes to mind and may be useful with your overall design and avoiding complex expressions:

First generate an Execute SQL Task with a "single row" result set.

Add this to the SQLStatement:

SELECT CONVERT(VARCHAR(8),EOMONTH(GETDATE()),112) as [Date]

Set the Variable Name in the result set to a user variable (that you will need to create "date") and add "Date" to the result name section

When ready to config your Flat File Destination Connection Manager/String:

Using the Expression Builder in the Flat File Connection (go to properties to set a variable --> Connection String for the Flat File Destination.

That said, you will need a working connection string and need to make it dynamic.

Add to the expression:

"filepath" + "XXXXXX" + (DT_STR, 8, 1252) @[User::date] + ".csv"

Hit "Evaluate value" to double check the full file path to be used in your destination with dynamic file name

Upvotes: 1

Related Questions