One thing to consider when setting up DTS packages like this (if using MS SQL)... set the package up from the actual server it's going to run on (if you have physical access to the server, great, if not, remoting into it works fine as well.) If at all possible, avoid setting it up through Enterprise Manager on your local desktop. If you don't set it up from the server, but then attempt to run this package with a scheduled job, a whole host of errors can occur. When a server executes a DTS package (via a schedule) that was created from your local machine (via Enterprise Manager,) there are ownership (and sometimes MDAC) conflicts that can cause the schedule to error out.
"James Chad Olivier" <[EMAIL PROTECTED]>@dfwcfug.org on 01/23/2004 09:27:04 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: <[EMAIL PROTECTED]> cc: Subject: RE: SQL-S Tables/.csv Yes, that's what I was going to recommend to solve the problem. To sidestep building a DTS Package from scratch, you can perform an export and an import data. At the end of the wizard, there is an option to save it as a DTS Package. You can save them separately and set your schedule to run one after the other, or you can cut and paste one into the other and they can run at the same time (if you do this and one must run before the other, make sure to set a workflow for on completed between the two processes. -Chad -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of David L. Penton Sent: Friday, January 23, 2004 9:10 AM To: [EMAIL PROTECTED] Subject: Re: SQL-S Tables/.csv Look into using DTS for this. You can set it up as a job and kick it off on a schedule, or run it directly using DTSRUN.exe using your favorite windows command shell API. David L. Penton, Microsoft MVP JCPenney Application Specialist / Lead "Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. Bach" [EMAIL PROTECTED] Do you have the VBScript Docs or SQL BOL installed? If not, why not? VBScript Docs: http://www.davidpenton.com/vbscript New SP3 SQL BOL: http://www.davidpenton.com/sqlbol ---------- Original Message ----------- From: "PJ Gaenir" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Sent: Fri, 23 Jan 2004 08:19:32 -0600 Subject: SQL-S Tables/.csv > This is one of those basics it's embarrassing to ask about, but finding a > simple how-to hasn't been as easy as I expected. > I have two things I need to do with SQL Server and ColdFusion and I'm not > sure of either. > > 1 - I need to save a large table from SQL-S (hopefully from Enterprise > Manager) to .csv format. > > 2 - I need to import some .csv/.txt files data into an existing SQL-S table. > > I'd be grateful for a link to something with instructions. Thanks a ton. > > PJ > > --- > [This E-mail scanned for viruses by Declude Virus] > > ----------------------------------------------- > To post, send email to [EMAIL PROTECTED] > To unsubscribe: > Send UNSUBSCRIBE to [EMAIL PROTECTED] > To subscribe / unsubscribe: http://www.dfwcfug.org ------- End of Original Message ------- ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ----------------------------------------------- To post, send email to [EMAIL PROTECTED] To unsubscribe: Send UNSUBSCRIBE to [EMAIL PROTECTED] To subscribe / unsubscribe: http://www.dfwcfug.org
