Yes, I tried creating a simple ssis package and recieved the same error.

Then the following query doesn't have a join condition?

select distinct substring(nu.LocCode, 4, 1), c.Phone, c.GroupName, nu.Office, nu.*

...

A little more info to add. I'm not seeing any errors in the SQL Server Logs nor the event logs. Could this be a network issue?

Yeah, I've already found everything with emaill addresses by looking for the email extension we use in SQL Search from redgate. I was just hoping that maybe SQL Server might...

Never mind, I added ERRORFILE ='f:\Inbound\MEDA4C745\Unzip\Error', MAXERRORS = 100 to the tsql command and fixed it that way

After some thought on Buffer Tuning I think I've come up with a good way to configure DefaulMaxBufferRows and DefaultMaxBufferSize. The thing that irritates me is I haven't found a...

I think I was correct. I have found in the following article statement showing the messages when the buffer overflows the DefaultMaxBufferSize as well as when the buffer is beneath...

I have noticed one thing. I switched to another dataflow and the buffertuning messages stating overflow appeared. I tuned the DefaultMaxBufferRows and Maxed the DefaultMaxBufferSize and they did not appear....

ok, I found it.

1. Add a dataflow to your package

2. click on SSIS Menu and select "Logging..."

3. After the dialog box opens make sure the checkbox next to the dataflow...

Also, I have 2 sessions which are showing for my database in Activity Monitor. I don't know of anything that should be currently running on this database. Is there a...

I am now looking into adding indexes for several other queries. Should I follow what you did in the index you posted earlier? Just add the keys used in the...

AWESOME! After adding the index the join on the server only took 17 minutes! I will defintely be looking into possible indexes to add.

oops, my error

USE [GECBI]

GO

/****** Object: Table [dbo].[fact_transac] Script Date: 03/01/2011 16:30:08 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[fact_transac](

[TrnPk] [int] IDENTITY(1,1) NOT NULL,

[TrnFKInvPk] [int] NOT NULL,

[TrnGroupId] [int]...

USE [GECBI]

GO

/****** Object: Table [dbo].[fact_tes_transac] Script Date: 03/01/2011 16:20:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[fact_tes_transac](

[FttPk] [int] IDENTITY(1,1) NOT NULL,

[FttMRN] [varchar](20) NULL,

[FttPatientName] [varchar](60) NULL,

[FttEncounterNumber]...

Execution plan attached