asked
i want to import a text file in ssis by applying substring function on the text file itself.is this approach faster than importing a text file into table then applying substring function to get the colmns required?
i want to import a text file in ssis by applying substring function on the text file
itself.is this approach faster than importing a text file into table then applying substring function to get the colmns required?
There's a number of factors that could affect the performance of each method. I would recommend that you try both methods with real files and see which one works better for you in your environment. What works best on my server may not be the same as your server.
16 People are following this question.
