There's no real reason to argue with your ideas so far that I know of.

However if you want to work through DTS but are more comfortable coding in
T-SQL, why not develop a stored procedure in which you can use SQL to meet
your requirements as far as you can using SQL and then execute it from DTS?

> -----Original Message-----
> From: Shibu MB [SMTP:[Email Address Removed] Sent: Wednesday, November 20, 2002 4:15 AM
> To: Long, Charles (euler:eti)
> Cc: [Email Address Removed] Subject: RE: DTS Programming using T-SQL
>
> Charles ...
>
>
> I am working on a project which has multiple databases
> .Users
> dial in and synchronize or may upload some data to one central database
> once
> in a day . I am looking for a solution for this and i thought DTS
> programming is the best way to do that.That's why i asked such question
> .
> Can u suggest best solution for this ??
>
>
> Thanks
> Shibu
>
>
>
> -----Original Message-----
> From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] Sent: Tuesday, November 19, 2002 6:16 PM
> To: LazyDBA.com Discussion
> Subject: RE: DTS Programming using T-SQL
>
>
> Hi Shibu,
>
> I don't really understand why you'd want to do this. You can run T-SQL as
> a
> stored procedure or as an input file to osql specified through the -i
> parameter. Both of these options could be invoked from a DTS package /
> script.
>
> Charles
>
> > -----Original Message-----
> > From: Shibu MB [SMTP:[Email Address Removed] > Sent: Tuesday, November 19, 2002 8:07 AM
> > To: LazyDBA.com Discussion
> > Subject: DTS Programming using T-SQL
> >
> > Hi all.............
> >
> > Is it possible to do DTS programming using
> > Transact-SQL.?
> > All documents I found mention that DTS programming using VB , VC++ etc
> > etc
> > only .
> > Do u guys have any doc or links which help me to do DTS programming
> > using
> > T_SQL????
> >
> >
> > Thanks
> > Shibu
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page