0
Answered

SQL Bulk Insert tool

Anonymous 10 years ago in Studio / Toolbox updated by anonymous 10 years ago 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.