"bnhcomputing" <bnhcomputing@discussions.microsoft.com> wrote in message
news:BDF85517-31B0-4514-92C6-8E5D4C79F85E@microsoft.com:

> Allan:
>
> I'm knew to DTS, so where is the parameters button? Is there an example
> somewhere of what you are talking about?
>
> Additionally, could you explain what "Connection with transaction manager
> was lost" has to do with my original post? I read the articles, and couldn't
> see how they applied to my original question.
> --
> bnhcomputing
>
>
> "Allan Mitchell" wrote:
>
> > You may be able to replace the dates in the Query with ? Placeholders.
> > You can then use the parameters button to map onto them a Global
> > Variable. If not then you can build the statement yourself which is the
> > long way around like this
> >
> >
> > http://www.google.com/search?sourceid=navclient&ie=UTF-8&q=%22A+Connection+with+the+transaction+manager+was+lost%22+
> >
> > Allan
> >
> >
> > "bnhcomputing" <bnhcomputing@discussions.microsoft.com> wrote in message
> > news:475036B2-A472-44C1-BABF-63ABC88BE13A@microsoft.com:
> >
> > > I have a DTS package. The select for one of the transform data tasks look
> > > like:
> > >
> > > SELECT * FROM UDF1('1/1/2005','12/31/2009')
> > >
> > > right now the dates are hard coded. Is there a way to pass parameters to
> > > the DTS package to change the dates? Can I use DTS global variables?
> > >
> > > Any other ideas how to do this?
> > >
> > > Thanks
> > > --
> > > bnhcomputing
> >
> >