4

Is there an easier way to apply property settings to multiple output columns in a SSIS flat file source, rather than manually applying to each output column? (SQL Server 2014.) I am attempting to export data from a large text file source to an Azure database and the process is very slow. I have read some tuning guides that suggest that the "FastParse" and "Length" properties should be set. The problem is, my data source is columnar (which is transposed to rows further down the track) and it is tedious to set properties individually for a large amount of columns.

In general it would also be beneficial to know if it is possible to bulk-apply other such settings.

Paul White
  • 94,921
  • 30
  • 437
  • 687
lintunen
  • 81
  • 1
  • 3

1 Answers1

1

In the advanced tab of the connection manager of the flat file data source. You can mark multiple columns by holding CTRL and then set the properties they have in common.

Felix
  • 148
  • 4