No, text. Sorry. Just computer puke. The only thing I can think of is I think I remember setting the package to always use the default code page because I...

Ordinarily, that's what I'd do, but it bombs on 400k records after stating it could not add a row to the buffer (using VS 2012 and SQL 2008 R2). I've...

Well, I tried setting it up for a test. The field is limited to 18 characters, but I can't even set it to 50 or 25...basically, can't go one character...

Geez...I'm sorry. I meant SSMS (SQL Management Studio 2012).

In seeing this post - it also brings a question to mind. If I'm understanding the table structure and the following post - it appears as though they have...

I did some more trolling around ('cuz I like to squeeze every last bit of speed from my queries that I know how to) and came across this post:

http://www.sqlservercentral.com/Forums/Topic446175-360-1.aspx

If my...

The query didn't change much. I took the advice of GilaMonster and changed the date filter parameter to keep the original datatype of the field and expanded the date parameters...

This is probably a crap answer - but it was just a matter of getting the indexes and PKs and fill factors correct. My index seeks are still kinda'...

I apologize for the inability to show the execution plan. I will try your suggestions and let you know if and how I was able to fix it.

I can't post the execution plan because it may have proprietary information in it. I'm casting and converting a datetime value (2010-08-25 12:34:56.789) to be used against a smalldatetime value...

Here's the query:

select d.column1, c.column1, b.column1

from table1 a

inner join table2 b on a.id1 = b.id1

inner join table3 c on b.id2 = c.id1

inner join table4 d on a.id2 = d.id1

inner join...

I may've figured it out though I'm not sure how I got the PK on the data in the first place. The source file data has blank data in...

Got it to work - sort of. I had to take the PK off to get it to work. I saw the debug progress as it went through...

Sorry - but again, new to SSIS packages. I did the 'Lookup' wizard before the destination step and the lookup step fails w/the error "Row yielded no match during...

Yeah - it's deceptively straightforward. I'd NEVER done anything with SMTP and DB Mail (other than send test messages from an already built server) but I found myself having...