Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
janetb
Yak Posting Veteran
71 Posts |
 Posted - 2009-08-06 : 15:53:57
|
| I'm trying to use the export wizard in sql2005 on server2003 to export a table to Excel on a share on the same server. Go through all the steps and then try to save the package so I can schedule it as a job. (Parsed the straight-forward query, everything was fine.) This is a simple straight export of a table, no where clauses, case clauses, anything. But I need it to overwrite fresh, with column headings each time. Keep getting these errors. Can anyone help? (Also - told it to save within SQL - but where does it put it?)Operation stopped...- Initializing Data Flow Task (Success)- Initializing Connections (Success)- Setting SQL Command (Success)- Setting Source Connection (Success)- Setting Destination Connection (Success)- Validating (Success)- Saving (Success)- Prepare for Execute (Stopped)- Pre-execute (Stopped)- Executing (Error)MessagesError 0xc001000e: wnchnVendorReg: The connection "DestinationConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found. (SQL Server Import and Export Wizard) Error 0xc001000e: wnchnVendorReg: The connection "DestinationConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found. (SQL Server Import and Export Wizard) Error 0xc00291eb: Drop table(s) SQL Task: Connection manager "DestinationConnectionOLEDB" does not exist. (SQL Server Import and Export Wizard) Error 0xc0024107: Drop table(s) SQL Task: There were errors during task validation. (SQL Server Import and Export Wizard) - Copying to `Vendor` (Stopped)- Post-execute (Stopped)- Cleanup (Stopped) |
|
|
janetb
Yak Posting Veteran
71 Posts |
Posted - 2009-08-11 : 13:45:14
|
| Hi folks, still no reply. Went to Integration Services so maybe I could edit the OLEDB connection or just start over. But, in trying the tutorials, I have no IS template. Reinstalled sql 2005 standard edition client tools twice (using advanced to be sure they were installed locally on my machine). Still no template. Don't know where to go from here. |
 |
|
|
|
|
|
Export to Excel