SQL Server OleDB Provider alternative

[nagpurboy]

Hi,

I'm using DTS packages and would like to change the server name externally. I tried doing the DSN way, however it's too slow as compared to OleDB.

Appreciate if anyone could help me by suggesting an alternative to SQL Server oleDB.

Thanks

[debasisdas]

OLEDB always works faster than DSN.