SQL Server import dbase Articles

Import dbase (dbf) Files using SQL Server.

SQL Server integration Service (SSIS) can be used to import data from heterogeneous data sources ranging from SQL Server, Oracle to CSV, XML files. To Import a single DBF file to SSIS 1. Open Microsoft Visual Studio 2008 and create a SSIS project. 2. Drag and Drop a Data flow task to Control flow and […]

SQL Server General DBA FAQs (All)

Import Data Using SSIS from an Excel Workbook which has Dynamic Sheets Using SSIS invoke-sqlcmd Not Recognized ORDER BY behavior with NOLOCK Automate Generate Scripts in SSMS Invoke-Sqlcmd vs sqlcmd utility Change Select Top 1000 Rows value in SSMS Change The SQL Server Port Number Change Edit Top 200 Rows value in SSMS Decode COLUMNS_UPDATED […]

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |