Re: Help Needed understanding the Problem

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Darren Green (darren.green_at_reply-to-newsgroup-sqldts.com)
Date: 08/04/04 

Date: Wed, 4 Aug 2004 13:19:24 +0100

Here is rough example of how to set the SourceObjectName in script, showing
the collections and objects you go through-

DTSGlobalvariables.Parent.Tasks("DDQTaskName").CustomTask.SourceObjectName =
"Fred" 

-- 
Darren Green
http://www.sqldts.com
"Peter Newman" <PeterNewman@discussions.microsoft.com> wrote in message
news:A2900D6F-D618-422A-991E-83A7F8A27583@microsoft.com...
> Jacco,
>
> Thanks, that has helped a little. I'm managing to set the Text file (
Source) Data Source to the correct file name, but am still having problems
setting the SourceObjectName on the Data Driven Query
>
> "Jacco Schalkwijk" wrote:
>
> > The method as described in http://www.sqldts.com/?246 has worked well
for
> > me. That doesn't use a dynamic properties task, but sets the source via
an
> > ActiveX script.
> >
> > -- 
> > Jacco Schalkwijk
> > SQL Server MVP
> >
> >
> > "Peter Newman" <PeterNewman@discussions.microsoft.com> wrote in message
> > news:412A01BD-F5F6-4202-9049-3EB93A8F6990@microsoft.com...
> > > Im runnung SQL 2000 on Windows 2003 Server
> > >
> > > I have a simple DTS that loops through files in a directory and
imports
> > > them into a table. It then deletes the files
> > >
> > > Step 1 - ActiveX
> > >  Loops through and gets the firat filename, and assigns it to a global
> > > variable
> > > Step 2 -  Dynamic Properties task
> > >  Set the TextFile Source to the Global Variable holding the file name
> > > Step 3 - Data Driven Query
> > >  Update the table with data from the file
> > > Step 4 - Deletes the file and resets the global variable for the
filename
> > > to "". Then  loops back to step 1
> > >
> > > this works fine on the first loop, but on the second loop it fails on
step
> > > 3 stating the source file is not found.  Im at a loss as i know the
global
> > > variable is showing a valid filename and that file exists. Is there a
way
> > > to set the source property directly from axtive x ?  maybe that will
cure
> > > the problem
> > >
> > >
> > >
> > >
> >
> >
> >

Relevant Pages

  • Re: Problem with a script
    ... I don't mean to offend you or discourage you from working with PHP, ... Reworking your huge script into something concise, ... that I have no understanding of loops is completely asinine. ... throw that in while I am on the subject of programming. ...
    (comp.lang.php)
  • Re: Problem with a script
    ... that I have no understanding of loops is completely asinine. ... loops throughout the script. ... business with a history of hiring low knowledge employees, ... throw that in while I am on the subject of programming. ...
    (comp.lang.php)
  • RE: Logical problem with small script??
    ... Logical problem with small script?? ... Wrote it to convert a string using a ceaser cipher for a course I am ... Instead of just going through once it is repeating ie loops to 1 then ...
    (perl.beginners)
  • Re: Performance improvement possible? - update
    ... Philip Rhoades wrote: ... The change to a single Ruby script simplified the previous setup ... the multiple loops in stats06 have been collapsed ...
    (comp.lang.ruby)
  • Re: recursion help request
    ... '5' for input, the script should end. ... corresponding sub-routines, and then return to the inputbox. ... I have tried loops and ended up ... the mainmenu() call at the end of each sub-routine for option 1thru4 to no ...
    (microsoft.public.scripting.vbscript)