"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 ...

Left() in SSIS derived column

Hi Folks,

There is no Left() in derived column in SSIS and hence use SUBSTRING(<your string>, 1, <num of chars>)

Is Not Null in SSIS

Hi Folks,
Did you ever wonder how to implement the IS Not NUll condition in SSIS derived column. Its easy just write the below code

!ISNULL(D_Stock) ? (DT_NUMERIC)Stock : 0