"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:ulQHrkrLEHA.2012@TK2MSFTNGP11.phx.gbl...
> I presume it would be within an Active Script task.
>
> You will need to programmatically
>
> Open each package
> Loop through the Tasks - Find the Active Script tasks
> Find the ActiveXScript property and see if your function is in there.
>
> You could also do this if your Function is within a DataPump task.
>
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Dan" <ddonahue@archermalmo.com> wrote in message
> news:OzesferLEHA.1032@tk2msftngp13.phx.gbl...
> > I'm using SQL Server 2000. I created a function in a dts that I want to
> use
> > again but I don't remember which package it is in but I do remember the
> > function name. Is there a way to search all dts packages for the name?
> >
> > Thanks,
> >
> > Dan
> >
> >
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:OCzaResLEHA.140@TK2MSFTNGP09.phx.gbl...
> OK we have examples here of using the object model in VB (and others)
>
> Execution
> (http://www.sqldts.com/Default.aspx?104)
>
>
> But your code would go something like
>
> Load Package
>
> For each Task in package.Tasks
> If Task.CustomTaskID = "DTSActiveScriptTask" THEN
> msgbox Task.ActiveXScript
> End if
> Next
>
>
> You would obviously search the ActiveXScript and not just output it to a
> msgbox.
>
> You can enumerate through your packages by using this article
>
> Enumerating DTS Packages using VB.Net
> (http://www.sqldts.com/default.aspx?250)
>
>
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Dan" <ddonahue@archermalmo.com> wrote in message
> news:uRAbLYsLEHA.808@tk2msftngp13.phx.gbl...
> > I've never done this. Can you point me to some code sample about how to
> open
> > a package or tell me what the object is and I can search on it?
> >
> > Thanks,
> >
> > Dan
> >
> > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> > news:ulQHrkrLEHA.2012@TK2MSFTNGP11.phx.gbl...
> > > I presume it would be within an Active Script task.
> > >
> > > You will need to programmatically
> > >
> > > Open each package
> > > Loop through the Tasks - Find the Active Script tasks
> > > Find the ActiveXScript property and see if your function is in there.
> > >
> > > You could also do this if your Function is within a DataPump task.
> > >
> > >
> > >
> > > --
> > > --
> > >
> > > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > > www.SQLDTS.com - The site for all your DTS needs.
> > > I support PASS - the definitive, global community
> > > for SQL Server professionals - http://www.sqlpass.org
> > >
> > >
> > > "Dan" <ddonahue@archermalmo.com> wrote in message
> > > news:OzesferLEHA.1032@tk2msftngp13.phx.gbl...
> > > > I'm using SQL Server 2000. I created a function in a dts that I want
> to
> > > use
> > > > again but I don't remember which package it is in but I do remember
> the
> > > > function name. Is there a way to search all dts packages for the
name?
> > > >
> > > > Thanks,
> > > >
> > > > Dan
> > > >
> > > >
> > >
> > >
> >
> >
>
>

"Dan" <ddonahue@archermalmo.com> wrote in message
news:OzesferLEHA.1032@tk2msftngp13.phx.gbl...
> I'm using SQL Server 2000. I created a function in a dts that I want to
use
> again but I don't remember which package it is in but I do remember the
> function name. Is there a way to search all dts packages for the name?
>
> Thanks,
>
> Dan
>
>

"Dan" <ddonahue@archermalmo.com> wrote in message
news:uRAbLYsLEHA.808@tk2msftngp13.phx.gbl...
> I've never done this. Can you point me to some code sample about how to
open
> a package or tell me what the object is and I can search on it?
>
> Thanks,
>
> Dan
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:ulQHrkrLEHA.2012@TK2MSFTNGP11.phx.gbl...
> > I presume it would be within an Active Script task.
> >
> > You will need to programmatically
> >
> > Open each package
> > Loop through the Tasks - Find the Active Script tasks
> > Find the ActiveXScript property and see if your function is in there.
> >
> > You could also do this if your Function is within a DataPump task.
> >
> >
> >
> > --
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.SQLDTS.com - The site for all your DTS needs.
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >
> >
> > "Dan" <ddonahue@archermalmo.com> wrote in message
> > news:OzesferLEHA.1032@tk2msftngp13.phx.gbl...
> > > I'm using SQL Server 2000. I created a function in a dts that I want
to
> > use
> > > again but I don't remember which package it is in but I do remember
the
> > > function name. Is there a way to search all dts packages for the name?
> > >
> > > Thanks,
> > >
> > > Dan
> > >
> > >
> >
> >
>
>