dbTalk Databases Forums  

Re: DYS - Data Driven Query Task

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


Discuss Re: DYS - Data Driven Query Task in the microsoft.public.sqlserver.dts forum.



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

Default Re: DYS - Data Driven Query Task - 08-03-2004 , 12:28 PM






Maybe this article will be of help:
http://www.sqldts.com/?246

--
Jacco Schalkwijk
SQL Server MVP


"Peter Newman" <PeterNewman (AT) discussions (DOT) microsoft.com> wrote

Quote:
I have a DTS set up to inport files from a specific directory using a DDQ
Task. Is there a way to set the task's 'Table/View' property from a Global
variable. ive been trying to use a Dynamic propertied task, but i keep
getting a faluire stating the file was not found, yet if i re run it it
loops round 1 cycle fine.

I was thinking of using an Activex task to set the names ??



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.