What can I do for nulls? The database file allows NULLS for the datetime but in the flat file source, nulls are represented as 00 in year, month, and...

Thanks much for the replies! This worked perfectly.

Something new to add to my collection of useful SQL.

Thanks Lutz, I tried to do this using my three field names but it did not go through.

TITLE: Microsoft Visual Studio

------------------------------

Error at Data Flow Task [Derived Column [46]]: Attempt to...

This is great information. Thanks everyone.

It may have just been changed to 44GB. We were having issues earier so I'll check with the other DBA to see if he just reduced it to 44GB in...

Thanks for responding. Yes, it is 2008 Enterprise x64.

I've checked server properties and see that the maximum server memory is 44032.

I think that another admin rebooted the server or...

I made a SSIS package that runs as a job. It puts the result of a view into an Excel file and then emails it to a list of people...

Thanks John, I actually want => 1am last night until <1am this morning to be run every day. I think that is what your code is doing.

Thanks a lot...

This is perfect. Thank you both so much.

I wish that there was some better logging going on. I've been looking at the history of this job which has failed every day for the last two weeks....

Thanks, this is great documentation.

Can this be modified to find backup drives that are not large enough to hold a full database backup? That way they can be cleaned up...

Thank you Steve! This policy is now in place and working properly. I am really impressed with this documentation that matched so closely with what I was attempting to...