Remember this excel connection string parameter when you’re trying to import data in SSIS and the columns have mixed data types i.e. the column has floats and strings.
You’ll save some hair off the top of your head…
Tag Archives: SSIS
Link
Performance on SSIS Raw Files and In Memory Record Sets
This helped me out today. I was trying to store my temp data in memory but turns out i’m probably better putting it to a raw file.
a record of a developer 