I am attempting to debug the "number of failing rows
exceeds the maximum specified" error on an xpp sp2 client
with client tools with sp3a.
The DTS package copies rows from an excel document into a

I have a DTS package that imports a text file.  The test file it import
depends on a global variable that an activex script looks up while its
running (it changes the source of the Text File (Source) connection).
It all works fine.

Hello NG,
i really like the DTS, but why one earth cant the
DTS copy the primary key property?
I always have to edit the importetd tables manually and set

I have active x Script in main package which calls send mailtask in another
package. both packages are in the same database.
can any one help me by providing an example. i am new to Active x Scripting.
thanks

I want to pass a param to a stored proc, from a DTS package.  I'm able to
pass params to queries in certain Execute SQL Tasks (by using a Global Var
and the ? in the query), but I can't figure out how to pass a param to a
stored proc in an Execute SQL Task.  Can I?  Or do I have ...

I try to setup the data transfer package from DBIII to SQL2000.
How can I setup the DTS package tansfer only the new data daily?
Thanks,

Using SQL Server 2000
DTS package runs a simple query from a SQL Server table in the
'Transform data task' object  and then writes results to a text file defined
in tab 'Destination' under 'Table name:'.  

Using SQL Server 2000.
Running the following DTSRUN line in OPCON job:
DTSRUN /N"XML Data Load 1" /E /SDEV1 /L\\OPCONJOBS\OUTPUT\XML01.out
The file XML01.out is growing larger and larger due to the DTSRUN output

Is there any way to pass a file name to a DTS Package? I'm using a
DTS.Package2 object in VB6 (using LoadFromSQLServer etc.).  The package
imports an Excel file into a SQL2000 table.  When I created the DTS import I
specified a file name, but I'd like to be able to override it in ...

I have a DTS package that is doing some unexpected things.
I know the log shows which steps in the package were executed.
Is there any way to track more detailed information like what the Global
variables are at each step or what lines of code are executed

How can i perform a two dimensional lookup through DTS. Therefore I
want to pick a value from a table by providing primary key and column
name. My table is having 50 columns. I can implement the functionality
using 50 lookups but that seems like a bad idea.

Hello, I want to use a HTML File connexion but I don't know how to configure
this connection. Do you have an example ? Thank's.

I've been using DTS to import data from Excel into a database (both SQLServer
and Oracle).  I've run across a problem recently in a couple of different
spreadsheets where a cell that has data in it is being read as NULL from DTS.
This happens both when I write a SQL query for ...

I am using a DTS package to import a text file that contains weblogs from
our firewall. I need to parse out one field before the import in sql2k. The
field contains the date yyyy-mm-dd 00:00:00. I would like to move the time
00:00:00 to a new column in the sql db.

I was pointed in this direction from microsoft.public.windows.server.sbs
I have a question about automating importing text files into a table in SQL
Server. I`m a complete SQL server "noob" but I am looking for a way to
import all