Showing posts with label microsoftodbc. Show all posts
Showing posts with label microsoftodbc. Show all posts

Wednesday, March 21, 2012

DTS Copy SQL Server

hello all
i have problem with dts copy sql server
error : [Microsoft][ODBC SQL Server Driver][SQL Server]Windows NT user or group 'TCW\Administrator' not found. Check the name again.
thx b 4I think you need to be a wee bit more specific...

But here goes...

sounds like you're trying to copy data to another server from your server, and the other server is set up as windows only security...AND your system account is not on the domain...

sound close?

DTS copy all objects failed with invalid column name

I am trying to use the Import Data wizard to copy one database into
another on the same server and keep getting this error.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'ColumnName'
There are 6 columns in the list and all of them either don't exist
anymore or have been moved to another table in the database. I don't
understand why it keeps trying to copy columns that either aren't
there or have been moved. It looks like the database has become
corrupted. Does anyone know how I might fix this?
Regards,
Aaron
I have also tried dropping all the tables, recreating them and
re-inserting the data and I still get these errors when trying to copy
the database.
|||I have also tried dropping all the tables, recreating them and
re-inserting the data and I still get these errors when trying to copy
the database.
Regards,
Aaron

DTS copy all objects failed with invalid column name

I am trying to use the Import Data wizard to copy one database into
another on the same server and keep getting this error.
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid column name
'ColumnName'
There are 6 columns in the list and all of them either don't exist
anymore or have been moved to another table in the database. I don't
understand why it keeps trying to copy columns that either aren't
there or have been moved. It looks like the database has become
corrupted. Does anyone know how I might fix this?
Regards,
AaronI have also tried dropping all the tables, recreating them and
re-inserting the data and I still get these errors when trying to copy
the database.|||I have also tried dropping all the tables, recreating them and
re-inserting the data and I still get these errors when trying to copy
the database.
Regards,
Aaron