Thanks guys. I sat down, and went throught it logically and was able to build the two loops that i needed to complete this. There was some logic...

Thanks....bad day here at the office!!

I have a target RowID held in a variable, I need to return the four rows that are + or - 2 of that target RowID. I know its...

Hey all,

Thanks again for the help. I re-wrote it using two cursors which served my purpose nicely.

Steve

Hey Jason and sushila,

Here is the code. I hate crusors as much as the next, but this table is gonna max out at about 1000 rows, so not too...

Thanks Vladan,

That article is exactly what I was looking for. I guess my Googling wasnt up to par this early

Thanks again.

Hey Mobashir,

I ran into the similar issues and found that you need to use a script task. Unfortunately, I havent found a way to create a new Excel file...

Thanks all for the help.....I am close to replicating what I can do in DTS....but right now I've just come up with a pseudo cheater way to do it. ...

Hey Bill,

This works awesome. Another question now. How do I in SSIS then be able to export to that "dynamic" named file. In DTS I would just...

Thanks guys for the help.

The article posted there does create and move the file, but doesnt help me to uniquely name it. I'm gonna have to create a further...

You can always use the File.Exists function in an ActiveX Script tast using the Java Language. I would check on MSDN online for sample code to help you do...

Thanks all for helping out here. I'm going to give them all a try today and see which one will yeild the best results re manual work for the...