changed it to datetime and got:

Conversion failed when converting datetime from character string

cast(left('pehPErcontrol',8) as datetime),

thanks Phil

I get a:

Type date is not a defined system type error

Here's the code:

cast(left('pehPErcontrol',8) as date),

Awesome thanks guys! Much appreciated.

Perfect!

Thanks Lowell. You are the man.

found a way...thanks anyway guys..

IF (select count(*) from [e009]) > 0

begin

exec msdb.dbo.sp_send_dbmail

@profile_name = 'Default',

@recipients = 'me@example.com',

@subject = 'warning',

@query = 'select * from [e009]',

@attach_query_result_as_file = 1,

@query_attachment_filename = 'warning.csv'

end

lol...never is that easy..

thanks man, that's just what I was looking for..

Guessing it kick out my users if they are in the middle of running a report?

If so, that would be bad.

Do I have any other options for my senario?

The value of EC.EECPAYPERIOD is 'B'

which...

Thanks everyone.

It's a one time pull/sync.

I'm looking into redgates data compare.

Will update.

Thanks again guys for all the help and insight.

Cool thanks GSQUARED.

thanks guys!

Thanks Phil..

This is what I have so far...

Is this going to copy only the changed (updated/inserted) record?

Cool...thanks Roland.

Okay thanks.

UNC path worked...thanks!

The directory is there all the time.

I'll try the UNC path.

Kinda wierd tho, cause it does work fine when the end user drops a file in..