[dba-SQLServer]Execute a DTS from Access -- Sample Code

Mark L. Breen subs at solution-providers.ie
Tue Aug 26 07:22:04 CDT 2003


Hello Susan,

Yes I was referring to the script that happens within the DTS packages, but
it is not so urgent for me.  If was just curious whether people on the list
ever do some kind of processing on a row by row basis.  However, I will take
a look at Mark Porters link,

Thanks anyway,

regards

Mark




----- Original Message ----- 
From: "Susan Geller" <sgeller at cce.umn.edu>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Thursday, August 21, 2003 3:09 PM
Subject: RE: [dba-SQLServer]Execute a DTS from Access -- Sample Code


> Mark,
>
> Not sure what you are referring to. What I pasted below is the code in
> Access.  I have seen, although have not written, Active X scripts to
> make DTS's more dynamic and make use of parameters.  I have some samples
> of that.  I know you can save a DTS as a VB script because I just did
> that for Martin yesterday.  I could post what that looks like here, but
> you could do that yourself with any of your DTSs to see what it looks
> like.  I'm not sure if any of this is answering your question.
>
> --Susan
>
> -----Original Message-----
> From: Mark L. Breen [mailto:subs at solution-providers.ie]
> Sent: Thursday, August 21, 2003 5:19 AM
> To: dba-sqlserver at databaseadvisors.com
> Subject: Re: [dba-SQLServer]Execute a DTS from Access -- Sample Code
>
>
> Hello Susan,
>
> Have you executed script in DTS packages?
>
> I am aware since the first time I saw them that you can run some kind of
> VB script but I have never done it.
>
> I know that Martin was seeking the VB code to execute the package, but
> do you have script?  I would love to see some just to get the basic
> syntax
>
> Martin, I am using DTS to import about 100 files per week and I find it
> reliable, just to let you know.
>
> Thanks Susan,
>
> Mark
>
>
> ----- Original Message ----- 
> From: "Susan Geller" <sgeller at cce.umn.edu>
> To: <dba-SQLServer at databaseadvisors.com>
> Cc: "Martin Reid" <mwp.reid at qub.ac.uk>
> Sent: Wednesday, August 20, 2003 4:53 PM
> Subject: [dba-SQLServer]Execute a DTS from Access -- Sample Code
>
>
> > Here's the code that executes the DTS:
> >
> >
> >             Dim objPackage2 As New DTS.Package
> >             objPackage2.LoadFromSQLServer "MyServerNameHere", , ,
> > DTSSQLStgFlag_UseTrustedConnection, , , , "MyDTSNameHere"
> >             objPackage2.FailOnError = True
> >             objPackage2.Execute
> >             objPackage2.UnInitialize
> >             Set objPackage2 = Nothing
> >
> >
> >
> > -----Original Message-----
> > From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
> > Sent: Wednesday, August 20, 2003 10:43 AM
> > To: Susan Geller
> > Subject: Re: DTS
> >
> >
> > Both would save me a bucket of time.
> >
> > Many Thanks
> >
> > Martin
> >
> >
> > ----- Original Message -----
> > From: "Susan Geller" <sgeller at cce.umn.edu>
> > To: "Martin Reid" <mwp.reid at qub.ac.uk>
> > Sent: Wednesday, August 20, 2003 3:58 PM
> > Subject: RE: DTS
> >
> >
> > Do you want the code I am using in Access that executes the DTS or do
> > you want the DTS?
> >
> > --Susan
> >
> >
> > -----Original Message-----
> > From: Martin Reid [mailto:mwp.reid at qub.ac.uk]
> > Sent: Wednesday, August 20, 2003 9:37 AM
> > To: Susan Geller
> > Subject: DTS
> >
> >
> > Susan
> >
> > Could I see your DTS script. I am about to do something very similar?
> >
> > Martin
> >
> > _______________________________________________
> > dba-SQLServer mailing list
> > dba-SQLServer at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> > http://www.databaseadvisors.com
> >
> >
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>




More information about the dba-SQLServer mailing list