I have created a sample query that includes an XML document.  Note that for all of the new records you must specify all values for Not Null columns.

Russ

CREATE TABLE [OrderDetails]...

For SHDate:

Convert (varchar(10), sh_date,101) as shdate

Russel Loski

Russel Loski

I suspect that the user account that SQLAgent is running under does not have permission to access the files.

Alternatively, does the filesystemobject access a network drive? You can't use...

I did a simple test: run query

select convert (datetime, '')

The results were 1900-01-01 00:00:00.000

I think that it is casting '' to datetime and converting it to 1900-01-01.

The easiest fix...

Can mixed collations affect performance?

I created a new server and database with a different default collation when I took over our small SQL Server environment. In transferring the objects...

In the article you state that you cannot view in the GUI a DTS package that was saved to VB. What I do is to comment out the Execute...