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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-13 : 00:34:04
|
| JT writes "I have a text file which contains rows of product information for multiple stores. There are also rows which contain store information.For example:storename storelocation managernameprodid proddesc prodquantity prodprice proddiscountprodid proddesc prodquantity prodprice proddiscountprodid proddesc prodquantity prodprice proddiscountprodid proddesc prodquantity prodprice proddiscountstorename storelocation managernameprodid proddesc prodquantity prodprice proddiscountprodid proddesc prodquantity prodprice proddiscountstorename storelocation managernameprodid proddesc prodquantity prodprice proddiscountprodid proddesc prodquantity prodprice proddiscountprodid proddesc prodquantity prodprice proddiscountprodid proddesc prodquantity prodprice proddiscountUsing DTS, how do I identify the different row types, and put the store rows into one table, and the product rows into a different table?" |
|
|
|
|
|
Using DTS to transform text files which contain header rows