Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Sql package to import data from Excel 2003 -> Sql server 2000

Posted on 2004-09-06
2
149 Views
Last Modified: 2010-04-05
I made an sql package that import data from Excel file into sql server table.
That package should be launched from a Delphi application.

 http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_21120355.html

How can I do that ?

0
Comment
Question by:PHD
  • 2
2 Comments
 
LVL 6

Expert Comment

by:bpana
ID: 11991141
I've posted in the other question already. I'll also post it here also as it's more relevant to the question.

use the dtsrun command prompt utility:
WinExec('cmd /c dtsrun /Sserver_name /Uuser_nName /Ppassword /Npackage_name /Mpackage_password', SW_HIDE);
0
 
LVL 6

Accepted Solution

by:
bpana earned 500 total points
ID: 11994348
or use master..xp_cmdshell stored procedure:

ADOConnection1.Execute('exec master..xp_cmdshell ''dtsrun /Sserver_name /Uuser_name /Ppassword /Npackage_name''', cmdText, [eoExecuteNoRecords]);
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Downloading email attachments 2 79
Dev Express grid collapse 2 45
Twebbrowser in Fire monkey android scrolling to bottom 1 44
Browsing a TTreeView in Delphi 5 7
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

840 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