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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-28 : 07:38:05
|
| Rachel writes "Hello, I have created a package in SQL that brings in data from a flat file to SQL. In the data pump I have created an exception path to log all of the data that does not come through because of bad data such as incorrect data types etc. When I run the package and there are rows that are kicked out because of bad data they successfully are logged in the excpetion file and another text file is created to show whichs rows were rejected. The text files are pointed to a UNC path not to my local computer.My problem is when I set this package up as a job, the log file shows that there are no errors and I am obviously not getting the text file that shows the rejected rows. I am positive it is not bringing in all of the data, can you please help?Thank you." |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-28 : 13:49:27
|
| What happens when you point the package to the local drives of the database server for the log files?Tara |
 |
|
|
|
|
|
Exception Files