chfran ( ) writes:
> I'm trying to Bulk Insert data but the table has yet to be created. I
> don't know what the definition of the table should be so the data
> imports without a hitch. Any suggestions?
And how would know? We have not even seen the data!
Seriously, it would help if you described the situation a little
closer. Normally when you import data from a file, you have a definition
of what it's in the file. The table you import do does not have to map
one-to-one to the file; by using a format file, you can select only
certain columns in the file, and the table could have extraneous columns.
So if you are facing the situation that you are to import files, but you
don't know in advance how they will look like, that is a kind of odd
situation. And since you normally use the table in further processing,
that further processing would be funny if the table structure is not
known.
--
Erland Sommarskog, SQL Server MVP, esquel.TakeThisOut@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
FAQ
Search
Profile
Private Messages
Log in
