thkz matt got some idea it was helpful thkz

hi berto ...did u solved the issue if so plz tell me whats was the issue n how did u overcome that thkz bye

then u need to double check with your oledb source check the source file n see the preview if evrything wrks good then try running it ....there is some problem...

So when u jus upgraded from sql 2000 to sql 2005 u can see th dts packages in maintainence n legacy in which u can see dts packages n u...

HI sandeep ...

if all of ur data in the excel file are in one format nd same data sets n has column delimiters then you can do...

hi todd

do i need to add the variables in parameter mapping or not .....plz let me know n what is second operand ..........//table1 what is that do i need to...

hey i tried this but i got some errors let me tell u the way i created this ...

Error: Failed to lock variable "user::varresults" for read/write access with error 0xC0010001...

When two distinct values gives the same checksum value then how can we index on that column ....it says that u can use checksum as an additonal column so that...

YA GOT IT BUT WHEN U SAY THAT THE OP SHOULD BE CHANGED IT MEANS THE TOTAL NO OF ROWS IN THE TABLE SHOULD BE UPDATED TO O FROM NULL...

GOT IT THKZ BRO...BUT I CANT CHANGE THE IDENTITY VALUE RIGHT IT MAKES A WHOLE MESS IN THE COLUMN ...ANYWYA I JUS NEED THIS THKZ BRO....

U CAN UPDATE THAT WAY ONLY WHEN THERE ARE NO MORE ROWS TO BE INSERTED IF NOT EVERYTIME U INSERT SOME ROWS U NEED TO UPDATE THE COLUMN .....SO...

I GOT SOME INFO FROM THAT BUT WHAT I WANT IS WHEN THE ROWS 54,6,7 GETS DEKLETED I JUS WANT THE REST OF THE ROWS TO BE IN SEQUENTIAL...

I TRIED THE CODE U GAVE ME BUT STILL I GET THE SAME OUTPUT AS BEFORE WITH ID AS 1,3,5,8 ...

WHAT ADAM HAS SAID WRKS PREFECTLY..

ID INT NULL

NAME CHAR NULL

SELECT * FROM DBO.TEST

ID NAME

----------- ----------

2121 ...

SO U HAVE 15K ROWS IN WHICH A COLUMN ALLOWS NULL AND U JUS WANT TO MAKE IT AS NOT NULL WITH A DEFAULT VALUE OF 0 IS THAT THE...