excel den sql 2005

   arkadaslar öncelikle imdat ile baslayim 1 haftadir bu isle ugrasiyorum ve hala olmadi nedir olmayan

benim istedigim tblstsabit de bulunan alis_fiyat1 de bulunan degerleri benim istediklerimle degistirmek 

bunu task impor seçenegi ile her sekilde denedim her seferinde primary key ile ilgili bir hata veriyor ve hiç bir sey olmauyor

benim bu islemi yapamma için data base i durdurmamami lazim yoksa primary key mi kaldirayim yoksa tbl stsabit export edip sonra sql de kaldirip yuenidenmi yükley,m bilemdim

simdi hatay gelince 

< ="Content-" content="text/; charset=utf-8">< name="ProgId" content="Word.">< name="Generator" content="Microsoft Word 11">< name="Originator" content="Microsoft Word 11"><>

Operation
stopped...

-
Initializing Data Flow Task (Success)

-
Initializing Connections (Success)

-
Setting SQL Command (Success)

-
Setting Source Connection (Success)

-
Setting Destination Connection (Success)

-
Validating (Success)

-
Prepare for Execute (Success)

-
Pre-execute (Success)

-
Executing (Success)

-
Copying to [EKIM2008].[dbo].[TBLSTSABIT] (Error)

Messages

· Information
0x402090df: Data Flow Task: The final commit for the data insertion has
started.

 (SQL Server Import and Export Wizard)

· Error 0xc0202009:
Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code:
0x80004005.

An OLE DB record is available.  Source:
"Microsoft SQL Native Client" 
Hresult: 0x80004005  Description:
"The statement has been terminated.".

An OLE DB record is available.  Source:
"Microsoft SQL Native Client" 
Hresult: 0x80004005  Description:
"Violation of PRIMARY KEY constraint 'TBLSTSABIT_PKEY'. Cannot insert
duplicate key in object 'dbo.TBLSTSABIT'.".

 (SQL Server Import and Export Wizard)

· Information
0x402090e0: Data Flow Task: The final commit for the data insertion has ended.

 (SQL Server Import and Export Wizard)

· Error 0xc0047022:
Data Flow Task: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component
"Destination - TBLSTSABIT" (395) failed with error code 0xC0202009.
The identified component returned an error from the ProcessInput method. The
error is specific to the component, but the error is fatal and will cause the
Data Flow task to stop running.  There
may be error messages posted before this with more information about the
failure.

 (SQL Server Import and Export Wizard)

· Error 0xc0047021:
Data Flow Task: SSIS Error Code DTS_E_THREADFAILED.  Thread "WorkThread0" has exited
with error code 0xC0202009.  There may be
error messages posted before this with more information on why the thread has
exited.

 (SQL Server Import and Export Wizard)

-
Post-execute (Success)

-
Cleanup (Success)

Messages

· Information
0x4004300b: Data Flow Task: "component "Destination -
TBLSTSABIT" (395)" wrote 4732 rows.

 (SQL Server Import and Export Wizard)

 arkadaslar ciddi anlamda zor durumdayim 3000 satir tek tek alis fiyati girilecek degilse 

simdiden tsk ler