Search results for query: *

I wish it was that easy. Have tried MS, Hit, DataDirect, All have various problems. HiT has been the most willing to work with us so far. Will continue and post what we find.

I retract, Didn't notice the brit time first time around.

Oh my! Sorry! Forgot a step. The Convert(DateTime, DateFiled + ' ' + TimeField, 103) is still valid, but MS does not suggest adding binary values to datetime fields, instead, use the dateadd function. Therefore, the final solution is: DateAdd( s, 30, Convert(DateTime, DateField + ' ' +...

Ah, brit time. This is simpler... Assuming Datefield and TimeField are char values... Convert(DateTime, DateFiled + ' ' + TimeField, 103) Ta! ;-) -crj

Have been having a difficult time getting a connector to work between Microsoft Sql Server 2000 and IBM DB2 Universal Database, over TCP/IP, both running on Win 2K machines. Has anyone had any success?

Yup, no problem. Create a new DTS Package, Specify Sql Server as Source, Then XL as Destination, And Data Transform Between. Set your query in the Data Transform Source.

CAST(mDate as DateTime)

I'm pretty sure there's an option to run DTS from the command line, dtsrun or something, but I do like using Sql Server Agent much better...In fact, can't you schedule directly from Enterprise Manager? I think you can even notify via email if the DTS fails...

Have been having a difficult time getting a connector to work between Microsoft Sql Server 2000 and IBM DB2 Universal Database, over TCP/IP, both running on Win 2K machines. Has anyone had any success?