Skip to content

Glenn Pepper

SQL Server Database Administration

Primary Menu
  • Home
  • About
  • Resources
    • GitHub
    • Links
    • Downloads
  • Music

OPENROWSET

Bulk Insert Using OPENROWSET()

Posted on 16th November 201511th September 2018 by GPepper

I needed to bulk import a text file to a table but I couldn’t use BULK INSERT as the text file was only for a few columns that were present in the destination table.  Rather than bulk insert to a new temporary table and insert the data from here, I Continue Reading

Posted In T-SQLTagged In BULK IMPORT, OPENROWSET, T-SQL

Recent

  • Troubleshooting Performance Problems
  • Cluster Quorum PowerShell Commands
  • Creating Fake Data for Testing
  • SSRS Database Migration – Cannot View Subscriptions
  • Automating SQL Installs

Tag Cloud

AlwaysOn Automation Availability Groups Backups BATCH UPDATES Best Practice Best Practices BULK IMPORT Clusters Communication Corruption Disaster Recovery DR Email Execution Plans Foreign Keys HTML Indexes Interviews Migration Monitoring Music Off Topic OPENROWSET PHP Post-Rock PowerShell Processing Quorum Random Rant Reference Restores sp_whoisactive SQL Agent SQLCMD SQL Installations sqlps SQL Security SQL Server SQL Server 2012 T-SQL Troubleshooting UPDATE VARIABLES

Categories

  • Always On Availability Groups
  • Automation
  • Azure
  • Best Practices
  • Disaster Recovery
  • Maintenance
  • Monitoring
  • Music
  • Off-Topic
  • PowerShell
  • SQL Server 2012
  • SQL Server 2014
  • SQL Server 2016
  • T-SQL
  • Troubleshooting
  • Uncategorised
Copyright All rights reserved | Theme: Flash Blog by Unitedtheme.