![]() ![]() ![]() This will get the data in without failing the package, but you will be missing some of the rows that are causing you problems.Īlso, make sure that you are checking the exact error that is thrown when the package does fail. ![]() And that the Fail Package on First error checkbox on the Package Properties is not checked. Make sure you have logging enabled on the package. In the Transform Data Task properties, Options Tab, Under the Data Movement section, increase the Max Error Count. (You may want to create a new Package for this).Īlso, try increasing the max error count property. In DTS you can do this quickly by clicking the CREATE button on the Destination Tab of the Transform Data Task and rebuilding your transforms. But first you might try importing the data into a staging table that is built based on the source. You will likely have to look at the data from your source before import to see why there is errant data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |