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 |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2003-03-04 : 20:59:13
|
| Hi Folks,DTS Package ConsistsText file SourceData Pump TaskSQL Server ConnectionActivexScript Task.(To loop through Files).I have a DTS package which pulls data from text files into a SQL Server DB table. The text files are present in different folders. I loop through using the activexscript to traverse the different folders and assign the text file connection to point to the next text file.When text file size of 0 bytes is encontered, how do I disable the Datapump task to prevent it trying to load data from 0 bytes file. I am using the looping example provided in SQLDTS.com site. Is there a way to disable the datapump task. Right now I get a error and the package stops.Thank youByeRamdasRamdas NarayananSQL Server DBA |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
|
|
|
|
|
DTS Pkg- Data Pump Task.