SSIS - Create Log File for SSIS Package Execution With DateTime [ SSIS Logging ]

Scenario: 

We have created a SSIS Package. Now we want to enable Logging for our Package and want to create a log file ( Text File Logging) each time the package executes. The Log file name should look like "PackageName_Date_Time.log".


Solution: 

SSIS provides different types of logging such as 
  • Text File Logging
  • SQL Server Profiler
  • SQL Server
  • Windows Event Log
  • XML File
For more details please visit 

In our case we will be using Text File Logging. Let's start

Step 1: 
You can go to SSIS menu and then choose Logging Or right click inside Control Flow Pane and choose Logging as shown below

OR

Step 2: 
Choose the Log provider, In our case we are using Text File Logging

Step 3: 
Create Connection for Log file as shown below

Step 4: 
Choose the containers , Tasks for which you want to enable logging

Step 5: 
Choose the events for each of the task or container you want to save in log file. For more details about events visit the link that I provided in Solution section

Step 6: 
If we run our package now, it is going to create a log file on desktop for us with the name MylogFile.txt. But our goal is not to generate a log file like that. We want to create a log file in PackageLogFiles Folder with PackageName and Datetime.


Create a variable VarLogFolderPath and save the path of folder where you want to save the log files.

Step 7:
Create expression for our Log File Name for each execution. Go to MyLogFile Connection Manager and Right Click on it. Go to properties and then expression and write expressions as shown

Expression :
@[User::VarLogFolderPath]+"\\"+ @[System::PackageName]+"_"+Replace(Replace(Replace(SUBSTRING((DT_WSTR,50)(GETDATE()),1,16),"-","")," ","_"),":","")+".log"



Note : 
As you have noticed that I did not save the time till seconds level. If I will do that , SSIS will create multiple log files , couple of them while validation. To avoid that I am creating log file with YYYYMMDD_HHMM.

Final Output : 
Let's run our SSIS Package couple of times and check the Log File Folder.Wow!! the log files are created for each execution of SSIS Package.



45 comments:

  1. I feel SSIS is the best and most useful component of SSIS package anyways.This is always very useful to provide an edge and explore more about solutions to many complex IT problems.

    SSIS Postgresql Read

    ReplyDelete
  2. Pretty good post. I have just stumbled upon your blog and enjoyed reading your blog posts very much. I am looking for new posts to get more precious info. Big thanks for the useful info. power harrow

    ReplyDelete
  3. I think this is an informative post and it is very beneficial and knowledgeable. Therefore, I would like to thank you for the endeavors that you have made in writing this article. All the content is absolutely well-researched. Thanks... taxi vlaardingen

    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. Merely a smiling visitant here to share the love (:, btw outstanding style. click here

    ReplyDelete
  6. Nice to see your blog. It feels good to get good information. Please visit my blog as well. It will help.
    토토사이트

    ReplyDelete
  7. I’ve read some good stuff here. Definitely worth bookmarking for revisiting. I surprise how much effort you put to create such a great informative website. 토토사이트

    ReplyDelete
  8. Your articles are inventive. I am looking forward to reading the plethora of articles that you have linked here. Thumbs up! 릴게임

    ReplyDelete
  9. Love to read it,Waiting For More new Update and I Already Read your Recent Post its Great Thanks. 88카

    ReplyDelete
  10. Good day very cool website!! Man .. Excellent .. Superb .. I’ll bookmark your website and take the feeds additionally. I am glad to find a lot of useful information right here in the put up, we want to develop more strategies in this regard, thanks for sharing. . . . . . Digital Tech Solutions

    ReplyDelete
  11. Thank you for the sensible critique. Me & my friend were just preparing to do a little research about this. We got a book from our local library but I think I learned more from this post. I’m very glad to see such magnificent info being shared freely out there. Best Financial Advisor

    ReplyDelete
  12. Thank you for the sensible critique. Me & my friend were just preparing to do a little research about this. We got a book from our local library but I think I learned more from this post. I’m very glad to see such magnificent info being shared freely out there. I will develop php laravel codeigniter web application rest API and bug fix

    ReplyDelete
  13. There may be noticeably a bundle to find out about this. I assume you made sure good factors in options also. I will design web applications, dashboards with the best UI and UX

    ReplyDelete
  14. Anyone! How he got Step4 window??

    ReplyDelete
  15. There may be noticeably a bundle to find out about this. I assume you made sure good factors in options also. Muddiipaws


    ReplyDelete
  16. It was contemplating whether I could use this audit on my other site, I will associate it back to your site though.Great Thanks 에볼루션바카라

    ReplyDelete
  17. This post is in fact a fastidious one it assists new internet users, who are wishing in favor of blogging. 바카라사이트

    ReplyDelete
  18. Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and I hope you post again soon. Big thanks for the useful info. RV Maintenance Orange County 토토커뮤니티

    ReplyDelete
  19. Great post. I used to be checking continuously this blog and I’m impressed! Extremely helpful info particularly the final section I deal with such info much. I was looking for this certain info for a long time. Thank you and best of luck. 안전놀이터

    ReplyDelete
  20. The content is top character, you can easily find numerous exclusive. There is something special about them. Thanks for sharing this valuable information with all of us and if you are searching for the best. Please do keep up the great work. 먹튀커뮤니티

    ReplyDelete
  21. A very awesome blog post. We are really grateful for your blog post. combat, law enforcement You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. 파워볼사이트

    ReplyDelete
  22. The post is really superb. It’s varied accessory information that consists during a basic and necessary method. Thanks for sharing this text. The substance is genuinely composed. This web do my paper for me log is frequently sharing useful actualities. Keep sharing a lot of posts. 토토커뮤니티

    ReplyDelete
  23. A very awesome blog post. We are really grateful for your blog post. combat, law enforcement You will find a lot of approaches after visiting your post. I was exactly searching for. Thanks for such post and please keep it up. Great work. 먹튀검증

    ReplyDelete
  24. thanks for sharing it. i really like it. always suckses 먹튀검증

    ReplyDelete
  25. Yes i am totally agreed with this article and i just want say that this article is very nice and very informative article.I will make sure to be reading your blog more. You made a good point but I can't help but wonder, what about the other side? !!!!!!Thanks  토토사이트

    ReplyDelete
  26. The most interesting text on this interesting topic that can be found on the net ... 먹튀검증

    ReplyDelete
  27. That is many inspirational stuff. For no reason knew that opinions could be this varied. Thanks for all the enthusiasm to offer such helpful information here. 우리카지노

    ReplyDelete

  28. The birbal video interview platform is one of the few mobile-friendly tools on the market. This software allows candidates to record their video responses on their smartphones and tablets. This software also uses AI to analyze non-verbal cues like facial expressions, eye movements, and voice nuances. This helps the interviewer make meaningful assessments at the end of the interview.

    video interview platform
    video interview software

    ReplyDelete
  29. My curiosity was solved by looking at your writing. Your writing was helpful to me. 룰렛사이트 I want to help you too.

    ReplyDelete
  30. When did you start writing articles related to ? To write a post by reinterpreting the 메리트카지노 I used to know is amazing. I want to talk more closely about , can you give me a message?

    ReplyDelete
  31. When I read your article on this topic, the first thought seems profound and difficult. There is also a bulletin board for discussion of articles and photos similar to this topic on my site, but I would like to visit once when I have time to discuss this topic. 안전토토사이트

    ReplyDelete
  32. I was looking for another article by chance and found your article 룰렛 I am writing on this topic, so I think it will help a lot. I leave my blog address below. Please visit once.

    ReplyDelete
  33. Youre so right. Im there with you. Your weblog is definitely worth a read if anyone comes throughout it. Im lucky I did because now Ive received a whole new view of this. 메이저사이트추천

    ReplyDelete
  34. An intriguing discussion may be worth comment. I’m sure you should write much more about this topic, may well be described as a taboo subject but generally folks are too little to chat on such topics. An additional. Cheers 토토사이트

    ReplyDelete
  35. chops into the hot oil, working in batches if necessary to avoid overcrowding the pan and
    https://www.homemcms.com/kimhae 김해출장

    ReplyDelete
  36. But it has long been thought the monument was used for ceremonial
    https://www.homemcms.com/kimhae 김해출장타이

    ReplyDelete
  37. I've been searching for hours on this topic and finally found your post. 슬롯사이트 , I have read your post and I am very impressed. We prefer your opinion and will visit this site frequently to refer to your opinion. When would you like to visit my site?

    ReplyDelete
  38. An impressive share, I just now given this onto a colleague who was simply carrying out a small analysis during this. And that he the fact is bought me breakfast since I discovered it for him.. smile. So ok, i’ll reword that: Thnx for any treat! But yeah Thnkx for spending enough time go over this, Personally i think strongly about it and enjoy reading on this topic. If it is possible, as you become expertise, would you mind updating your website with a lot more details? It really is extremely of great help for me. Huge thumb up just for this text! Seo Service in Karachi

    ReplyDelete
  39. In my opinion, the item you posted is perfect for being selected as the best item of the year. You seem to be a genius to combine 안전놀이터 and . Please think of more new items in the future!

    ReplyDelete
  40. I dont usually comment on blogs but i have to tell you well done Aesthetic Treatments In Karachi

    ReplyDelete
  41. While looking for articles on these topics, I came across this article on the site here. As I read your article, I felt like an expert in this field. I have several articles on these topics posted on my site. Could you please visit my homepage? 토토사이트모음

    ReplyDelete
  42. I like the helpful info you provide in your articles. I’ll bookmark your blog and check again here frequently. I’m quite sure I’ll learn plenty of new stuff right here! Good luck for the next. 먹튀검증업체

    ReplyDelete
  43. I am often to blogging and i also truly appreciate your site content. The content has really peaks my interest. I am about to bookmark your blog and maintain checking for new details.
    home decoration items in Karachi

    ReplyDelete
  44. I love the tips on this site, they are always to the point and just the information I was looking for Home Accessories In Pakistan

    ReplyDelete