It is now easy to create scripts using the functionality in T-SQL to automate the loading of data into SQL Server with the addition of the bulk insert command in T-SQL. The parameters expose all the same functionality of the BCP command line utility. The command can also be nested in a transaction and so allow for checking for dependencies before committing the inserts. However, the command only supports loading information into SQL Server. Writing from a table to a file still requires the command line version of BCP.
In today’s digital world, technology has changed how we make payments. From contactless cards to mobile wallets, it’s now easier