Net and you are creating a new version of that string each time you add a column to it. My assumption is the slowness boils down to all that concatenation. I think those extensions are in the Linq namespaces but it could have been the Collections using System

That dumped all of AdventureworksDW2014 in 15 secondsīased on the comment that this line is failing IEnumerable fields = (row.ItemArray).Select(field => field.ToString()) Įnsure that you have the following using statements in your project. Success = .DTSExecResult.Success,įailure = .DTSExecResult.Failure IEnumerable fields = (row.ItemArray).Select(field => field.ToString()) įile.WriteLine(string.Join(delimiter, fields)) TODO: For string based fields, capture the max length Header = new () įoreach ( item in table.Columns)įile.WriteLine(string.Join(delimiter, header)) įoreach ( row in table.Rows) Using (System.IO.StreamWriter file = new System.IO.StreamWriter(System.IO.File.Open(outFilePath, System.IO.FileMode.Create), e))

String baseFileName = System.IO.Path.GetFileNameWithoutExtension(fileName) īaseFileName = System.IO.Path.GetFileName(fileName) ĭts.Events.FireInformation(0, 'Data Dumper', string.Format('.csv', baseFileName, table.TableName)) It does not escape text columns with a qualifier, doesn't escape embedded qualifiers, do anything with newlines in the feeds and something in the OleDbDataAdapter's fill method fails with binary data, etc public void Main()

This implementation does not attempt to deal with any of the corner cases, at all. Persist has a default parameter for delimiter of |. Passing in 3 SSIS variables: vFileName, vDestinationPath and vResultSet, the code in Main will convert the ado recordset into a DataTable which is then added to a DataSet and passed to the Persist method. Seeing as how I already have this code ~ written for a different project, I mashed your request in with how mine works Feel free to translate to VB.NET as you see fit.

Edit scr files from winrar