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] 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] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page