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 |
|
Rheinhardt
Yak Posting Veteran
66 Posts |
 Posted - 2011-02-14 : 01:01:16
|
| Hi,I have a raw file/History file that I need to integrate into SQL table using Visual. I want to avoid using a sql task to manipulate the data...is there a way that I can map the layout of the data using only Visual without going the sql task route?See below:Format of Raw:[Item], [Customer], [2011-01], [2010-12], [2010-11]...itema, customerb, 10, 12, 15Destination Format:[Item], [Customer], [Date], [QTY]itema, customerb, 2011-01, 10itema, customerb, 2010-12, 12itema, customerb, 2010-11, 15 |
|
|
|
|
|
|
|
Integration Problem