|John |,|Doe |,| ...

THanks I will give this a try...

Thanks Tim,

Judging by the number of responses I am getting it doesn't seem like there is an easy way to do this. Yes the vendor we are picking the...

Great help -- thanks

So let me get a little more specific here is my code:

update A

set A.f1= B.f1

from db1..table1 A

join db2..table2 B

on A.My_field= B.My_field

The offending field is B.My_field which appears to be causing...

Thanks Andy I was beginning to feel as if I were alone on this one. Your explanation is simular to my situation because my parent package is calling the...

I am relatively new to this as well and I have found this process works well. As far as standardization not sure what the considered standard is for this...

Use an Execute SQL Task and write a sql statement simular to this:

select 1 as result

Then in the result set tab (you will find this on left side of editor...

It looks as if there is a shift in some of the end columns -- I have decided to ask the client to re-export and send to me.

Appreciate the suggestions.

My apologies -- I have resolved this issue you were correct it didn't have anything to do with the 3 million value but to be honest I forget what I...

No I think you read it right my source data had a column defined as a Varchar(50) and the destination expected string of column length 3. The automation would...

Hey Jack thanks for your response yes I had the data access mode set to Table or view. Steve's answer was able to resolve my issue.

Cheers,

Thanks Steveb that did the trick

Appreciate the help thanks -- I tried what you suggested and found the issue was a value in the field of 3,000,000. I changed the casting to make the...

Thanks your correct I was able to resolve this issue by creating a new table and updating with the one I am inserting records to and ordering it appropriately.

Appreciate the...