Create a file with Date From SQL Server Table and Send as Attachment in SSIS Package - SQL Server Integration Services(SSIS) Package

Scenario:

We need to create a file with Date on daily basis and then send to our client in email by using SSIS Package.

Solution:

In this video we will learn how to solve above scenario, we will learn following components
How to create Parameters in SSIS Package
How to use Data Flow Task and read data from SQL Server Table and load to Flat file 
How to write expression to create file with Date
How to use expression on Flat file Connection Manager in SSIS Package
How to Send a file as attachment by using Send Mail Task in SSIS Package
How to use Expressions in Send Mail Task in SSIS Package

Expression used in the video
@[$Package::OutputFolder]+"Customer_"+Replace(Substring((DT_WSTR,30)getdate(),1,10),"-","")+".txt"


How to Create a File with Date everyday and Send from an SSIS Package by using Send Mail Task



  Related Posts/Videos on Send Mail Task  


8 comments:

  1. Likewise, take a stab at talking about subjects that you truly appreciate.http://znajdzlove.pl/

    ReplyDelete
  2. It is included in my habit that I often visit blogs in my free time, so after landing on your blog. I have thoroughly impressed with it and decided to take out some precious time to visit it again and again. Thanks. convert pdf to png

    ReplyDelete
  3. This method saved me so much time. convert pdf to png is able to search a large document after following these steps. Thank you!!

    ReplyDelete
  4. Nice to be visiting your blog once more, it has been months for me. Well this article that ive been waited for therefore long. i want this article to finish my assignment within the faculty, and it has same topic together with your article. Thanks, nice share. 먹튀사이트

    ReplyDelete
  5. I really like your writing style, great information, thankyou for posting. 메이저사이트

    ReplyDelete
  6. Great articles and great layout. Your blog post deserves all of the positive feedback it’s been getting. 먹튀검증

    ReplyDelete
  7. Hi there! Nice stuff, do keep me posted when you post again something like this! 먹튀검증

    ReplyDelete
  8. A very excellent blog post. I am thankful for your blog post. I have found a lot of approaches after visiting your post. BizOp

    ReplyDelete