Find out the server name by logging into MAnagement studio on the box itself using SELECT@@servername.

Put that in and see if it connects..

Thanks Steve, that seems to be the only option, i have to validate al of what i am doing against "real" data before i can move it into dev or...

What if you add a condition -where t.yearsld2<>0 (or whatever) the denominator is. That way you can work aorund having to divide by zero.

What about the datatypes? is it rounding...

For some reason i did not get your PM, i have sent PM'ed you my email address. I'd appreciate it if you could message me again on that.

Regards,

JD

I would really aprreciate it if someone let me know if they have anything, or if they could point me to a resource.

I'm sure you'd agree the best way to...

Hi,

Could you send me your contact info/email address? I would like to discuss this a bit more..

JD

Ok, firstly the example was for demonstration purposes only, i wouldnt insert data into a table like that.

Take the following schema

CREATE TABLE [dbo].[CustomerData](

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

[customerID] [int] NOT NULL,

[fieldID]...

Chad,

Do you mean i should select into a temporary table and then update table A with rows from the temp table?

I would like to directly update . Let me know..

Yes i use the fast load option when finally inserting into an OLE DB destination, what is the difference between the various options?

Thanks, however, now that i built it, i am looking work/experiment with it for a few days.

I am now facing the following situation-(am not sure if i should create...

Let me see if i have understood correctly, basically you're having a problem when you do a Fuzzy Lookup on a larger dataset.

So, one option would be to make...

I found the problem, apparently you cannot do a lookup if the two fields have a varchar(max), i had to convert the type.

Does everything in the caching T-sql statement look fine(advanced tab)

select * from

(SELECT firstName

FROM Customers_Dimension) as refTable

where [refTable].[firstName] =...

Could you give a little more detail as to the issue you are facing i.e. how many tables, how much data etc...what ssis package are you using..?

Well, i did not assume the title of "architect" thats what the company advertised for and they were/are well aware of my skillset. I did not add anything that...