 | |
DTS Data Source
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS Data Source -
10-05-2005
, 04:45 AM
#2
| |||
| |||
|
|
Dear All, I have installed Microsoft OLE DB Provider for Visual FoxPro 9.0. When I do an Import in SQL2000, I can get the data source as Microsoft OLE DB Provider for Visual FoxPro. When I try to create a DTS package, I cannot find such option as a Data Source... If anyone knows why... please let me know how I can fix that. Thanks a lot! Charlie |
#3
| |||
| |||
|
|
Have you tried setting up a DSN and using the "Other Connection" Data Source? Allan "charlie" <charlie (AT) discussions (DOT) microsoft.com> wrote in message news:EE522A25-35A4-437F-A751-B4655509DD4A (AT) microsoft (DOT) com: Dear All, I have installed Microsoft OLE DB Provider for Visual FoxPro 9.0. When I do an Import in SQL2000, I can get the data source as Microsoft OLE DB Provider for Visual FoxPro. When I try to create a DTS package, I cannot find such option as a Data Source... If anyone knows why... please let me know how I can fix that. Thanks a lot! Charlie |
#4
| |||
| |||
|
|
yes, i did but i still could find Microsoft OLE DB Provider for Visual FoxPro 9.0 from the drop down list... "Allan Mitchell" wrote: Have you tried setting up a DSN and using the "Other Connection" Data Source? Allan "charlie" <charlie (AT) discussions (DOT) microsoft.com> wrote in message news:EE522A25-35A4-437F-A751-B4655509DD4A (AT) microsoft (DOT) com: Dear All, I have installed Microsoft OLE DB Provider for Visual FoxPro 9.0. When I do an Import in SQL2000, I can get the data source as Microsoft OLE DB Provider for Visual FoxPro. When I try to create a DTS package, I cannot find such option as a Data Source... If anyone knows why... please let me know how I can fix that. Thanks a lot! Charlie |
#5
| |||
| |||
|
|
Have you installed the driver from here http://msdn.microsoft.com/vfoxpro/downloads/updates When you drop a connection onto the designer, in the data source dropdown is it not listed there? Allan "charlie" <charlie (AT) discussions (DOT) microsoft.com> wrote in message news:E3EFE672-1CED-4585-AB16-92CE60E6C5F9 (AT) microsoft (DOT) com: yes, i did but i still could find Microsoft OLE DB Provider for Visual FoxPro 9.0 from the drop down list... "Allan Mitchell" wrote: Have you tried setting up a DSN and using the "Other Connection" Data Source? Allan "charlie" <charlie (AT) discussions (DOT) microsoft.com> wrote in message news:EE522A25-35A4-437F-A751-B4655509DD4A (AT) microsoft (DOT) com: Dear All, I have installed Microsoft OLE DB Provider for Visual FoxPro 9.0. When I do an Import in SQL2000, I can get the data source as Microsoft OLE DB Provider for Visual FoxPro. When I try to create a DTS package, I cannot find such option as a Data Source... If anyone knows why... please let me know how I can fix that. Thanks a lot! Charlie |
#6
| |||
| |||
|
|
Have you installed the driver from here http://msdn.microsoft.com/vfoxpro/downloads/updates When you drop a connection onto the designer, in the data source dropdown is it not listed there? Allan "charlie" <charlie (AT) discussions (DOT) microsoft.com> wrote in message news:E3EFE672-1CED-4585-AB16-92CE60E6C5F9 (AT) microsoft (DOT) com: yes, i did but i still could find Microsoft OLE DB Provider for Visual FoxPro 9.0 from the drop down list... "Allan Mitchell" wrote: Have you tried setting up a DSN and using the "Other Connection" Data Source? Allan "charlie" <charlie (AT) discussions (DOT) microsoft.com> wrote in message news:EE522A25-35A4-437F-A751-B4655509DD4A (AT) microsoft (DOT) com: Dear All, I have installed Microsoft OLE DB Provider for Visual FoxPro 9.0. When I do an Import in SQL2000, I can get the data source as Microsoft OLE DB Provider for Visual FoxPro. When I try to create a DTS package, I cannot find such option as a Data Source... If anyone knows why... please let me know how I can fix that. Thanks a lot! Charlie |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.