Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
abhijit.pandua
Starting Member
3 Posts |
 Posted - 2011-09-15 : 05:52:54
|
Hello All,I am Using Import/Export tools in SQLServer2008 to import data directly from PostgreSQL8.3 using PostgreSQL OLEDB provider results the following error message: “Cannot get string literals from the database connection "Provider=PostgreSQL OLE DB Provider;User ID=sde;Data Source=172.16.5.244;Location=sde;Extended Properties=". (SQL Server Import and Export Wizard)Object reference not set to an instance of an object. (DTSWizard)”I have seen the below weblink but no use:http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/4498d4f2-9646-4921-b56d-79e22c14a215/Any suggestion would be appreciated.Thanks in advance. Panduz... |
|
|
abhijit.pandua
Starting Member
3 Posts |
Posted - 2011-09-17 : 15:14:10
|
| Any updates????Panduz... |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-09-17 : 15:23:47
|
| Did you try any of the other drivers suggested?If nothing in that thread helps, you can still use Copy To to a CSV, then import the CSV. |
|
|
|
|
|
|
mport data from postgreSQL into SQL server 2008