Insert Statement Generation

Transforms can automatically generate an MSSQL insert statement from an input file. This is handy when you can't directly load data in, or only have a query window to work from. You can find the under the "PREPARE" tab -> Utils menu.

Utils Menu

To generate an insert statement, head over to the Utils section. You'll find the file upload, and generation methods there.

The NVarchar option will generate all strings as N'' - Enabling NVarchar type inserts.

Once a file has been supplied, simply click "Get Script" to download the .sql file.

Don't forget to change the insert table name, as it's assumed by the filename (not known at generation time!)

Last updated