Skip to content Skip to sidebar Skip to footer
Showing posts with the label Etl

Parameter Mapping Using An Execute Sql Task

I am trying to create a temporary table and insert data into the temp table within an Execute SQL T… Read more Parameter Mapping Using An Execute Sql Task

Oracle Datatype Error

I'm trying to insert a value into date datatype by selecting a value from a source table whose … Read more Oracle Datatype Error

Ssis 2012 - Variable Empty On Second Script Execution

I have a script component transformation in a data flow. In this script component I read a table fr… Read more Ssis 2012 - Variable Empty On Second Script Execution

Ssis : Creating A Flat File With Different Row Formats

I want to create a flat file output, where format of rows is different. file has header, middle da… Read more Ssis : Creating A Flat File With Different Row Formats

Importing Excel Data Seems To Randomly Give Null Values

Using SSIS for Visual Studio 2017 for some excel file imports. I've created a package with seve… Read more Importing Excel Data Seems To Randomly Give Null Values

Sql Server Management Studio: Import Quietly Ignoring 99.9% Of Data

The Problem i'm trying to import data into a table using SQL Server Management Studio's Imp… Read more Sql Server Management Studio: Import Quietly Ignoring 99.9% Of Data