perhaps a security issue?

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/9702e90c-fada-4978-a473-1b1423017d80.htm

bc

If I follow you, you should see them in the Object Explorer of SSMS, when logged into the server's Integration Services instance, under Stored Packages, then MSDB.

bc

i'm sorry, i can't see anything that would allow dupes into the query and cause the PK violation. bc

I don't think so. Can you post the full code?

bc

Whenever I've run into this error, its always been something I missed that there were records already in the table.

Are you sure there is not a hard table by the...

Do you see dupes when you run just the Select DISTINCT?

select DISTINCT

a.org_id,

a.absr_id,

a.abs_id,

a.abs_date...

When I try to run just your declare:

(Declare @AbsTab table (org_id int, absr_id int, abs_id int, abs_date datetime primary key (absr_id, abs_id,abstab_id)))

I get:

Msg 1911, Level 16, State 1, Line 1

Column...

usually you would have a solution (.sln) file in a parent folder of the the 5 .dtsx files. open the solution in visual studio (BIDS) and make your changes,...

you can use an "Execute SQL Task" in the Control Flow to do sql statements or stored procs. not sure if that fits your scenario. bc

I like the Data Probe idea. That will come in handy for sure.

Thanks,

Burke

Thanks for that good explanation. The way ssis handles data types is one of the most confusing things to work with, the error messages are often misleading or easy...

i had a hard time coming up with false answers that would throw the reader off. i thought some might misread 50000 for 500000, and thus 150000 (50000+50000+50000). ...

I disagree with your comparison of Texas and Texas A&M. Its actually the opposite, A&M has spent almost as much in many areas of athletics, primarily facilities and coach's...

there is a free component that does this for you:

http://www.thejoyofcode.com/SSIS_Compress_File_Task.aspx

also, you can use an Execute Process Task and call winzip.exe:

http://dichotic.wordpress.com/2007/07/24/using-winzip-within-ssis/

it's because the varchar(5) is not big enough to hold mine which is 6 characters. try setting yours to varchar(3) and you should get the same error.

bc