I have a red link from my OLE DB Destination to my Flat File Destination. I'm not sure why it's read but the OLE DB shoves some data into a table. I want to then take that data and move it into a flat file using the flat File Destination step but when I run my project, it shows the Flat File Destination Step green but my flat file shows nothing at the end.
I'm not sure what I'm doing wrong but the line linking the two is still red. Check out my picture here:
http://www.photopizzaz.biz/junk/1.jpg
and then the properties of my flat file destination module:
http://www.photopizzaz.biz/junk/2.jpg
http://www.photopizzaz.biz/junk/3.jpg
and my flat file connection manager editor properties:
http://www.photopizzaz.biz/junk/4.jpg
http://www.photopizzaz.biz/junk/5.jpg
Actually you redirected only the ErroroOutput of the OLE DB Destination.
Once the rows got into OLEDB Destination they don't move further. You need to add a Multicast transform in front of OLE DB destination to multiply the rows. And you can send one output to OLE DB Dest and one output to Falt File Destination
HTH,
Ovidiu
Ok, got it to work, I didn't need what you said. I just used an OLE DB Source like I tried oringally but just deleted and reset it up shown here:
With that, how do I specify order of the workflow between my left side and right side. In other words, how do I ensure that after the OLE DB Destination is run, that it runs my OLE DB Source next? Since I can't hook an arrow between the 2, what is the proper way to ensure workflow and order here between the left set of tasks and right set of tasks show here:
http://www.photopizzaz.biz/junk/6.jpg
|||You cannot force parallel graphs in the same Data Flow to execute sequentially. By setting them in the same Data Flow task you are actually setting a preference for them to be executed concurrently.
To assure your data flows are executed sequentially use multiple Data Flow tasks and connect them to define a wished order.
Thanks.
|||thanks, I actually figured out the data flow as you suggested.
没有评论:
发表评论