| Dutchieboy 2005-07-30, 11:23 am |
| Hi Narayana , thanks for answering my post.
I did use a log file which gets the following:
Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 21S01)
Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Insert
Error: Column name or number of supplied values does not match table
definition.
Step Error code: 800400D5
Step Error Help File:SQLDMO80.hlp
Step Error Help Context ID:1131
So, that does not tell me where it is failing.
As for a mismatch between prod and dev, when I run the database import
wizard, I specify to drop the destination tables first - so how can there be
a mismatch?
As to running interactively, if you don't mean using the database wizard, I
don't know how to do that.
--
Jan
"Narayana Vyas Kondreddi" wrote:
> This error has nothing to do with corruption, but just indicating that the
> table structures are different between your prod and dev SQL Servers.
>
> Can you run the DTS package interactively and see on which table you are
> failing?
>
> Or can you add a log file for the package and capture the output?
>
> You could also use Profiler to see where your package is failing.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
>
> "Dutchieboy" <jang- donotspammme@interte
cservices.com> wrote in message
> news:B4B2EB55-091D-4088-A5C9- C6EE908BAE6E@microso
ft.com...
>
>
>
|