Hi
I have a dts package in sql server 2000 that gets data from a Sybase 9.0 database.
I am trying to create a new DTS package to setup as a job in SQL server 2008 using the dsn connection file but I cannot get past selecting the dsn file part?
Sorry for the vagueness of this question but I basically want to get connected to a Sybase 9.0 database and setup a job to import data on a regular basis.
Does anyone have any hints/tips/experience/links/help at doing this?
Thanks