Missing SSIS toolbox visible in 2010 after migrating my SSIS package from 2008 to 2012

Hi Folks
I followed the below link to get the missing SSIS toolbox visible in 2010 after migrating my SSIS package from 2008 to 2012


http://www.jamesserra.com/archive/2013/01/ssis-2012-empty-toolbox/
 

The flat file parser does not support embedding text qualifier in data...Amazing and simple solution

Hi Guys,
I am trying to migrate from DTS to SSIS and 1 of the task was to import data from text file which had double quotes in it. But I will get the below error

"The flat file parser does not support embedding text qualifier in data". I also noticed that the column delimter was not highlighted in the "Columns" tab

After spending hours to resolve this issue, I found  the solution and it is to Just click on "Reset Column" in your connection manager and you will get the "Column Delimiter" highlighted,

This solution is not available in most of the google blogs

Trim first few characters in SSIS derived column

Hi Guys,

If you want to remove first few characters in a word in one of the column in derived column in ssis then you can use the below statement
REPLACE (<columnname>,"Word to be replaced","")

Example - SUPER_CLIENT in column PORTFOLIO will be replaced by nothing or that word will be removed using the below statement
REPLACE(PORTFOLIO, "SUPER_CLIENT:","")

If Else If and else statement in derived column in SSIS

Hi Guys,
Follow the below statement type to achieve if else if condition in ssis

[MyStringVar] == "TEST1" ? "IT WAS TEST1":
[MyStringVar] == "TEST2" ? "IT WAS TEST2":
[MyStringVar] == "TEST3" ? "IT WAS TEST3":
"MATCH NOT FOUND"

"parameter name is unrecognized" SSIS

Hi,
Today I got error while making use of SSIS parameters in variables

"parameter name is unrecognized"
To resolve this error - set New Parameter Name as 0 in the Parameter Mapping window

Replace "NA" or any other values with NULL in derived column SSIS

Hi Guys,
To Replace "NA" or any other values with NULL in derived column SSIS use the below code

ColumnName == "" ? NULL(DT_WSTR,50) : ColumnName

I noticed that the below code did not work

ColumnName == "" ? NULL(DT_STR,50,1252) : ColumnName. So I just used DT_WSTR as it did not make much difference

Failed to set property expression on the output column

Hi Folks,
Today I faced a strange issue.
In the DFT task there is a text file as input file, derived colun and output oledb destination.
When I am adding a new add to new column , I am not getting the datatype. After much research the workaround for this was create a new field for this new column in the data conversion task before the derived column and then make use of this column.

The reason for this failure is that the text file does not contain proper input data field. Enjoy coding ...