0
Answered

SQL Bulk Insert tool

Жасырын 11 year бұрын в Studio / Toolbox updated by anonymous 11 year бұрын 0
Hi
What type of data files does the SQL Bulk Insert tool support?
Can is read Excel?

Answer

Answer
Answered
The bulk insert tool works with our internal data language. You need to use recordsets to maximize its effectiveness.

You can find more information on our language by clicking the [[?]] icon at the top of the studio.

You can also find an example of its usage by opening the Recordset - SQL Bulk Insert workflow in the EXAMPLES folder in the studio explorer.
Answer
Answered
The bulk insert tool works with our internal data language. You need to use recordsets to maximize its effectiveness.

You can find more information on our language by clicking the [[?]] icon at the top of the studio.

You can also find an example of its usage by opening the Recordset - SQL Bulk Insert workflow in the EXAMPLES folder in the studio explorer.