I think that there is another option: store your incrementing values in a database table. Your package just needs to read/increment as necessary - then you get the data persistence...

delete a

from TableA a join TableB b

on a.ID = b.ID

deletes rows from table A which have matching records (by ID) in table B.

Are the tabs in the source SQL data, or are they being added on the way to the output file?

DoubleEx (9/21/2010)

---

Thanks all - good ideas. I started with scripting and using a global var that is looked at by the Contstraints for >0 or ==0. The...

Time to learn, or pay someone to do it for you.

😀

Note to OP:

Try Googling the...

I would use a variable that is assigned from the result of an EXECUTE SQL task along the lines of:

select count(*) from ImportTable

and then use precedence constraints (= 0 or...

Yes, if you are happy installing Excel on your SSIS server, you can instantiate an Excel application object in a Script task and do what you like ...

steveb. (9/21/2010)

---

With 2005 SSIS i am not sure, you can with 2008, you would just include them like you normally would. Use a Script task and...

😀 Just two seconds after submitting my initial response,...

--comment deleted--

Is that your expression?

That was Sheckster.

erngreen (9/13/2010)

---

This is a pure text file. I know that the tilda can be defined in the flat file connection. I have gone around and around on this issue for...

You never responded to my 'what if?' question regarding what would happen if a record had a city but not an age. Assuming that the answer is that there would...