103 How to log start and end time of all tasks in SSIS package

[@mbourgonwork4693]

Fascinating, but why would you do it this way? Why not use the internal tables? catalog.operations, catalog.event_messages, internal.operations_messages? You can already get all of this from that.

[@drummermike5150]

Thank you so much! Excellent video once again!

[@learnssis]

Thank you Mike.

[@jarisalmanzar2724]

Thanks for the helpful video!

[@learnssis]

You are most welcome.

[@ravikota3977]

Hi , Can we perform same thing in SQL through stored procedure

[@learnssis]

From sql stored procedure how you will know what SSIS package is doing. If you can write the sql insert queries inside sp and if you call sp from ssis package then it can be done.

[@ravikota3977]

Please help on my requirement

[@karthikcs100]

Hi, Aqil, If my target DB is Informix, how to implement the insert and select @@identity in the On Pre Execute expression?

[@learnssis]

Hi Karthick, Sorry I never worked with Informix DB. Thus I won't be able to help you on this, you need to take help from internet.

[@karthikcs100]

@@learnssis Thanks Aqil for the reply, will work on it.

[@karthikcs100]

Hi Aqil, I have successfully done this feature to the target Informix DB. your videos are so helpful and educational. thanks bro

[@learnssis]

@@karthikcs100 Thank you Karthick, glad you figured it out.

[@karthikcs100]

@@learnssis Hi Aqil, I am using 2015 SSDT tool in which the Parameter tab is missing in ODBC Source unlike OLEDB Source. What version are you using currently and any idea on to get Parameter tab in the ODBC source when data access mode : SQL command is selected. Thanks

[@avirajedudhabhate1731]

Hi all, I need help urgently on a similar scenario, in my scenario I need to update the log table like this - Id , package name, start date, end date, status (success/failure) ... And I have master package and inside the master package I'm calling 3 packages, so if I ran master package the inside 3 packages should run parallely , for this master package only I need the log table, Please help somebody

[@learnssis]

Hey, if the Id field is Identity then what you can do before calling an SSIS package, you can insert a record into the log table like below. Also declare an SSIS variable Id of type Int32 and execute this code inside execute sql task and assign the single result set value to Id variable. insert into audit_log select 'PackageName',getdate(), NULL,'' select @@identity After running above query it will assign the max id from audit_log table to Id ssis variable. Now after the completion of ssis package you can put an update query like below update audit_log set enddate = getdate(), status = 'Success' where Id = (DT_WSTR,12)(drag and drop Id from variable list here)

[@avirajedudhabhate1731]

@@learnssis thank you so much for your prompt response, appreciated,🙏🙏 will check with your resolution thanks again

[@avirajedudhabhate1731]

@@learnssis hi sir, I tried to do as per your resolution but now the table itself is not getting loaded/ updated after running the package

[@sfarheen23]

Hi, I have learnt SSIS watching your videos and started working on it now Could you please make some videos on Reusable package parts? It would be helpful

[@learnssis]

OKay, will think about it.

[@sfarheen23]

@@learnssis Thanks🙂

[@Loknath7702]

Hi Aqil, I have sent you a scenario through mail. Could you please check it and send me the solution for that. Thanks.

[@learnssis]

Just replied to you, please check the email.

[@haters6881]

Hi bro

[@haters6881]

I want one video like data migration lastrefreshed date to ssis package start date but source 7

[@haters6881]

How to put condition

[@learnssis]

@@haters6881I have a detailed video on similar thing, you can take a look kzbin.info/www/bejne/enbbaKB6nbieppY

[@learner_SSIS]

Thank you Aqil sir helpfull video 👍

[@learnssis]

You are most welcome Naveen.

[@learner_SSIS]

🔥 thank you soo much sir 😀

[@learnssis]

You are most welcome Naveen Sir.