Board index » delphi » CALL a DTS Package

CALL a DTS Package

How to call a DTS package from SQL 7
Need Delphi5 example
 

Re:CALL a DTS Package


You need to import the type library and put it in the uses clause,
but this is one way:

var
  Form1: TForm1;
  oPackage : Package;

implementation

{$R *.DFM}

procedure TForm1.Button1Click(Sender: TObject);
var
  wsServerName, wsUserID,
  wsPassword, wsPackageName,
  ParamAll: OleVariant;

begin
 oPackage := CoPackage.Create;
  wsServerName := WideString('TEST2');
  wsUserID := WideString('sa');
  wsPassword := WideString('');
  wsPackageName := WideString('Foo2');
  oPackage.LoadFromSQLServer( wsServerName, wsUserID, wsPassword,
          ParamAll, ParamAll,ParamAll,ParamAll,wsPackageName,ParamAll);
  oPackage.Execute;
end;

Quote
"forums.inprise.com" <alf...@usa.net> wrote in message

news:81me86$uu4@forums.borland.com...
Quote
> How to call a DTS package from SQL 7
> Need Delphi5 example

Re:CALL a DTS Package


In article <81ve2v$cg...@forums.borland.com>,
euan.gar...@spicedham.usa.net says...

Quote
> You need to import the type library and put it in the uses clause,
> but this is one way:

Which is the appropriate file?

-------------------------------
Paul Lambadaris
Singular Computer Applications
mailto : p...@singular.gr
www    : http://www.singular.gr

Re:CALL a DTS Package


"Microsoft DTSPackage Object Library"

This will allow you to excute packages, if you want to create
packages containing the pump (Transfer Data Task) then you
will need the datapump library as well.

-Euan

Quote
"Paul Lambadaris" <p...@singular.gr> wrote in message

news:MPG.12ae2040fc5f647b98969c@gate...
Quote
> In article <81ve2v$cg...@forums.borland.com>,
> euan.gar...@spicedham.usa.net says...
> > You need to import the type library and put it in the uses clause,
> > but this is one way:

> Which is the appropriate file?

> -------------------------------
> Paul Lambadaris
> Singular Computer Applications
> mailto : p...@singular.gr
> www    : http://www.singular.gr

Re:CALL a DTS Package


Import Type Libary
=>IDE :Project/Import Type Libary

choice 'Microsoft  DTSPackage Object Libary'

Quote
forums.inprise.com <alf...@usa.net> wrote in message

news:81me86$uu4@forums.borland.com...
Quote
> How to call a DTS package from SQL 7
> Need Delphi5 example

Other Threads