I am generating an error in one step so the dts execution will flow to a
different direction
than the one it would normaly choose (on that step's success).
The thing is that when I schedule it in to a job the step's failure fails

I am trying to refresh data in a table from one SQL database to the other SQL
database weekly.  Each database is on its own server.  The table on the
database on each server is identifcal.  The key in the table is an identity
key.  

I've created a data transformation task to load a delimited text file into a
SQL sever table.  Some of the columns of data which have a FK constraint can
have NULL values.  This shouldn't be a problem however I'm getting errors on
those records with 'NULL' values.  The source file ...

can anybody show me how i can run a sql query and insert the data into a send
mail task  
The sql statement will produce the following out put  
  Live   ordred  Cancelled

I have a bulk insert question. I have a standard transform data task that
copies data from one database to another. As part of the insert, I am
sending some data that needs to be split out and transformed slightly and
inserted into another table (there could potentially be more ...

When I run a package with dtsrun utility I wanted other users to run it also
and provide the necessary global variable parameters but not be able to view
or edit it.
However, it only works correctly when the owner password is  provided in /M.

I am creating a DTS package to archive records from one table to another, given a certain lower and upper row count.
These lower and upper values need to be dynamic, and if possible used as global variables.
In essence, in VBScript I would like to have the individual executing the ...

I have a SQL Package with a owner password and a execute password(is
this so-called?). This means that a user can execute a package but not
look into it.
I want to read the package in visual basic.net but i recieve an error

I am calling a DTS from a stored proc.
when I FORCE a task to fail (testing) the following code
does not return an error...it will always return 0
therefore never going inside the if statement.

I am creating a dts package programmatically in a vb.net
windows program.
While executing the package i sometimes get the
error "Code execution exception:  

I created a package to export data from one source and output as text file.
It worked successfully if the output text file is on this 1st PC as the SQL
Enterprise.
However, if I change the output text file to be on 2nd PC and I execute the

I've been trying to debug ActiveX scripts that I'm using in my DTS
packages.
I have my DTS packages in SQL2000 . I have MS Visual Studio 6.0 and
InterDev installed on my machine which runs on Win 2000.

I am having a heck of a time SAVING a View when using a LINKED Database Table.
From Enterprise Mgr, I create new View, Add the Tables or Views, also
dragging a View from a Linked Database Table and Run it, it works fine.  When
I try to SAVE that I get an Error Message of:

Hello,
 I have a DTS Package that, when I launch it manually, it runs a directory
to directory FTP.
The source is a local directory and the destination is on a whole different

...non-whitespace characters were found after the last defined column's data.
Here I was attempting to import a text file where each record is 730 bytes
and has 49 fixed-length columns.
Are there restrictions to how many records and how wide the records can be