I just learned how to do DTS transformations two weeks ago, and I figured out most of it just by playing around with the SQL Server Enterprise Manager. A good reference is "DTS Transformations" from WROX. But you don't need all of that. You can just use "SQL Server 2000 programming," also from WROX.
It's much better to schedule it through SQL Server. CF isn't really made for this and it's really, really slow (compared to SQL 2K). --- "Bosky, Dave" <[EMAIL PROTECTED]> wrote: > I have a user that uploads an Access database every > 2 weeks and I want to > create a DTS package to automatically > Import the data into sql server. What are some good > references for creating > Access->SQL DTS packages? > > Would you schedule the package to run through sql > server or should I setup a > scheduled task in CF to connect to the package and > run it every two weeks? > > Thanks, > Dave ===== I-Lin Kuo Macromedia CF5 Advanced Developer Sun Certified Java 2 Programmer __________________________________________________ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://http://taxes.yahoo.com/ ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
