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 |
|
lost_and_found
Starting Member
1 Post |
 Posted - 2006-02-20 : 14:34:52
|
| This should be simple. I have done something very similar before but for the life of me I have sat in front of this PC for hours and I still can't work it out ... It is a simple problem. I have a table with a single row holding a date range in the form of DateStart and DateFinish.I want to use DTS to explode this single record into multiple records, one for each day in the range. So easy - just use DTSTransformStat_SkipFetch with a loop of some description ... but can I get it to work?I have tried a simple for loop:For i = DTSSource("DateStart") to DTSSource("DateFinish") DTSDestination("myDate") = i Main = DTSTransformStat_SkipFetchNextMain = DTSTransformStat_SkipInsertFor some reason this simple exports the final iteration.I have also tried a Do While loop with logic to Exit Do at the right stage.I am missing something very obvious, put me out of my misery please. |
|
|
|
|
|
Using DTS to break out Date Ranges ...