In your SSIS solution, you need to load a large set of rows into the database as quickly as possible. The rows are stored in a delimited text file, and only one source column needs its data type conve

Question

Options

• AThe File System task would be perfect in this case, because it can read data from files and
• BThe Bulk Insert task would be the most appropriate, because it is the quickest and can
• CThe data flow task would have to be used, because the data needs to be transformed before
• DNo single control flow task can be used for this operation, because the data needs to be

• A
  3% (1)
• B
  6% (2)
• C
  79% (26)
• D
  12% (4)

Explanation

The key constraint here is that a data type conversion is required (String to Decimal). The Bulk Insert task is the fastest way to load data from a flat file into SQL Server, but it performs a direct, unmodified copy with no transformation capability - it cannot convert data types mid-load. The File System task manages files and folders and cannot load rows into a database. Because a transformation must be applied to one column before loading, the Data Flow task is required. It supports Source components, transformation components like Data Conversion or Derived Column, and Destination components in a pipeline, making it the only suitable choice when any transformation is involved.

No community discussion yet for this question.