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 |
|
Levi
Starting Member
2 Posts |
 Posted - 2011-06-24 : 11:43:24
|
| Hi,I am trying to import an excel file into a sql server 2005 database table. SSIS package runs successfuly without any errors, yet no rows are written to destination table.I used a data viewer and it shows all the data i expect to import. I also checked the data flow path, and it shows the correct numbers of rows going to destination and error output. error output table is populated but not the destination table.Any and all tips are highly appreciated! Thanks,Levi---- error msg------------------ Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Excel Destination" (35056)" wrote 3 rows.Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "OLE DB Destination" (17722)" wrote 0 rows.SSIS package "Package.dtsx" finished: Success. |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-24 : 12:00:38
|
| That says it didn't write any rows to the destination.Are you sure you saw rows gooing to that output?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Levi
Starting Member
2 Posts |
Posted - 2011-06-24 : 12:19:21
|
| nigelrivett:I have a dataviewer between the conversion and destination components. And, I can view all the rows there.Levi |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-24 : 12:28:16
|
| component "OLE DB Destination" (17722)" wrote 0 rows.Is that the destination you expect to receive the rows?What does the rowcount on the pipeline say when you are viewing?What happens if you remove the viewer - does the count look ok.COuld be failing to send to the component or getting a write failure or maybe the destination isn't what you think it is.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
|
|
SSIS package succeded, but wrote 0 rows in destina