Exporting data from SSPS 15.0 to SQL Server 2000

[nbxix]

Each time I export data from SSPS (v.15.0) to SQL Server 2000 on a secure ODBC it goes to one of my open databases despite selecting where I want it to go. This means I always have to re-export my newly created tables at database level to a destination of my choice... I find it time-wasting!

Any help anyone?

[ck9663]

Where did you select the database? On your app or on the ODBC definition?

-- CK

[nbxix]

Thanks for your response!

I select the database at ODBC definition, however the data goes to another database when exported.

[ck9663]

Do you reuse your ODBC connection?

Try specifying it on your apps and not rely on ODBD definition.

-- CK