Yes, you run the wizard and perform all the tasks you want, then save as a DTS package. Then you run the scheduler wizard and tell it to run that DTS package.
-----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 14:13 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] DTS Package to Access No, I dont think BULK Insert will do it. -----Original Message----- From: Steve Martin [mailto:[EMAIL PROTECTED]] Sent: 28 November 2002 12:25 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] DTS Package to Access Yes. Check out the BULK INSERT T-SQL in books online. > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED]] > Sent: 28 November 2002 11:49 > To: '[EMAIL PROTECTED]' > Subject: [ cf-dev ] DTS Package to Access > > > Is it possible to run a DTS Package within SQL Server to > export/import data > into an MS Access File for download? > > N > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] For > human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
