quote:

---

what I am talking about is that you can CREATE the FORMAT file not the DATA file every time before you import....

I understood my choices are:

1) use DTS with parameters. which I am looking into right now.

2) use perl to format the file before importing with bcp (which seems to be...