SQL Server Integration Services please HELP

[johnlim20088]

Hi,

Can someone help me on SSIS?

I have a text file with following line

123,U Sdn Bhd,13333
234,Good3 Food Bhd,
236,Good9 Food Bhd,12232
238,Good8 Food Bhd,
239,Hi Sdn Bhd
2233,Store Sdn Bhd,2233


I use SSIS package to import the row value, you can notice that there is 3 column, so i SSIS i define it as sColumn0, sColumn1, sColumn2.

Then in script task manager, i use vbscript to display the value as following:-

MsgBox(Trim(Dts.Variables("User::sColumn0").Value. ToString) & " --- " & Trim(Dts.Variables("User::sColumn1").Value.ToStrin g) & " --- " & Trim(Dts.Variables("User::sColumn2").Value.ToStrin g))


all working fine, BUT until the line -> 239,hi Sdn Bhd
the error come out, it should display only -> 239 --- Hi Sdn Bhd,

BUT it display 239 --- Hi Sdn Bhd --- 2233

which is 2233 is a last line records column1

what is the happen? is it because I declare 3 variables in SSIS, but in this line, i only put two values which is -> 239,Hi Sdn Bhd?

I should put 239,Hi Sdn Bhd,xxxx???

but SSIS should read brand new start next line right?

is it delimier problem?



Finally, when i change my text file to:-
123,U Sdn Bhd,13333
234,Good3 Food Bhd,
236,Good9 Food Bhd,12232
238,Good8 Food Bhd,
239,Hi Sdn Bhd,3322
2233,Store Sdn Bhd,2233

it will read row by row,
can someone help me?