ADP and DTS

  • Thread starter Thread starter Brennan
  • Start date Start date
B

Brennan

Hello:

I have two questions:

Is there anyway to pass parameters from an Access Data
Project directly to a either an SQL Transform Data Task
or an Execute SQL task?

Can I also launch a DTS package from within an ADP?

Any suggestions or referrals to reference information
would be appreciated.

Thanks,
Brennan
 
Brennan said:
Hello:

I have two questions:

Is there anyway to pass parameters from an Access Data
Project directly to a either an SQL Transform Data Task
or an Execute SQL task?

Can I also launch a DTS package from within an ADP?

Any suggestions or referrals to reference information
would be appreciated.
Click to expand...

Dim objPackage As DTS.Package
Set objPackage = New DTS.Package
objPackage.Properties("LogServerName") = "(local)"

.... etc. ...

See the SQL Books On Line (BOL) for more info - under DTS in the search
index.
 
Back
Top