October 31, 2005 at 9:12 pm
Hi all,
I had created a DTS packages which was running fine from last one year and from 2 days it is failing.
In my DTS pacakage i am tranferingdata from sql server to Access.
When i execute the package in design mode it runs fine but when i schedule it is give me error that maximum number of falling rows.
I dont understand why this type of behaviour and error.
pls help
thanx for ur time and help
from
Killer
November 2, 2005 at 7:40 am
When you export to Access, there is a parameter for the maximum of allowable failed transfers. It's default is one row.
Usually, when I see this it is because of at data type error, like trying to copy a int into a date field. Another common problem is copying a text into a numeric field where almost all the text rows are numeric, but there is one with an alpha character in it. The export will transfer all the records up to the error, then error out. If you don't care about transferring records with those kind of errors, change the parameter for max number of errors from one to a greater number.
Hope this helps!
Michael Lee
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply