March 18, 2011 at 10:59 am
I have a simple package that contains a for each loop with a data flow step. My data flow has a flat file source and a ole db destination. It appears to be reading the files in the source directory. I see the number of rows each file contains, but I do not see data in my destination table. I have tried verifying the data connection, and I reviewed that its using a fast load option. still no data.
Am I forgetting something??
March 18, 2011 at 11:56 am
Sounds like its setup correctly but SSIS being mostly visual it's hard to say what the issue might be...can you zip it up and post the package as an attachment?
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2011 at 12:12 pm
The message that makes no sense to me is
"[SSIS.Pipeline] Information: "component "OLE DB Destination" (370)" wrote 0 rows."
March 18, 2011 at 12:21 pm
Attached is the package I referenced in my earlier question.
March 18, 2011 at 1:35 pm
ejdonavan, I am assuming this is a SQL 2008 SSIS Package because I cannot open it in BIDS 2005. It'll need to wait until tonight before I can have a look.
I know there is not a 2008 SSIS forum...but I think there should be...Steve (Jones, SSC Editor)...are you listening? 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 18, 2011 at 1:54 pm
yes its visual studio 2008 thats whats installed here.
March 18, 2011 at 2:56 pm
Have you tried putting data viewers on the precedent constraint pipes to see what data is passing from one transform to the next? Is data getting to the task to write to the table?
March 21, 2011 at 6:42 am
Data viewer showed the data coming through fine.
March 21, 2011 at 7:10 am
opc.three (3/18/2011)
I know there is not a 2008 SSIS forum...but I think there should be...Steve (Jones, SSC Editor)...are you listening? 🙂
All the way down, there is a general Integration Services forum 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2011 at 7:17 am
Does the OLE DB Destination become green or red? Or does it stay yellow?
Are there any specific error/warnings or informational messages?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 21, 2011 at 7:22 am
Koen Verbeeck (3/21/2011)
opc.three (3/18/2011)
I know there is not a 2008 SSIS forum...but I think there should be...Steve (Jones, SSC Editor)...are you listening? 🙂All the way down, there is a general Integration Services forum 🙂
I know about that one, but 🙂 I posted a suggestion and Steve commented. I am not sure how fast things move, but it sounds like they were already discussing some aspects of a mild re-org of the Forums: http://www.sqlservercentral.com/Forums/Topic1080693-4-1.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
March 21, 2011 at 7:38 am
OLE DB Connection turns green for each file processed
March 21, 2011 at 8:25 am
turns green with no warnings messages, progress tab shows 6626 records read. 0 records wrote.
Viewing 13 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply