MS SQL Server ODBC - Insert Problem.

Author

Insert Problem.

Simon

2005-08-08, 7:23 am

I am using a DTS package to insert data into a SQL table. This has worked
correctly for the last 2 years. However when I run the code now I get a
Timeout error. I have rebooted the server with no success. If I try and run
the data into a temporary table it works fine.

Is the table corrupt ? If so how can I uncorrupt it ?

Si

Dandy Weyn [Dandyman]

2005-08-09, 3:23 am

Can you provide a little more information on where the table is stored, how
the dts package looks like?
What's the source? What's the destination?

--
Dandy Weyn
[MCSE-MCSA-MCDBA-MCDST-MCT]
http://www.dandyman.net

Check my SQL Server Resource Pages at http://www.dandyman.net/sql
"Simon" <Simon@discussions.microsoft.com> wrote in message
news:CA096C29-74E5-48F2-923A- A00D2321BDF4@microso
ft.com...
>I am using a DTS package to insert data into a SQL table. This has worked
> correctly for the last 2 years. However when I run the code now I get a
> Timeout error. I have rebooted the server with no success. If I try and
> run
> the data into a temporary table it works fine.
>
> Is the table corrupt ? If so how can I uncorrupt it ?
>
> Si

Sponsored Links