October 30, 2002 at 9:33 am
Hi,
I have created some pretty complicated DTS packages. I'm wondering - whats the general difference between this and TSQL? Is one better than the other, or is it that the "hard core" programmers prefer to write all the code themselves using tsql? Any opinions?
(also - since i havnt written any tsql by hand, where do you do this in the enterprise manager? where are they stored?)
thanks
mike "newbie" d.
October 30, 2002 at 1:40 pm
Great, thanks for the insight!
I do have a question about DTS if anyone knows. How can I loop through a recordset in DTS? What I need to do is select a set of filenames, then use activex script to validate if the files actulaay exist (depending on if they are - do other stuff...). I guess I dont know how to select a recordset, then work my way through it.
October 30, 2002 at 2:00 pm
cool, i have somthing similar to that to see if they exist. I see your using a global for the foldername. Is this bit of code only used for one folder name? What if you wanted to pass in a dynamic folder name? say through a record set (different folder name for each record). This is my problem, I can select a set of records, but dont know how to loop through them using the dynamic variable from each record. (and i'm using the dts designer, so im not sure its possible)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply