SSIS Tutorial Part 17 - Create Excel File with DateTime On Each Package Execution in SSIS Package

In this video of SQL Server Integration Services(SSIS) Tutorial, you will learn how to create An Excel file with date-time on each package execution. This is important when we want to run our package multiple times in a days and
don't want to append the data to already existing Excel File.

The video will cover following Items

  1. How to Load Data from SQL Server Table to Excel Sheet
  2. How to use Data Conversion Transformation to Convert SQL Data To Excel Data Types
  3. How to use OLE DB Source and Excel Destination in SSIS Package
  4. How to use Variables in SSIS Package
  5. How to Write Expressions to get Date-time in SSIS Package
  6. How to use variable in Excel Connection Manager to provide File Name with Date-time
  7. How to use DelayValidation property in SSIS Package to ignore prevalidation in SSIS Package



Expressions used in the SSIS Package to Create Excel file with Date Time:
@[User::DestinationFolder]+"RegionalCustomer_"+Replace(Replace(Substring((DT_WSTR,30)GETDATE(),1,16),":","_"),"-","_")+".xlsx"



6 comments:

  1. UnknownJune 8, 2020 at 8:27 AM

    [File System Task] Error: An error occurred with the following error message: "Could not find file 'C:\Users\Sujan\Desktop\OUTPUTFOLDER\Template\Customer.xlsx'.".
    hello sir how to fix those error

    ReplyDelete
  2. UnknownAugust 3, 2020 at 3:17 AM

    I also have the same issue as above comment: [File System Task] Error: An error occurred with the following error message: "Access to the path 'c:\users\daniel joubert\Desktop\OutPutFolder\DestinationFolder' is denied.". My guess is that their is a permission issue somwhere between ssis and my local laptop. How to fix this I am not sure.

    ReplyDelete
    Replies
    1. UnknownAugust 22, 2020 at 8:25 PM

      I used the old version of Excel and it worked. This error caused because you don't have install Microsoft Access Database Engine 2016 Redistributable 64 bit version under Server Objects --> Linked Servers. Which version depends on which version of the Excel you use. But you can google it

      Delete
  3. HarshaAugust 3, 2021 at 12:57 AM

    Great work sir !!

    ReplyDelete
  4. AlayaSEONovember 6, 2021 at 12:20 AM

    In order to create change, organisations need to change the way they deal with the information and documentation they use every day and look to excelling in their business aspirations and actively obtain Operational Excellence through utilising that information, documentation and knowledge already being developed through tools and structure, which can be established to create that same drive and aspiration for businesses everywhere. Businesses always need to 'up the ante' when it comes to utilising their information effectively. ppt translator

    ReplyDelete
  5. Marcus MaascarrJune 4, 2024 at 6:30 AM

    Every day, I indulge in the simple pleasure of watching videos. It's my ritual, a retreat into a world where time slows down and entertainment takes center stage. From the crackle of opening credits to the fade-out of the final scene, each video is a journey—a brief escape from the hustle and bustle of reality. Whether it's a gripping drama that tugs at my heartstrings or a hilarious comedy that leaves me in stitches, there's always something new to discover, to laugh at, to marvel at. And in those moments, as I immerse myself in the glow of the screen, I find solace and joy in the stories unfolding before me. I also like to watch porno videos because it gives me a lot of pleassure

    ReplyDelete

Subscribe to: Post Comments (Atom)