May 17, 2016 at 4:40 am
Hi,
Am new to SSIS. Am using Data flow task to move data from source table to destination table.
I need to capture the error description, task name and Package name and store it in error log table in the database.
currently am achieving it through Execute SQL task.But i want to use Script Task and store the error in the error log table.
Am using OLEDB connection manager to connect to database.
Can some one help me to get this?
Thanks in advance.
May 17, 2016 at 6:25 am
The ExecuteSQL task is easiest. Why do you want to change?
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
May 17, 2016 at 9:17 pm
The error description needs to be altered and customized as per the requirement for which i cant use Execute sql task. the requirement is to use Script task. am using execute sql task currently and i have been told to use script task instead of execute sql task. so could you please help me?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply