Re: DTS transformation task loads partial data and succeeds

Hello JA,

OK so you have a couple of options here for trying to troubleshoot this

1. Does the query you use for the source really return different to the amount of rows you see being moved? (sure you have done this)
2. Have you been playing with the Insert and fetch buffer sizes in the Transform Data task (Last Tab)?
3. Profiler. What does it say you are doing?





--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

I am seeing some strange behavior - I am trying to load data from 2
tables, one having approx 94,000 rows and the 2nd having approx 1.4
million rows. The two transformation tasks in my dts package load
only about 800 & 200 rows respectively from these tables, and succeed.
How is this possible? I am using SQL Server 2000. It's almost as if
it's just a trial version where it succeeds after proving that the
data can be successfully imported, but does not care about the amount
of data being imported. Any thoughts?? Thanks!



.

Relevant Pages

  • Re: kara hodo
    ... ほど indicates approx. ... amount or maximim; upper limit ...
    (sci.lang.japan)
  • Re: Hubby under investigation for theft from Work
    ... its not a small amount of money missing its ... approx £250 every time the takings are banked i believe weekly. ...
    (uk.legal)
  • Re: Drinking & driving
    ... >> pints of Stella? ... approx 4-5 units) and the admission that he had been ... > his unsteadyness is not automatically connected with the amount of alcohol ... You are also failing to take into account the time period over ...
    (uk.rec.driving)
  • RE: Removing Backup File from XP installlation
    ... extremely large and taking up your hard disk space. ... should be approximately 1.5x's your amount of RAM for the top box and approx. ...
    (microsoft.public.windowsxp.help_and_support)
Quantcast