I want to use a global variable setting in Data Pump Tasks and Execute
SQL Tasks. Is there a way to do this other than using a '?' in the
WHERE clause? i.e. I want to use the variable in the SELECT part of the
SELECT statement. So something like this (which isn't possible):

I have some scheduled dts packages.  They error out with this message every
time.  I can run the package manually with no problem.
Step 'Copy Data from AGENCY to [CMHC].[dbo].[agency] Step' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Package

im using the sql package (send mail task) & it work fine on my machine
when i try to run the job on the server(other machine) it gives me an error
say:
"Initialization of MAPI Failed , Please make sure that you have messaging

I have a issue with missing and non-operational Connection objects on the
DTS Toolbar.  I am using SQL Server 2000 in a Windows 2000 environment.
The following connection objects are missing:
Excel,

Hi Folks, I am getting this strange error while scheduling a DTS.
What I am trying to do is copy data from DB2 on mainframe to a SQL
server table.  I created the DTS package and runs fine manually. But
when I schedule it, I get this error :

I'm getting the following error when executing a DTS package from
VB.Net.  The DTS packages runs fine from the designer and used to run
fine as well from VB.net
"Global variable 'ExportedRowCount' already exists in the collection"

I currently have a DTS job that movers about 40k to 50k rows from SQL 2K to
Oracle 9i DB. I am using Oracles own OLE DB to connect to the Oracle DB as
its quicker than ODBC.
Its taking 7 minutes to move 2000 rows using a transform data task. So I

I have used the DTS Wizard to generate a DTS script
that migrates table data from a Sybase DB to SQL Server.
I now want to be able to plug in the DTS Dynamic
properties such that I can change both the Source and

Is it possible to write to the application log from within a script in an
ActiveX task? It's pretty easy to do with a custom task in VB, and there's
also an undocumented system stored procedure that let's you do it (although
you need to be running under high priveledge to use it) ...

I have e excel file that has two sheets and both sheets have text on them.
There is text placed on few first rows of these sheets.
I want to place data that comes from a strored procedure at the bottom of
these sheets. How can I do that? I know I can easily place data on an empty

On SQL 2000 I created with Import Data Wizard package "dtsTest". I get
data from Access file on location "C:\Temp\dbTest.mdb". Wizard created
"Connection 1" and "Connection 2" icons if I select Design package. I
call that package from VB.NET 2002 that way:

I'm running a dts package from an ACCESS2000 ADP with the following code  
Dim dtsp As New DTS.Package
   dtsp.LoadFromSQLServer _
       ServerName:="xxfs001", _

We have several scheduled DTS packages on SQL Server 2000 sp3 moving data
from an accounting package. The transforms occasionaly hang up and the
problem may go unnoticed, is there a way to timeout a transform or any other
way of detecting this situation?

I am having trouble with this, and when I google the topic there aren't
any threads with solutions.
The field is postal code, and when I open the file in excel, it says
reads "the number in this cell is formatted as text".  The

Hey all,
prolly a simple solution, but why isn't the following string working in
my execute sql step?
select x from new_files where x like '%[^0-9]%' and x like '%[^a-z]%'