"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:el7lwCZ$DHA.4060@TK2MSFTNGP10.phx.gbl...
> Here's what I need to do. I have several MS Excel templates that I want to
> create a copy of, then put the file in a working directory and push data
to
> several worksheets inside the Excel files using DTS, then I'd like to move
> the file to an FTP server. I have one particular task that I'm not sure I
> can do in DTS, I think it will require some VBA automation, I have to goto
> indivual cells to insert data, can I do this in DTS or do I need something
> like VB.NET or VB...???
>
> (I don't really want to use a VBScript task for this but also realize it
> might be the most efficient way to do it)...
>
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:uwrwk9c$DHA.2664@TK2MSFTNGP09.phx.gbl...
> If you want to start putting data into specific cells then the only way I
> know is to use automation. I did this a while ago on a VBScript task.
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.allisonmitchell.com - Expert SQL Server Consultancy.
> 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
>
>
> "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
wrote
> in message news:el7lwCZ$DHA.4060@TK2MSFTNGP10.phx.gbl...
> > Here's what I need to do. I have several MS Excel templates that I want
to
> > create a copy of, then put the file in a working directory and push data
> to
> > several worksheets inside the Excel files using DTS, then I'd like to
move
> > the file to an FTP server. I have one particular task that I'm not sure
I
> > can do in DTS, I think it will require some VBA automation, I have to
goto
> > indivual cells to insert data, can I do this in DTS or do I need
something
> > like VB.NET or VB...???
> >
> > (I don't really want to use a VBScript task for this but also realize
it
> > might be the most efficient way to do it)...
> >
> >
>
>

"alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion> wrote
in message news:eT9hD76$DHA.4080@TK2MSFTNGP09.phx.gbl...
> Hello Allan,
>
> Thanks for your reply!! You wouldn't be willing to allow me to peruse a
> sample of your automation VBScript task would you...? I see you have a new
> book out, I checked on Amazon there were only two available is that a
> publishing issue or are you just selling alot of books, hopefully the
> later..? It looks like it's going to be a great book I can't wait to get
it.
>
> Dan
>
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
> news:uwrwk9c$DHA.2664@TK2MSFTNGP09.phx.gbl...
> > If you want to start putting data into specific cells then the only way
I
> > know is to use automation. I did this a while ago on a VBScript task.
> >
> > --
> >
> > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.allisonmitchell.com - Expert SQL Server Consultancy.
> > 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
> >
> >
> > "alien2_51" <dan.billow"at"n.o.s.p.a.m.monacocoach.commercialversion>
> wrote
> > in message news:el7lwCZ$DHA.4060@TK2MSFTNGP10.phx.gbl...
> > > Here's what I need to do. I have several MS Excel templates that I
want
> to
> > > create a copy of, then put the file in a working directory and push
data
> > to
> > > several worksheets inside the Excel files using DTS, then I'd like to
> move
> > > the file to an FTP server. I have one particular task that I'm not
sure
> I
> > > can do in DTS, I think it will require some VBA automation, I have to
> goto
> > > indivual cells to insert data, can I do this in DTS or do I need
> something
> > > like VB.NET or VB...???
> > >
> > > (I don't really want to use a VBScript task for this but also realize
> it
> > > might be the most efficient way to do it)...
> > >
> > >
> >
> >
>
>