dbTalk Databases Forums  

DTS Scripting

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss DTS Scripting in the microsoft.public.sqlserver.olap forum.



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

Default DTS Scripting - 08-20-2003 , 01:57 PM







Hello my good friends,



I need to run a DTS task but I canīt create a job in the server because
I donīt have permission to do that (I needed msdb db permission)...
anyway, the point is that I need to export a SQL table and import it
into Access Table... and Iīd like to do that by ASP DTS script without
to use a DTS Job created (it will be simple using sp_start_job). To be
clear, I wanna create or run a "temporary" task/job by VBScript
(ASP)... and so, to execute it without to need to save it in the
server. Can I do that?!



Thanks is advance,

Regards,

Alex Berenguer


--
Posted via http://dbforums.com

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.