In the Transformations tab of the datapump task, select the source and destination for the date column only. Then create a DateTime transform. This will allow you to specify the...

Let's just say that management came around to my way of thinking after losing a days work

Ok, so do you know about exception handling in .Net? Do you know how to get the text of the error message?

Just to hijack the thread a bit further

One thing I...

Hey Frank, do you have a function key setup for that reply yet? It's amazing how many times it gets posted and still no-one searches before posting.

I'm with you here. Isn't this one of the reasons why the idea of a staging environment was conceived?

BCP into staging tables that are sans indexes. Then insert/update/delete production tables...

From the Bible for all would be SQL Server DBA/Developer's aka Books Online,

CPU busy

Well that would explain it. I can't see any AddNew method in the code you've posted.

Maybe you need to give a bit...

At what point do you get the error?

Please do not cross post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=186423

Also, this has nothing to do with Notification Services so it shouldn't be posted here anyway

You'll need to specify the OUTPUT keyword on the EXEC PROC command. eg: EXEC PROC ?, ? OUTPUT

Also, have you specified the parameter as an output parameter in your stored...

Use a function the returns a table to split the values and use the variable in the from clause.

There are a couple of example scripts in the script library. If...

Personally, stay away from backup agents, once bitten twice shy.

Sorry I misread your original post.

Differential won't allow a point in time restore, but you perform differential backup sin conjunction with transaction log backups...

This the "soon to be" production box. No changes that I know of where made on the box. The network guys are starting to act a bit cagy though. The...