>Are you sure DTS doesn't log changes? I am having trouble running out of space on the hard drive [when it rains it pours] because the log file balloons...it fills the drive and DTS stops. Is there a setting on DTS that I could set to stop the logging?
>
>Thanks,
>Doug
I have a DTS package that converts a big VFP table into entries into multiple SQL tables. No logging whatsoever. Logging for the DB is set to FULL.
Off the top of my head, if you are importing into tables that have triggers that in turn generate other records, this could be the action that is getting logged. I believe you can programmatically enable/disable logging for the entire DB (by setting the logging to SIMPLE via a DTS SQL EXEC task at the start, and reseting to FULL via the same kind of task at the end). The other option would be to see what triggers are getting fired when the tables are updated, and drop them at the beginning of the package. Be sure to recreate them at the end.
Hope that helps.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.