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 |
|
joep
Starting Member
5 Posts |
 Posted - 2011-04-27 : 12:28:00
|
| I have an ssis package that writes multiple text file data to an sql table. I have multiple text file imports in one package. I just added a new text file and everything appears to work fine except that this new text file data flow does not import the data from the text file. There are no error message except it says - OLE DB Destination" (2540)" wrote 0 rows. What can I do to resolve this? Thanks! |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-27 : 12:35:39
|
| Find out why it wrote 0 rows I guess.Do you have logging enabled?You could do that and look at t osee if it read any rows or run it in BI studio or from sql server and look at the output.I'm guessin that there's something wrong with the file format like an incorrect delimitter or encoding.==========================================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. |
 |
|
|
joep
Starting Member
5 Posts |
Posted - 2011-04-27 : 15:57:46
|
| Thanks! figured it out. It did not like the null values in three of my fields. I had to make some adjustments to work around them. Works now! |
|
|
|
|
|
|
0 rows written with no error messages