I'm trying to create an update query that updates a field to the persons
current age using DateDiff. If the person's anniversary has occured this
year, I need to subtract 1 from the DateDiff result to be accurate. The query
logic below works perfectly in a Select statement, but I ...

I'm writting some VBscript ActiveX code inside a DTS Package, and i'm
getting a parse error. (This script runs fine in Access).
I believe it has something to do with the "TO" porttion of the case
statement ( case 1 to 30).

I have a package that imports data from 3 different Access DB's into MS
SQL. I am using loop mechanism expalined here :
http://www.sqldts.com/default.aspx?298
I modified that sample to do double loop: outter loop itirates through

I am new to DTS... can anyone send me some good link or e-books which are
freely available over Net for C# and DTS Programming
Thaks
Silent Ocean

Ho can I create a DTS, and run it as a script ?
I mean... like cscript or wscript.
I need to generate a DTS script for the testing environment, and then run it
in the production environment. So I need to configure the script with the

I am re-writing an old BCP job using DTS. The job imports a fixed length text
file which includes date fields in the format yyyymmdd. Sometimes there will
be no valid date on a record and this is held as '00000000' in the text file.
This should be moved into the database as a ...

I am trying to import some data from excel to SQL server table. In excel
file there is a column which is mostly empty [around 99 % rows] so when I
am importing the file. the DTS package is putting null in all rows even if
there is a value in that row for that column. is there any ...

I have created a VB program to perform DTS tasks for data transfer from
ACCESS database to SQL Server. The DTS are created by saving the actual DTS
packages as VB file and used those bas files in VP app to run the DTS
programmatically.

In the below ActiveX script (taken initially from BOL) I compare file dates
& only want to continue the DTS if if the file date is newer.
However, if the file date is NOT newer the Step is "failing", whereas I just
want to STOP

Does anyone know if there is a beta newsgroup for Sql Server 2005 DTS?
Thanks!

Is there a way, other than scripting a loop to utilize the Bulk utility, to
Load all the XML files in a particular directory into a XML data type column
in a 2005 table?

Is it possible to setup DTS in SQL Server 7 in such a way to make a copy of a
local database that is sent to a file share in a domain for archival
purposes? Because the server doesn't meet certain company security
requirements, the requirement is that it be moved into a workgroup ...

I currently have a package that has 10 paths running in parallel. If
any steps on any of the paths fail, then I want to send out an email. I
would prefer to use a single email task. The task would loop through
all of the steps and see if any failed. If anything failed it would

Currently when I perform a export to excel, those fields with datetime will
only show date. I understand that I can open that excel file and change to
the correct format. But I would like to have it set automatically after the
export is done.

HI,i am trying to call stored procedure from ASP page, below is my
coding. But i dun know why i fail to call the stored procedure.Can
anyone tell me what's wrong with this coding?
THanks