Hi, there, I am having some problems with the loading of tab delimited text file (source)to a SQL Server table (destination)using the SSIS data flow task. Packagehas been executed successfully with no error msg.The number of rows in the text filealso matches the number of rows in the SQL table.But, whenI check thecontent of the table, I noticed some of thecolumns contain NULL which supposed to have value. This happens not to all the rows but only to some rows. I did some testing by removing some rows from the beginning, middle and end of the text file and re-run the package but the result is quite inconsistent. Sometimes, thefield got filled, but sometimes, it just contains NULL where it supposed to have value. What will be the possible causes to this? Thanks in advance. Regards, Yong Hwee

Did you ever get an answer? I am having exactly the same problem. Help!

Can you share a sample file?Please mark the post as answered if it answers your question