469,588 Members | 2,688 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,588 developers. It's quick & easy.

how to use multiple delimiters for the same flat file

Hi everyone,

There is a small problem encountered while creating a package in sql
server 2005.
Actually i am using a flat file which has 820 rows and 2 columns which
are seperated by line feed(for ROW) and tab(for COLUMN).after
importing i found that ther are only 800 rows imported into the table.
Ather verifying the input file i found out that there are some null
values in the second column so there is no line feed for those
values.
Can anyone please help me how to give multiple delimiters for the same
input flat file.
Sep 6 '07 #1
1 1777
Hi everyone,

There is a small problem encountered while creating a package in sql
server 2005.
Actually i am using a flat file which has 820 rows and 2 columns which
are seperated by line feed(for ROW) and tab(for COLUMN).after
importing i found that ther are only 800 rows imported into the table.
Ather verifying the input file i found out that there are some null
values in the second column so there is no line feed for those
values.
Can anyone please help me how to give multiple delimiters for the same
input flat file.
How do you know there are 820 lines?

If you saw it in a text editor, it sounds like a different linefeed is being used (carriage return + linefeed combination opposed to just linefeed).

Otherwise, replace nulls with linefeed characters. You can use the SQL REPLACE function. Or, open the file with filesystemobject.textstream, readall(), then do a replace on the returned stream.
Sep 6 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

7 posts views Thread by Kylotan | last post: by
22 posts views Thread by Matthew Louden | last post: by
15 posts views Thread by lxyone | last post: by
4 posts views Thread by Marco Trapanese | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.