Import/Export Wizard | Varinder Sandhu

SQL Server – Export the Data from SQL Server to Oracle Database – Import-Export Wizard

Varinder Sandhu SQL, SQL-Advanced, SQL-General, SQL-SSIS, Varinder Sandhu

The SQL Server Import and Export Wizard provides the simplest method of copying data between data sources. In this article given an example to copy the data from SQL Server to Oracle database. Click here to download the full PDF version of this article. After this article,for more detail about

» Read more

Data Sources, Import/Export Wizard, SQL Server

SQL Server 2008 – Import/Export wizard not allowing Create Temp Table

Varinder Sandhu SQL, SQL-Advanced, SQL-SSIS, Varinder Sandhu

I had a requirement to export the data from SQL Server to Oracle using SQL Server Import/Export wizard. In the SQL Server, I have created a SQL Script that fetch the required data that I need to export in Oracle database. Because of some business logic, in the select script

» Read more

Import/Export Wizard, SQL Server, temp table

SSIS – Import/Export Wizard – Unexpected Unrecoverable Error

Varinder Sandhu SQL, SQL-Advanced, SQL-SSIS, SQL-Tips and Tricks, SQL-Utilities, Varinder Sandhu

SSIS Import/Export Wizard throws up “Unexpected Unrecoverable Error”. Error message dialog box have three buttons – Abort, Retry, and ignore all cause the wizard to close. The reason I found of this: Installation the .Net Framework 4 Client Profile Solution: Uninstall the .Net Framework 4 Client Profile Or Install Extended .NET

SQL Server – Import Export Wizard – Enable Identity Insert

Varinder Sandhu SQL, SQL-Advanced, SQL-SSIS, SQL-Tips and Tricks, Varinder Sandhu

I had requirement to move the data from source table with his identity column to destination table that have also identity column. Identity columns are commonly used as primary keys in database tables. These columns automatically assign a value for each new row inserted. Identity column does not allow any