I'm using the following script to transform my source (a fixed field
text file) from yyyyMMdd to a normal datetime field in my destination
table.
Function Main()

My later addition of ON FAILURE sub-packages are not being
executed and yet there is failure.
Illustration:
Suppose package

Hello, all.
I'm new to DTS and am currently working on a project to import two CSV files
into the same table.
Basically, the challenge that I'm having is that each record of the file

Scenario: client wishes to create a utility email account at his company
(utility@blah.com) and have flatfiles (typically sent as zip email
attachments) emailed directly to it. He wishes to have some form of
automation set up to where the flatfile is received by the utility email,

I hope someone might be able to point me in the right direction on this
one.  I am new to this so....... here goes.
I have a DTS ActiveX script that I would like to traverse through a
series of subfolders and copy selected files, rename them and drop them

I created a dts package successfully to transfer a number of Visual FPro
tables to SQL. When I attempted to schedule this task, the job failed and the
task's history showed the following message: "Unable to determine if the
owner of job has server access. Could not obtain ...

SQL Server2000 SP3
I have been trying to create a DTS that uses an FTP task
The DTS executes fine from the DTS designer window
However, when I try and run the DTS from ASP....

I have a VB program that moves data down from a SQL Server to an Access
database. Each time the DTS runs the WHER Statements may change on the
selects where it is pulling data for different customers.
The entire package will excute without hitch sometimes and fail at other

I am pretty new to SQL server.  I have setup a DTS package that would
delete and then copy data from SQL server to DB2 on mainframe. I
installed the Host Intergration Server 2000 client to get OLEDB for
Db2.  The DTS is working fine, when I run it myself from the server.

My later addition of ON FAILURE sub-packages are not being
executed and yet there is failure.
Illustration:
Suppose package

I would appreciate it if I could get some opinions on my proposed solution.
On a nightly basis I have to execute a batch job that would does the
following
1) Execute a Stored Procedure to return a recordset of IDs from a SQL2K DB

Just a quick couple of questions regarding the best practice(s) for
maintaining a database on two servers:
The situation: I have a database on my server which I am constantly working
on (modifying structure and content) and I have also placed a copy of the

Hey all,
strange problem here... query #1 displays 357 records correctly and all
is well. However, when placed within query #2, it updates every single
record in the lta table, what's going on here? any thoughts?

Suppose, if I have to connect to various Servers dynamically, I will have to
use a Dynamic Properties Task. Let us say
I first create a Connection, named "SourceSrv"  using the "Microsoft OLE DB
Provider for SQLServer".

  I am using DTS to transform data from foxpro.when it meets the date of NULL,it fails and says"Insert Error , column 4( 'Coloumn_name ',DBTYPE_DBTIMESTAMP), Status 6 :Data overflow ".
 And then i try to open the DTS Transform Data task and do a preview of the data from the ...