By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,455 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

Exporting data from SSPS 15.0 to SQL Server 2000

P: 3
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?
May 30 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
Where did you select the database? On your app or on the ODBC definition?

-- CK
Jun 2 '08 #2

P: 3
Thanks for your response!

I select the database at ODBC definition, however the data goes to another database when exported.
Jun 3 '08 #3

ck9663
Expert 2.5K+
P: 2,878
Do you reuse your ODBC connection?

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

-- CK
Jun 3 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.