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 |
|
vamsimahi
Starting Member
29 Posts |
 Posted - 2008-09-17 : 22:24:02
|
| I am loading data from flat files(.csv) to OLEDB destination(SQL Table). There are lot of files and I load most recent 12 files every week. My source files have 30 columns and I am just loading 20 columns to my destination(don't need the other 10 columns data). Here is the situation some of the csv files have the columns disordered. They have all the 30 columns but they are in different order from the others and the data is also getting loaded disorderly. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-20 : 02:34:40
|
| Thats a problem with source. You need to make sure data is always coming in source in correct order. Instances of bad data can be handled in SSIS whereas changes of order of data needs to be fixed at your source. |
 |
|
|
|
|
|
column order different in source files..