i have a large text file which i need to import into sql server. i have been able to map the fields and load the data. it is a fixed width file. the process works. however during testing i found that there are some character which are not visible in notepad.
on a hex editor they show the value of 00 - null. in the file . the ssis package reads till the column it finds null and then considers it as a carriage return and moves to the next line.
please suggest how i can resolve this issue. i wrote a vbscript where i could open the file and save it again using notepad, it works for small files. but my input file is around 2 gb.
View Complete Post