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.
| 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 MVPhttp://visakhm.blogspot.com/ |
 |
|
|
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 |
|
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
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 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-02-05 : 10:10:50
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Export data from Excel to Fixed width file.