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 |
|
krishtxraj19
Starting Member
8 Posts |
 Posted - 2009-02-25 : 22:14:59
|
| HI all, i am new to SQL Server Integration Services. I am trying to load list of flat files into target table. I am using Foreach loo to do that. But my files data is different than regular files.The first row of the file is file name and row count and from second row, it has the actual data. here is the exampleCust_America 100010011 Chris Brown TX US10012 Chalrs Brown FL US10013 Martin James IL USnow i want to load first row in different table called daily audits and from second row i want to load in my customer dimension.Can someone help me on this scenarion.Thanks in AdvanceKrish |
|
|
|
|
|
Loading Flat file data into OLE DB data base