Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

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
Full explanation