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 |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-09-02 : 17:14:57
|
| I have a data flow task import from xml to a database table I add on error redirect rows and specified the error output column names. pulled the red arrow and point it to a file.The file is created whether there is an error or not if there is no error the file is created with the column names on the first line and nothing is in the file.Thankssarah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-02 : 21:01:59
|
| is your xml well formed? try putting a data grid viewer in pipeline from xml source to table and see if you're getting blank rows------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-09-03 : 19:54:19
|
| my xml is well formed I am using xslt to generate a well formed xml file. I don not have any blank rowsxml task (xslt) output to a dataflow task (takes the output of the xml task and insert the result into a table)thankssarah |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-04 : 00:12:25
|
| did you see whether you're getting blank rows through data grid viewer?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-09-04 : 18:39:31
|
| I will check thatThankssarah |
|
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-09-05 : 12:27:34
|
| I checked no extra rowPlease how can I attach a file to show you what I have so as to explain my problem better.Thankssarah |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-05 : 13:05:30
|
| attach file in some shared fileserver and post the path------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-09-05 : 13:10:17
|
| I do not have a shared fileservercan you provide me with an email address so as to send you my filesthankssarah |
|
|
|
|
|
|
Error files created even if there is no error