Forum Discussion
Capture stored proc prints from C# SSIS Script task when completed successfully (2016)
Good day ! I am trying to output the print messages from a stored proc that is being execute from SSIS script task. When the execution fails, I get all I want in the execution results tab (F...
The output file is not even being created ! (???)
MyleneC , the log file is (will) located on a network share, rarly a good idea.
Are all required access permission for the share granted?
Olaf
olafhelper I also tried something like this...
using (var reader = Storproc.ExecuteReader())
{
do
{
if (reader.Read())
Console.WriteLine(reader.GetInt32(0));
}
while (reader.NextResult());
}
But it's not working either...- This is our output directory. It has nothing to do with the issue. Please note that I have modify the description of this ticket. I realized that it was not clear enough. Please let me know what you think 😉
