I am creating a Job using the SQLDMO interface, if the job fails I want it
to email someone with an appropriate error message.
On some servers this works fine and on others it doesn't, it all seems to
depend on the mail profile settings.  The wierd thing is that an activeX

In  DTS 2000 Vb script there is "DTSTransformStat_SkipRow" which will
skip a row when we are processing.
I need the equivalent of this in 2005 how to write in VB.NET Code
If you can find some thing please let me know.

I am refactoring stored procedures that use dynamic sql.
The reason the store procedures use dynamic sql is because
the data that is need comes from another MS SQL database
that resides on the same server instance. The name of this

How would I replace part of this data type ...
When using it in select it just gives an error....but the lenght is only 16
in the table defintion - how can it be long then...=
Need to select and replace a substring.

I'm having an issue that looks suspiciously like a timeout on a task.
We're using VB6 to use Automation to write a DTS package in memory,
execute it, and remove it. This is a flat, fixed format, file as a
source, with SQL Server 2000 as the destination. The file in question is

I have been setup a Win2k3 Server and MSDE 2000 SP3, both of them can startup
success. But  I can not connect MSDE with other computer, the error message
is connect fail ....something like that. I can connect MSDE in the Win2k3
Server when I type localhost to connect it. I can ...

I have a DTS package which runs fine from the Enterprise manager but
the job fails. I am logged into the server as the sysadmin and the job
owner is the sa account. I have also made sure that all have full
rights to the SQL database. The DTS job has a bunch of SQL Tasks and

I am trying to import some data from an excel spread sheet in to sql using a
DTS and Excel 97 - 2000 data source (I have also tried importing with Excel
4.0 and 5.0 datasource).  I am getting a problem were data is ignored if it
does not match the type of the first row.  An example ...

I am trying to import a pipe delimited file in a DTS package.  I am getting
the error "Too many columns found in the current row; non-whotespace
characters were found after The file I am trying to import is only 12 rows
with 1 row of header information.  I have noticed that this ...

I'm using the following transformation script to import data from Excel:
One excel row has to be splitted into 5 records.
The field ID is my primary key.
How can I persuade SQL Server to automaticly set the primary key values ?

I want 10 packages to run in sequence.  I was told the Execute Package Task  
would do it but it looks like it can only call one other package.  
I want it to call all 10 in order.  
Am I missing something

SS 2000
In my SQL Server DB, I need to create a DTS package that will push the
content of a view to a text file on an FTP site.  I have created the DTS
that pushes the data to a file server but I don't know how to push the data

I want to use DTS to have a quote delimited, space separated text file for
meeting the requiremenst for one of our vendors for data format.
I've been doing quoted, vertical bar separated, running the DTS, opening the
txt file output, and doing a Search->Replace All "|" with " "

I'm getting an error when running a simple dts package created through the
import/export wizard. It's only happening on 9 tables out of 50. The tables
that error out do have the TEXTIMAGE_ON [PRIMARY] but when I take if off the
target table I still get the error. The error is ...

I'm trying to load data into an Access table that has an autonumber
field.  The message "There is no column object mapped to the
non-nullable column CityID in the database".
Is there a way to turn off this validation?