Louis-644449,

First of all, I should have made more clear that an AFTER trigger is always an option.

I agree that triggers allow for more friendly error messages.

I think the technique...

Thank you so much for your detailed comments. They have been most helpful. I hadn't thought of dividing the task up into file watching and file processing, but that might...

Thanks for referencing the discussion on the WMI article. It was most helpful. Your description of the standard batch processing and ETL design matches my experience.

What sort of load have...

You make very good points regarding Microsoft testing and the WMI Event Watcher Task. I guess my qualm is that it seems to be an afterthough by Microsoft. All the...

Thanks for the article. I've been intrigued by this component, but have shied away from it because I have qualms about the architecture. I worry about having an SSIS job...

To demonstrate what Lynn posted, the following code shows the month, day and year parts of the dates you provided:

Declare @ConversionTestTable

(SomeDateTime2_0DateTime2(0) Not Null,

SomeDateTimeDateTimeNull

);

Insert Into @ConversionTest

(SomeDateTime2_0)

Values ...

The following code converts datetime2(0) to datetime:

Declare@SomeDateTime2_0datetime2(0)

Declare@SomeDateTimedatetime

Set@SomeDateTime2_0='2012-01-01 00:00:00'

Set@SomeDateTime=Convert(date, @SomeDateTime2_0)

Select@SomeDateTime2_0As[@SomeDateTime2_0],

@SomeDateTimeAs[@SomeDateTime]

The result is the following resultset:

@SomeDateTime2_0@SomeDateTime

2012-01-01 00:00:002012-01-01 00:00:00.000