|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Build Querys for external data sourcesHello,
I am trying to use SQL2k5 to import and analyze data from various thrid-party Visual Fox Pro database applications we have. I'm stuck having to use SQL 2000 for now because I cannot figure out how to build the query to extract the data. SQL 2000 included a graphical query builder during the import wizard that would allow me to select my table, columns and input criteria. This seems to have been removed from SQL 2K5. When I try to use the query builder it seems to only allow me to query against tables in the SQL2K5 instance. Is there any tools within SQL2k5 that will graphically allow me to build queries for external datasources? Thanks in advance. Chris wrote:
Show quote > Hello, Why do you need a graphical query builder? This isn't Access. It's > > I am trying to use SQL2k5 to import and analyze data from various > thrid-party Visual Fox Pro database applications we have. > > I'm stuck having to use SQL 2000 for now because I cannot figure out how to > build the query to extract the data. SQL 2000 included a graphical query > builder during the import wizard that would allow me to select my table, > columns and input criteria. This seems to have been removed from SQL 2K5. > When I try to use the query builder it seems to only allow me to query > against tables in the SQL2K5 instance. > > Is there any tools within SQL2k5 that will graphically allow me to build > queries for external datasources? > > Thanks in advance. ridiculously easy to write your own SELECT statements using T-SQL, using a Linked Server to connect directly to the FoxPro databases. Tracy,
Thanks for the reply. Actually I've never tried setting up a linked server to the foxpro tables. Do you have an example or a link of how to set up a linked server? Thanks Show quote "Tracy McKibben" wrote: > Chris wrote: > > Hello, > > > > I am trying to use SQL2k5 to import and analyze data from various > > thrid-party Visual Fox Pro database applications we have. > > > > I'm stuck having to use SQL 2000 for now because I cannot figure out how to > > build the query to extract the data. SQL 2000 included a graphical query > > builder during the import wizard that would allow me to select my table, > > columns and input criteria. This seems to have been removed from SQL 2K5. > > When I try to use the query builder it seems to only allow me to query > > against tables in the SQL2K5 instance. > > > > Is there any tools within SQL2k5 that will graphically allow me to build > > queries for external datasources? > > > > Thanks in advance. > > Why do you need a graphical query builder? This isn't Access. It's > ridiculously easy to write your own SELECT statements using T-SQL, using > a Linked Server to connect directly to the FoxPro databases. > > > -- > Tracy McKibben > MCDBA > http://www.realsqlguy.com > Chris wrote:
> Tracy, There has been some discussion in this group recently about linking > > Thanks for the reply. Actually I've never tried setting up a linked server > to the foxpro tables. Do you have an example or a link of how to set up a > linked server? > Foxpro databases, and there are tons of references online. I haven't used Foxpro myself in years, so I can't offer much in the way of specifics. Tracy,
Thanks for you help, I do appreciate it. I was able to create the linked server. But I am having some trouble trying to figure out what the four part name should be. I'll start a new thread for that one. Thanks again. Show quote "Tracy McKibben" wrote: > Chris wrote: > > Tracy, > > > > Thanks for the reply. Actually I've never tried setting up a linked server > > to the foxpro tables. Do you have an example or a link of how to set up a > > linked server? > > > > There has been some discussion in this group recently about linking > Foxpro databases, and there are tons of references online. I haven't > used Foxpro myself in years, so I can't offer much in the way of specifics. > > > > -- > Tracy McKibben > MCDBA > http://www.realsqlguy.com > I may have found a solution for this..........
The query builder is available for external data sources, through the Intergation Services, Execute Sql Task. A connection to the external data source must be created and specified and then the Build Query button is available. This does add a couple of steps to the process. But seems to work. Except now instead of being able to use the import wizard, I'll have to create my queries ahead of time, and then copy them into the import wizard. Show quote "Chris" wrote: > Hello, > > I am trying to use SQL2k5 to import and analyze data from various > thrid-party Visual Fox Pro database applications we have. > > I'm stuck having to use SQL 2000 for now because I cannot figure out how to > build the query to extract the data. SQL 2000 included a graphical query > builder during the import wizard that would allow me to select my table, > columns and input criteria. This seems to have been removed from SQL 2K5. > When I try to use the query builder it seems to only allow me to query > against tables in the SQL2K5 instance. > > Is there any tools within SQL2k5 that will graphically allow me to build > queries for external datasources? > > Thanks in advance.  |
|||||||||||||||||||||||
Other interesting topics