SQListic
SSCertifiable
Points: 6904
More actions
June 27, 2012 at 3:42 pm
#258205
Using SSIS i want to load data from informix to sql 2008
what data source shoould i use?
informix server is 32 bit
sql server is 64 bit
Informix csdk 64 bit and 32 bit installed on sql server
Please suggest me
TangoVictor
SSChampion
Points: 10976
June 27, 2012 at 5:14 pm
#1506418
it looks like informix has an ado.net provider, you should create a new connection and look for that provider in the dropdown list. Or create a DSN and use the ODBC or .net odbc provider.
look here too
http://social.msdn.microsoft.com/Search/en-US/sqlserver?query=imformix%20to%20sql&rq=meta:Search.MSForums.ForumID(00e50af7-5f43-43ad-af05-d98b73c1f760)+site:microsoft.com&rn=SQL+Server+Integration+Services+Forum
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply