Hi All,
I was using INSERT statement to insert the rows from a flat file to a table. Since it was taking too long to load the data, now I created the DTS package to load the data directly from the data file. The flat data file is a pipe delimited data file. When I have two pipes are next to each other, DTS package is iserting nulls into those columns. But I want the those columns to be empty not null. Does any one know how I can achieve this?.
For example, I have the following record.
123|test|||
This is how I used to isert the record with INSERT command
Insert into table1 values('123','test','','','')
Col3, Col4, Col4 used to have empty value.
After I started using DTS package, these columns are having NULL values. Is there any option in the DTS so that it inserts empty values instead of NULLs?. I appreciate any help?
I was using INSERT statement to insert the rows from a flat file to a table. Since it was taking too long to load the data, now I created the DTS package to load the data directly from the data file. The flat data file is a pipe delimited data file. When I have two pipes are next to each other, DTS package is iserting nulls into those columns. But I want the those columns to be empty not null. Does any one know how I can achieve this?.
For example, I have the following record.
123|test|||
This is how I used to isert the record with INSERT command
Insert into table1 values('123','test','','','')
Col3, Col4, Col4 used to have empty value.
After I started using DTS package, these columns are having NULL values. Is there any option in the DTS so that it inserts empty values instead of NULLs?. I appreciate any help?