SQL Server Import and Export Tips

• Import Data from a SQL Server Multidimensional Database to a Tabular Database

• Retaining ETL Data from Files, APIs and Data Feeds

• Automating Flat File SQL Server Imports With PowerShell

• Export Multiple SQL Tables to Text Files Using SSIS, Biml, and BCP

• Bulk Insert Data into SQL Server
• Dynamically Generate SQL Server BCP Format Files
• Minimally Logging Bulk Load Inserts into SQL Server
• Non-Standard Delimiters for Columns and Rows Using SQL Server Bulk Insert
• Scale SQL Server Bulk Loading On a Budget - Part 1
• Scale SQL Server Bulk Loading with Partition Switching for Performance - Part 2
• SQL Server Bulk Insert Row Terminator Issues
• Troubleshooting Common SQL Server Bulk Insert Errors

• Considering Derived Values In ETL Flows

• Different Options for Importing Data into SQL Server

• Import Active Directory Data to a SQL Server Table
• Importing DBF files into SQL Server
• Using Python and Regex for SQL Server ETL Needs with Non-Standard Text Files

• Best Practices For Building Alerts for Using APIs with SQL Server
• Excel File Data Validation for SQL Server Imports
• Import end of day prices for all NASDAQ stocks into SQL Server
• Importing Historical Stock Prices from Yahoo Finance into SQL Server
• Loading Historical Data into a SQL Server Data Warehouse
• SQL Server Bulk Insert For Full Files, Misformatted Data and Unusual Characters

• Pre-Validating Data with PowerShell Before Importing to SQL Server
• Preventing Invalid Data Early In An ETL Flow
• SQL Server Stored Procedure to remove outliers from data sets
• SQL Server Video to Pre-Validate Data with PowerShell Before Importing
• SQL Server Video to Remove Outliers from Data Sets
• Using a Simple SQL Server Bulk Insert to View and Validate Data

• Export SQL Server Records into Individual Text Files

• Validate File Properties with PowerShell Prior to Import into SQL Server

• Adding more functionality to SQL Server BCP with PowerShell

• Import and Export VARCHAR(MAX) data with SQL Server Integration Services (SSIS)

• Different Ways to Import JSON Files into SQL Server
• Import Nested JSON Files to SQL Server with SSIS
• Importing Complex JSON files using SQL Server Integration Services
• Importing JSON formatted data into SQL Server

• Simple step by step process to import MS Access data into SQL Server using SSIS

• 3 Solutions For Auditing Long SQL Server Extracts or Loads

• SQL Server Data Import System to Alert For Missed Imports

• Using OPENROWSET to read large files into SQL Server
• Using SQL Servers OPENROWSET to break the rules

• ETL vs ELT Features and Use Cases

• Compare PUSH vs PULL Data Copy Performance in SQL Server
• Data Import Performance Comparison T-SQL vs SSIS for large import
• How to Copy a Table in SQL Server to Another Database
• Options to Improve SQL Server Bulk Load Performance
• Performance Improvement for SQL Server SELECT... INTO T-SQL Statement

• Importing Enriched Data into Azure Data Lake Storage (ADLS) with PowerShell

• Simple Image Import and Export Using T-SQL for SQL Server

• Copy data to another SQL Server instance without a Linked Server

• Using Global Temporary Staging Tables for SQL Server Data Importing

• Simple way to export SQL Server data to Text Files

• What technologies are available in SQL Server to support ETL?

• Solutions to Track Delayed SQL Server Transaction Latency
• Techniques to Cleanse Bad Data in SQL Server

• Techniques to handle timing issues and inconsistent data for SQL Server data loads