0
Answered

SQL Bulk Insert tool

Anonüümne 11 aastat tagasi Studio / Toolbox uuendaja anonymous 11 aastat tagasi 0
Hi
What type of data files does the SQL Bulk Insert tool support?
Can is read Excel?

Vasta

Vasta
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.
Vasta
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.