Author |
Topic |
dmaxj
Posting Yak Master
174 Posts |
Posted - 2008-09-23 : 16:34:03
|
I created a system data source to retrieve data from a Filemaker database. The data source shows up and works great when I use Microsoft Query. I am trying to use the same data source from the Import/Export Wizard in SSMS 2005, but the data source name does not show up in the SQL Server Import and Export Wizard dialog box. Any clues?Regards |
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2008-09-23 : 16:47:26
|
Sorry, I meant to say that I created a FILE data source - not a system data source... |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-09-23 : 16:56:01
|
Try creating System datasources and Can you tell us what are you trying to do? |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2008-09-23 : 17:11:44
|
I am trying to import records from a Filemaker database into a SQL Server database using the same file DSN that works for Microsoft Query. MS Query allows me to import the data into an excel spreadsheet, but I want to send the data directly to a SQL Server database... Regards |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2008-09-29 : 16:00:25
|
So, it looks as if records cannot be imported from an ODBC source into a SQL Server 2005 using SSMS.I am curious as to why my data source works for Microsoft Query and not SMSS...Regards |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2008-10-01 : 12:35:25
|
For what it's worth, I found that SQL Server Business Intelligence Development Studio handles this task.Quite a nice tool for handling multiple heterogeneous data sources.Regards |
|
|
aaronm
Starting Member
1 Post |
Posted - 2008-12-03 : 14:32:46
|
How exactly did you use SQL Server Business Intelligence Development Studio to do this? I'm a newbie to sql and am trying to import from a progress database 10.1B and I have the ODBC driver. In my odbc settings I have setup a system,user and file dsn for it I can use all of these to import with no problems to an Access DB but can't select them from SQL 2005 import/export wizard. Any help would be appreciated. |
|
|
dmaxj
Posting Yak Master
174 Posts |
Posted - 2009-05-22 : 12:57:05
|
I made SYSTEM DSN's with the ODBC manager. I then added the SYSTEM DSN's via Server Explorer in Visual Studio (right click to Add a Connection). Next, right click on the new connection to perform NEW Query or you can just SHOW Table Data. |
|
|
fsiver
Starting Member
1 Post |
Posted - 2011-01-02 : 16:15:45
|
Thank you very much. I just needed to know how to do this and Google popped this up. |
|
|
|