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"