Solved

Executing DTS within VB.net

Posted on 2004-10-12
2
192 Views
Last Modified: 2010-04-23
I have problem I can't seem to figure out. I created a DTS package on SQL Server 2000 to import data from a foxpro table to a SQL server table.  It works fine on my machine but when I deploy it out to another machine it says "String invalid" or something along those lines when it tries to import the data from foxpro.  When moving data from one SQL table to another SQL table it runs fine on both machines.  Any help would be appreciated.

Thanks
Tim
0
Comment
Question by:tbailey922
2 Comments
 

Author Comment

by:tbailey922
ID: 12291114
I figured it out.  I had to download and install the foxpro oledb drivers, apparently they were old and outdated.  
0
 
LVL 7

Accepted Solution

by:
LandyJ earned 250 total points
ID: 12292225
tbailey.

You'll want to request a refund because you answered your own question (Refund/PAQ or Rrefund/Delete)
http://www.experts-exchange.com/help.jsp#hi70
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question