MrHat


Hello,

My OLE DB Source is getting data from the following column types:

ID varchar(50), Name varchar(100), Date datetime, Currency char(3), Cost numeric(30,10)

My OLE DB Source outputs my information in the following order when I click Preview:

ID Name Date Currency Cost

When I connect the OLE DB Sorce to a Flat File Destination, it comes out in the wrong order.When I examine the "line" between them (Data Flow Path Editor) I get:

Currency DT_STR Length: 3

ID DT_STR Lenght: 50

Name DT_STR Lenght: 100

Date DT_DBTIMESTAMP

Cost DT_NUMERIC

What is the easiest way for me to change this so the Flat File Destination will output my data in the same order as the OLE DB Source:

ID Name Date Currency Cost

Thank you very much! Smile




Re: OLEDB to Flat File Destination - Comes out in wrong order

Rafael Salas


I think you can accomplish that by editing the properties of the flat file connection manager. Just re-define the columns in the order you require; then revisit the mapping tab to make sure eaach column is populated. I am going by memory, so let me know if you have any problem





Re: OLEDB to Flat File Destination - Comes out in wrong order

MrHat

The only property that Data Flow Editor has is "PathAnnotation".

Is there anything from the toolbox I can use between the OLE DB Source and the Flat File Destination to make sure that my columns will come out in the right order

Thank you.






Re: OLEDB to Flat File Destination - Comes out in wrong order

MrHat

Can I use Variable Mapping so solve this

If so, how would I do it

Thank you.





Re: OLEDB to Flat File Destination - Comes out in wrong order

Phil Brammer

MrHat wrote:

The only property that Data Flow Editor has is "PathAnnotation".

Is there anything from the toolbox I can use between the OLE DB Source and the Flat File Destination to make sure that my columns will come out in the right order

Thank you.



I already answered this for you yesterday... Rafael did as well in an above post. You need to define the order of the columns correctly when you build the flat file destination.

http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1703590&SiteID=1





Re: OLEDB to Flat File Destination - Comes out in wrong order

Rafael Salas

MrHat wrote:

The only property that Data Flow Editor has is "PathAnnotation".

Is there anything from the toolbox I can use between the OLE DB Source and the Flat File Destination to make sure that my columns will come out in the right order

Thank you.

You have to open the connection manager....all you need is there.