July 3, 2008 at 8:48 am
I'm a data analyst and know just enough about this to be dangerous. Using the Import/Export Wizard in SQL Server 2005 Business Intelligence: I wanted to export data using a proven SQL query from a network SQL 2005 server and import it into an SQL 2005database on my laptop. It runs fine without any errors, creates the table with the appropriate columns but there is no data in the table. I also tried appending data with a table already on the database with the same result.
July 3, 2008 at 9:51 am
All I can think of is the query isn't selecting any rows. Do you see data when you click the "Preview" button on the wizard screen called "Select Source Tables and Views"?
Greg
July 3, 2008 at 9:59 am
It's a normal SELECT query that I've used over and over again in the old environment (SQL Server 2000) and it works as designed. I'm thinking there are some settings that I don't know about since my company has just upgraded to 2005 and, as always, leave us to our own devices to figure out how to make it work. I never expected to have to do DBA stuff, but I guess I'd better get used to it.;)
Oddly, when I used the wizard to pull an Excel file into my local SQL Server 2005 database, that worked. I got a little cocky and thought, Hey, I can pull data from the production db and work locally. I'm going to quit thinking. It only muddles the water.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply