I have one comma delimitted text file without headers. It has 10 lines. I
imported the txt file to a table, but only 9 rows have been inserted, but
When I try to import the txt file using Bulk-Insert, it inserted all 9 rows.
Pls help me why all records are not inserted in DTS.

Does anyone have any idea if you can get/set the properties of an active DTS
package progress dialog box using the SQLNamespace object from within another
DTS package executed after the dialog is opened?

I downloaded a sample package from sqldts that is exactly what I needed -
http://www.sqldts.com/default.aspx?246.  I have one question about it, and
ActiveX tasks in general.
In step 6, it has the loop returning to "set stpbegin =

I have a CSV file like this:
"fieldValue1","fieldValue2","fieldValue3","fieldValue4"
I'd like to create a DTS package which dose the following operation on the
CSV file:

I am running a package from within another package using ActiveX
script.  Everything works fine (global variables are passed and set
between both packages as expected).  Can the execution status dialog
show the progress of a child package's tasks (list each task and the

I extracted some VB script  from the WROX book "SQL Server 2000 DTS" to get
error information.  The rest of the script works fine.  The problem segment
gets a readble form of the
error.

Do you know how to back up all the DTS packages automatically without
having to put the server name inside the VBscript?
Thanks in advance
BIBIBO

I'm using a .Net application to execute DTS packages within Sqlserver,I need
to have very customizable and powerful Exception maangement systems which
loggs different issues happend in the DTS package with my own errorCode. Can
somebody give me some ideas?

How do I get the result string from a "Execute SQL Task".  Say I have a SQL
statement "DELETE FROM TBL_X"
I run my DTS package and 50 records are deleted.  Or it could be an UPDATE
and 50 records changed.

Can I run a DTS from a store procedure using NT authentication?
Using rundts , what's the syntax of this command?

I created execute sql task with the below insert statement.
Insert into properties(PROPERTYID)
select   propcode  from htcrepr
where propcode not in (select propertyid from properties)

I have a database (SQL Server 2000 Enterprise Ed.) with a single table
(Products), which has 3 columns set for Full-Text-Indexing.  This
database is working fine.  All queries are done through Stored Procs,
and works like a charm.

I'm trying to write a DTS to load data from a csv file into a database
which has "." in the name.  I can set up the connection ok but when I
try to set up the transform data task, it keeps saying that the first
part of the name needs to be added to sysservers.  How do I stop it

I'm using the vbscript below to import values into SQL Server.  If a column
is null then I want another value used from a different column.
But I keep gettin the error "invalid procedure call or argument DTSSource"
Any thoughts.

Hi,
I wish to import data from XLS into SQL Server using DTS. However, i want
only a particular cell mapped to some column in a table in database. For
example, C(9,9) of the XLS should get mapped to Column X in Table Y.