Multiple choice technology

You are using SSIS to import a plain text file to SQL Server. You have found that some text files do not have a standard format. For example, the last field orderdate does not exist for some records. What is the best method you should use to import this file to SQL Server?

  1. You cannot use SSIS to import non-standard text files

  2. Use a flat file connection and assign text file for the connection and get the data

  3. Use a flat file connection and Transformation option of the script component. The use some code get the orderdate

  4. Use fuzzy grouping and a flat file connection to get order date
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When importing text files with non-standard or missing fields in SSIS, the Script Component transformation provides the most flexibility. You can write custom code to handle variable column counts, conditional logic for missing fields like orderdate, and data validation. Standard flat file connections require consistent structure, and fuzzy grouping is designed for data matching, not handling missing columns.

Keep practicing — related questions