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 2008 Forums
 SSIS and Import/Export (2008)
 Export data from Excel to Fixed width file.

Author  Topic 

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2013-02-03 : 11:56:17
Hi all,
I have succeeded to retrieve data from Excel file to a flat file fixed width using the tasks (Excel source, Conversion task, Flat file destination). However, I dont like the fact that I had to hard code the position, length of each column because I have over 50 column in my Source.

Any hints please!
Thanks you all.

--------------------------
Joins are what RDBMS's do for a living

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-03 : 12:29:19
you've to set metadata for transfer. you dont need to do it individually though. It will take position, type etc based on field info it gets from the source.

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

Go to Top of Page

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2013-02-04 : 09:19:51
how to set a metadata to be transferred please. Which task help transfer metadata from my Excel headers to the destination?

Thanks a lot!!!

--------------------------
Joins are what RDBMS's do for a living
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-04 : 12:23:43
hmm..you just need a data flow task with excel source. map the source connection manager to your excel sheet and it will read and populate the metadata based on your excel sheet fieldnames

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

Go to Top of Page

xhostx
Constraint Violating Yak Guru

277 Posts

Posted - 2013-02-05 : 09:04:49
Thanks Visakh for your continuous help!

--------------------------
Joins are what RDBMS's do for a living
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-05 : 10:10:50
welcome

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

Go to Top of Page
   

- Advertisement -