| Johnson 2005-09-28, 3:24 am |
| I download your dts package about article: How to export all tables in a
database from http://www.sqldts.com/default.aspx?299
Here are the reproduce steps:
1. rename DTSBulkExport.msi.2 to DTSBulkExport.msi and install the
custom task DTSBulkExport.msi
2. open ExportTestMS.dts from SQL Enterprise Mgr -> DTS -> open package
3. modify the conn info
4. modify the properties of the BulkExportTask to reflect local SQL
server/login
5. create a working path c:\temp\test
6. enable IIS->SMTP service if it is not already enabled
7. run the package, three text files "pmm_customers*" should be created
under c:\temp\test plus another file "pmm_complete"
8. modify one text file e.g. pmm_customer.txt to read only
9. rerun the package, one task should fail (because pmm_customer.txt is
not writable). An email notice is expected for this task failure, and this
time the file "pmm_complete" should not be created.
If I modify one text file e.g. pmm_customer.txt to read only, I'm having
trouble with last step because I can't catch this failed task correctly.
DTS is able to catch the failed task. My biggest concern is how to catch the
failed task inside the script code.
Thank you very much!
|