About IMPORT and EXPORTS
-
I have this task of finding the equivalent of SQLLDR of Oracle in SQLServer.. and I figure that I should use BCP for this, and that went fine.. I have successfully done that but, then here's the problem, in SQLLDR one can load data from a file using control files which is similar to BCPs format files, but in SQLLDR, one can change the data as the row is being imported or being exported..
and at first glance at BCP format files, I have realized that it is kind of straightforward load... is this correct?...
Sorry, I'm really confused here.. I need help. I'm very new to format files so
-
Yes, that's correct. bcp is 'straight forward'
If you want to do transformations on the fly, take a look at DTS instead.
/Kenneth
-
They would like to do the import using a batch file and BCP seems the easiest thing to do.. can I use triggers together with this so as to have some on the fly processing?..
.. but then I guess not. -
See if this helps: http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/incbulkload.mspx
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Personally I prefer (and so far always does) to just wham the file into a staging table using bcp, and then do whatever cleaning/validation/etc necessary by Transact SQL. For the 'average load-job' this method has so far been sufficient for me.
As a sidenote, I'm not to keen on bulking anything straight into a production table.
/Kenneth
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply