I have less fields in my flat file:
1> select * from test1
2>
name1 name2
---------- ----------
aaa aaa
ccc ccc
bbb bbb

which can be gathered in data file using bcp in process

I need to import this to a table having more number of
columns which can have null values at the end. Can this be
possible using a single bcp command without the use of
format file?
Table structure: <all fields having char(10) data type in
source file as well as in destination table >

1> select * from test
2>
name1 name2 name3
---------- ---------- ----------

(0 rows affected)

The limitation here is that <I will have to use the bcp
command with a table name (i cant do a select column list)
to my destination server> Is this possible with any record
delimiter parameter without using format files.
Any thoughts on this wd b really appreciated...

Thanks,
Rose

Don't think so. I think if you want to start doing this using BCP and only
the table name as the source then a format file is the way ahead

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\adm
insql.chm::/ad_impt_bcp_57qd.htm

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"rose" <anonymous (AT) discussions (DOT) microsoft.com> wrote