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 MVP
http://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 MVP
http://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 MVP
http://visakhm.blogspot.com/
|
|
|
|
|
|
|
Export data from Excel to Fixed width file.