dbTalk Databases Forums  

Communication ADP access and DTS sql server.

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Communication ADP access and DTS sql server. in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Xav
 
Posts: n/a

Default Communication ADP access and DTS sql server. - 12-08-2005 , 05:07 PM






I would to control my DTS package from within my ADP project under
Access. I don't want to import the DTS package as a vb module, I would
like to remotly manipulate the package.
For instance my ADP proj. need to send a variable to the DTS pack. (a
date) in order to dynamicly create a table whose the name will be
NEWTable<DateSent>.
(Moreover, how can I create a table with a dynamic name in DTS?).


Reply With Quote
  #2  
Old   
urchin
 
Posts: n/a

Default Re: Communication ADP access and DTS sql server. - 12-09-2005 , 07:33 AM






One thing to consider is having the ADP execute a stored proc on sql
server that performs anything dynamic you need (like getting the date,
creating a table) then use the sp_oaexecute (there's some for setting
parameters too) methods to load/execute your dts package. Alternative
to the sp_oa... methods you could execute a stored package using dtsrun
from the proc supplying variables at runtime on the command line.

Don't know if this is best/most efficient, but a place to start.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.