Hello everyone,
I have a batch that call SSIS packages to load .txt files in SQL Server database, my problem is that when there is an execution error of the package(s) i haven't a lot information in the log file generated by the batch, it tell me just the name of the package with error, so how can i capture the SSIS error which give more details about the error.
Thanks.