"vt" wrote:

> Hi,
>
> If you want to learn more on DTS then check this site www.sqldts.com
> but i am sure dynamic sql + excel export sp could be enough to do this job
>
> Regards
> VT
> Knowledge is power, share it....
> http://oneplace4sql.blogspot.com/
> "John" <John@discussions.microsoft.com> wrote in message
> news:CFD3CF39-B203-467A-AB6E-9D0EC589FFE8@microsoft.com...
> > Thanks very much for your reply.....
> >
> > But Im looking for a DTS application, i have a similar complex requirement
> > to do using DTS package. I would like to know, how to use those various
> > sqltasks, sqldriventaks etc in DTS.
> >
> > Please help !!!
> >
> > Thanks again !!
> > John
> >
> > "vt" wrote:
> >
> >> John
> >>
> >> see the following link
> >> http://weblogs.sqlteam.com/mladenp/archive/2006/07/25/10771.aspx
> >>
> >> Regards
> >> VT
> >> Knowledge is power, share it....
> >> http://oneplace4sql.blogspot.com/
> >>
> >>
> >> "John" <John@discussions.microsoft.com> wrote in message
> >> news:DD7AF189-7674-4F35-995E-00C50CA3D4AA@microsoft.com...
> >> > May I get a sample DTS program to do the following task?
> >> >
> >> > Read the records from a table X and export the data part by part into
> >> > excel
> >> > files untill all records are exported.
> >> >
> >> > Eg. Export 100 records in each file. The file name should be like
> >> > Samplefile_RecNo_1_to_100.xls, Samplefile_RecNo_101_to_200 etc.
> >> >
> >> > Appreciate your valuable answers.
> >> >
> >> > Thanks,
> >> > John
> >>
> >>
> >>
>
>