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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 problem with Flat File destination

Author  Topic 

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2010-08-27 : 11:42:15
Hello everyone

I have a flat file destination with a difference in the
Input and Output properties.

The output properties are correct. Where abouts would i correct this.

I have an OLE DB source then saving to csv via flat file destination.

Kind Regards

Rob

MCTS / MCITP certified

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-08-27 : 12:03:26
in the column mapping tab of the transformation task
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-28 : 02:19:11
you can do this from advanced editor mapping tab. you can expand and see input output columns and their properties.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -