Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Passero
Starting Member
12 Posts |
 Posted - 2008-01-25 : 07:06:14
|
| IS there a tool like sql loader for MSSQL server? We can use bulk copy but the problem is that we can not find a log with the records that gave an error. When we upload to oracle with sql loader, you can have a log where you can see a copy of each record that gave errors. THis is quite important for us and we want to have the same in MSSQL... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-25 : 23:59:52
|
| Use bcp or bulk insert, you can specify error file in both. |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2008-01-26 : 15:26:52
|
quote:
Originally posted by Passero
IS there a tool like sql loader for MSSQL server? We can use bulk copy but the problem is that we can not find a log with the records that gave an error. When we upload to oracle with sql loader, you can have a log where you can see a copy of each record that gave errors. THis is quite important for us and we want to have the same in MSSQL...
check for the various switches provided with bcp,,excellent utility !! |
|
|
|
|
|
|
oracle's sql loader in MSSQL?