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
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/
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/
Export data from Excel to Fixed width file.
Posted - 02/03/2013 : 11:56:17
