Bulk Insert with getdate() ?

Hi,
I have a file that I want to use to bulk insert into a table.
this does not work:
text|text|text|'select getdate()'|text
Is there a way I can put the getdate in there as well?
thanksDon't include the field in the bcp and put a defaulkt on
it.
Bcp into a view which excludes the field if necessary.
>--Original Message--
>Hi,
>I have a file that I want to use to bulk insert into a
table.
>this does not work:
>text|text|text|'select getdate()'|text
>Is there a way I can put the getdate in there as well?
>thanks
>.
>|||"hmc" <nospam@.nospam.com> wrote in message
news:53b5kv0gnpl0th1ag04befajnqhnovhumo@.4ax.com...
> Hi,
> I have a file that I want to use to bulk insert into a table.
> this does not work:
> text|text|text|'select getdate()'|text
> Is there a way I can put the getdate in there as well?
Do it by script as a second step.
Chain the second step to the bulk insert.