I'm trying to use the script task to log the error from the package into a delimated text or CSV.
my problem is it's over 100 packages and it's a nightmare to customize a flat file destination and create all the columns and map it for all of them, and all the packages has diferent input columns.
So what I need is to dump all the (input0) into a delimted text file, with minimal interaction.
I only know how to do it by row but not by the whole input.
here's my start lines:
Dim TextFile As New StreamWriter(Variables.ErrorFileDir.ToString() & Variables.PackageName.ToString() & Variables.JobID.ToString() & "-Test2.txt")
Dim delim As String = ", "
TextFile.WriteLine(Row.code.ToString() + delim)