Page 1 of 1

ODBC Vs SQL Server Enterprise

Posted: Tue May 17, 2011 1:44 pm
by srireddypunuru
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

Posted: Wed May 18, 2011 12:12 pm
by srireddypunuru
Any thouths on this Which Stage is really the best to Use in long run ODBC or SQL SERVER Enterprise

Posted: Wed May 18, 2011 1:19 pm
by PaulVL
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.