Copy table from ODBC to SQL database

Hi all,

I'm trying to copy a table from an odbc db to an sqlserver2005 db. SSIS will not do this for me and says I must write a script. I'm not experienced enough in sqlserver to do this and was unable to find a example of this by searching the web. Does anyone know of any websites with an explanation of how to do this?

thanks for any help.

You can use Import/Export Wizard to copy your data to SQL Server db.

http://www.databasejournal.com/features/mssql/article.php/3580216
http://msdn2.microsoft.com/en-us/library/ms141209.aspx|||

That does not really help as the question was not abou how to start the process but how to get part this point, I am having the same problem and am not very good with SQL queries.

Thanks

|||

Have you seen the following thread?

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=379235&SiteID=1

There is a lot more messages on the topic in this forum; try to search for them.

Thanks.