Hi,

I have a flat file, it size is more that 2.5 Gb. The file is not formatted appropriately and I have to read in one column [text stream] for future...

Note:

If your field name is like:

Your_Input_Field_Name or your_input_field_name

then in script it will be

YourInputFieldName or yourinputfieldname

Check the following:

Is this field selected in "Input columns" tab of the script component input column list?

Is your input int type field name is "IntDataTypeDate"? If it have different name,...

3. Data conversion is used to change the new run_date String [FT_STR] to Date [DT_date] => For Data conversion component input string after converting from int should be like "2009/03/08"...

Actually, I use scripts only where it is nessesary and standard option is not usefull.

Moving the package with string to date type conversion in Derived Column

from one...

Using Derived column and Substring in 3 parts makes package dependant from date format in regional settings. Have found a problem using this method after deploying on different machine, that...

I'm using Script Component for converting from "yyyyMMdd" string (20090115) to Date type. It is more accurate and is independant from date settings.

Script example:

' Microsoft SQL Server Integration Services user...

I'm using Script Component for converting from "yyyyMMdd" string (20090115) to Date type. It is more accurate and is independant from date settings.

Script example:

' Microsoft SQL Server Integration Services user...