March 26, 2018 at 7:24 am
I am fairly new to ssis and I am in a process of learning it. The 1st task which is given to me is to add a timestamp in a log file so the packages can be executed concurrently. Right now the way log file is setup, packages can't run concurrently because all packages in the solution use the same log file. So I am wondering if there is a way to add a timestamp in a logfile. This is how it is setup
D:\data\SSISLogs\RetrieveFormRequests_20180326.ssislog
This is what I would like to accomplish if the package runs at 1 in the morning.
D:\data\SSISLogs\RetrieveFormRequests_20180326_0100.ssislog
How can I accomplish that?
March 26, 2018 at 8:38 am
The doesn't answer your question directly but offers a possible alternative. Since SQL 2012 you can use Project Deployment with SSIS where logs are automatically created in the SSISDB and you can control the retention period. There are in-built reports that let use examine each packages execution history and is very useful for debugging package failures.
March 26, 2018 at 9:28 am
We are still on SQL Server 2008. Not even R2
March 27, 2018 at 9:27 am
In my last role we used SQL DB logging for SSIS in 2008, you don't have to worry about locks on a text file then.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply