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 |
|
pizzazzz
Yak Posting Veteran
55 Posts |
 Posted - 2010-07-14 : 19:49:54
|
| HELP with Import/Export wizard!I have been trying to get this to work most of the afternoon - I am using the import/export wizard to run a sql script from sql server and write(export) results to excel and after I got most of the (convoluted) errors fixed, it will not export the records.This is the results from my package, it's the last message that concerns me and i don't know how to fix this so it will export to excel.any help would be appreciated!The execution was successful- 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 (Success)- Pre-execute (Success)- Executing (Success)- Copying to `Query` (Success)0 rows transferred - Post-execute (Success)MessagesInformation 0x4004300b: Data Flow Task 1: "component "Destination - Query" (61)" wrote 0 rows. (SQL Server Import and Export Wizard) |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-15 : 01:10:49
|
| how many records if you execute the query in SSMS? |
 |
|
|
pizzazzz
Yak Posting Veteran
55 Posts |
Posted - 2010-07-15 : 12:08:12
|
| Approx 550+ - very small data set |
|
|
|
pizzazzz
Yak Posting Veteran
55 Posts |
Posted - 2010-07-16 : 16:42:31
|
| Finally got this to work, but it wasn't very easy or straight forward. |
|
|
|
|
|
|
unable to write records from export wizard to exce