ODBC Vs SQL Server Enterprise

srireddypunuru · Post by **srireddypunuru** » Tue May 17, 2011 1:44 pm

Guru,

I have SQL Server as Source and Target using DS 8.5 on WINDOWS 2008 and using mostly ODBC Connector. I was just wondering why cant i use SQL Server Enterprise stage. Any thoughts on this is apreeciated.

Thanks
Sri

srireddypunuru · Post by **srireddypunuru** » Wed May 18, 2011 12:12 pm

Any thouths on this Which Stage is really the best to Use in long run ODBC or SQL SERVER Enterprise

PaulVL · Post by **PaulVL** » Wed May 18, 2011 1:19 pm

Vanila or French Vanila. Your choice.

The only reason I can think of for using the ODBC stage is if you ever intend to port the job to a Unix platform. SQL Server Enterprise stage is not present on the Unix flavor.