Attached is a sample of what I'm trying to do.

Really? According to BOL, the offending rows fail. Am I missing something? From BOL:

"IGNORE_DUP_KEY = { ON | OFF }

Specifies the error response to duplicate key values in...

IGNORE_DUP_KEY seems like just the ticket! Preventing the problem in the first place would be best, but I don't have complete control over that part. Occasional dups are slipping through...

Thanks Jeffery. I was just using Employees as an example to make things easier. Actually what I'm really sending is all the Guest Reservations that have stayed at a hotel...

Thanks Phil, this is really not about employees at all. I just thought that might make my example a little easier to explain. This is really about exporting data to...

Answered my own question. Never mind. If anyone else is interested. Here's what I needed to get the file name from my flat file destination:

string FileNameStr = Dts.Connections["MyConnectionName"].ConnectionString;

I guess stripping the time is the best bet. I'll stick with that. If I strip the time off the parms first rather than the doing it in the WHERE,...

Yea, gotcha on the range check. The problem is every time I do something like that, the optimizer stops using my index on that column which brings things to a...

Sorry, I'm back to this again!

Lets say I have a table with "ArrivalDateTime" column.

And I have a stored procedure that will fetch these. Something like this:

create procedure FindArrivals

...

Awesome, thank you Jeffery. That's pretty much where I was going. I'd hoped someone had a better answer. 🙂

Is the "Available Free Space" figure on the "Shrink Files" dialog...

Thanks John.

My logic here is that I have a 100GB DB that probably only needs to be 20GB at the most. That's quite a waste of resources. I hate...

Jeffrey, that's exactly what I understood you to say. Seems like a pretty clever idea. Probably not a good solution for EVERY date column in EVERY table. But it could...

When building indexes for dates, when I know I don't need the time portion, would it help to neutralize the time portion when building the index?

CREATE INDEX MyIndex ON ThisTable(

...

I've read that Access & Excel OLE DB drivers will not work on 64 bit version of SQL Server. Could that be it? Hope this helps.

Thanks for the responses!

Like I said, I have no problem inspecting variables at runtime. I get it. What I'm looking for is a way to inspect package properties at runtime.

Again,...