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...

sabarichandru (9/13/2010)

---

Hi,

Did u found any solution for the requirement .me also facing the same probs i found the solution also to resolve using Derived Column.

but another problem is that suppose...

sql.abhishek (9/7/2010)

---

Hi

Yes go to OLEDB Destination tab and put Data access mode = Table or view – fast load then u will have ur options like Rows per batch...

I'd do it using a script task - no outside EXE needed. How big is the file likely to be, roughly? There is, of course, a performance overhead doing it...