OPENROWSET and BULK INSERT (3)

{Previous Article in Series} {Next} This is the promised post about using a Powershell script to inspect large files. It won’t be possible to open a very large file in Excel of course, and some text readers may struggle under the weight of data. This script is an alternative that runs under most if not […]

OPENROWSET and BULK INSERT (2)

{Previous Article in Series} {Next} As a data warehouse developer you’ll probably have to load big files. Even if you’re not responsible for loads in PROD, you may well have to import data into the DEV database. There’s often an expectation that this shouldn’t take long, so if you hit any problems you could come […]