Search Results | SQL Server Performance Forums

Exception Files

Post by: ryeradio, Jun 30, 2004 in forum: SQL Server DTS-Related Questions

Hey Justin, <br />I am feeling the same way, I am ready to pull my hair out. I have been working on this problem for about a month now and have...

Exception Files

Post by: ryeradio, Jun 25, 2004 in forum: SQL Server DTS-Related Questions

I don't think I am explaining this clearly enough. There is one row that is not transferring. I have cross checked the destination file with the...

Exception Files

Post by: ryeradio, Jun 25, 2004 in forum: SQL Server DTS-Related Questions

Any ideas?

Exception Files

Post by: ryeradio, Jun 22, 2004 in forum: SQL Server DTS-Related Questions

The source file has 825 records, the destination table has 824 records. This clearly shows that there was one rejected row, but the exception file...

Exception Files

Post by: ryeradio, Jun 22, 2004 in forum: SQL Server DTS-Related Questions

I actually want the error. I know what the error is, it is rejecting one row that has an invalid date type. That is my problem, I want it to show the...

Exception Files

Post by: ryeradio, Jun 21, 2004 in forum: SQL Server DTS-Related Questions

This is the senerio, I have an SQL task to delete a table. I have a txt source file and an SQL connection. The data pump between the txt source file...

Exception Files

Post by: ryeradio, Jun 21, 2004 in forum: SQL Server DTS-Related Questions

Sorry I am a bit confused, run a query based on the rows in the text file through QA? I need to be able to identify which rows were rejected so I can...

Exception Files

Post by: ryeradio, Jun 21, 2004 in forum: SQL Server DTS-Related Questions

I ran a trace by running the package as a job and running it manually. I can't identify where the exception is made. What should I be looking for? Is...

Exception Files

Post by: ryeradio, Jun 21, 2004 in forum: SQL Server DTS-Related Questions

quote:Originally posted by satya Try running PROFILER during this operation in order to see the activity. Satya SKJ Moderator...

Exception Files

Thread by: ryeradio, Jun 18, 2004, 16 replies, in forum: SQL Server DTS-Related Questions

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...