Hi, i have csv file with 100 records. while i open the csv file in notepad its shows all records into single row. i have done manually into 100 records. suppose some times i got lacks record. i am not able to change line by line. how can i solve this problem.

What do you have set as your row delimiter in the flat file destination? Try {CR}{LF}Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/

Hi, Just go to format tab in notepad and click on 'Word Wrap'.This may arrange the data in proper format. Or else load the .csv file in some dummpy SQL table and from that table you can verify the data. Hope this helps ! Thanks, Vaibhav

Hi, i have csv file with 100 records. while i open the csv file in notepad its shows all records into single row. i have done manually into 100 records. suppose some times i got lacks record. i am not able to change line by line. how can i solve this problem. It seems that your CSV file is not proper. In CSV file each row should be ended with <CR><LF> (carriage Return & Line feed)-ankur Please mark post as answered as applicable

It seems that your CSV file is not proper. In CSV file each row should be ended with <CR><LF> (carriage Return & Line feed) -ankur Please mark post as answered as applicable It doesn't have to be <CR><LF>. You can configure the row delimiter in the Flat File Connection Manager in SSIS.MCTS, MCITP - Please mark posts as answered where appropriate.

It seems that your CSV file is not proper. In CSV file each row should be ended with <CR><LF> (carriage Return & Line feed) -ankur Please mark post as answered as applicable It doesn't have to be <CR><LF>. You can configure the row delimiter in the Flat File Connection Manager in SSIS. MCTS, MCITP - Please mark posts as answered where appropriate. He is using this file as source file and all rows are lying in a single row. Then there has to be a row delimiter in file first and normally it is CRLF. Now to configure that row delimiter in SSIS is a secondary thing.-ankur Please mark post as answered as applicable

He is using this file as source file and all rows are lying in a single row. Then there has to be a row delimiter in file first and normally it is CRLF. Now to configure that row delimiter in SSIS is a secondary thing. -ankur Please mark post as answered as applicable If the row delimiter in this file is CRLF, then there wouldn't be a single row. It is normally CRLF, on Windows systems. If the file originates from a UNIX environment (mainframes for example), then the row delimiter can be something else, such as CR only. This is an SSIS forum, I wouldn't consider configuring SSIS properties a secondary thing.MCTS, MCITP - Please mark posts as answered where appropriate.

He is using this file as source file and all rows are lying in a single row. Then there has to be a row delimiter in file first and normally it is CRLF. Now to configure that row delimiter in SSIS is a secondary thing. -ankur Please mark post as answered as applicable If the row delimiter in this file is CRLF, then there wouldn't be a single row. It is normally CRLF, on Windows systems. If the file originates from a UNIX environment (mainframes for example), then the row delimiter can be something else, such as CR only. This is an SSIS forum, I wouldn't consider configuring SSIS properties a secondary thing. MCTS, MCITP - Please mark posts as answered where appropriate. Exactly, either file is missing something or it may be CR if is from UNIX. whatever is the case Requestor has to first find what is there in file. By telling SSIS properites as secondary thing I meant once file is good and known to user then this can be configured. I didn't meant any offence. SSIS forum is here to solve people root issues too...... even if it is related to source file and not SSIS as such.-ankur Please mark post as answered as applicable

Sorry vamsi but if the file is not in a proper format we cant help you. you need to contact the system admins who generated that file and find out the row delimiter they have used. For a CSV it is {CR}{LF} in windows and {CR} in UNIX but some times the developers specify custom Row delimiters. find out the delimiter and you are done Regards, Surender Singh Bhadauria

What do you have set as your row delimiter in the flat file destination? Try {CR}{LF}Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/