|
dts schedule errors
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
Step Error Description:The Data Pump T ...
Thu, 18 Nov 2004 11:35:02 -0800
|
SQL server connecting, querying
Hi,
I am a new user to DTS. I have worked in VB 6.0 to connect to Oracle
before.
I'm now trying to get some stuff done using DTS. I've been
experiencing trouble connecting to an SQL server , querying it, and
using the results in an ActiveX script coded in VBScript.
I'm stuck in my old ADODB style of codin ...
18 Nov 2004 10:44:08 -0800
|
Error in SQL Server Database
Hello there,
I have a VB6 application that runs over a SQL Server 2000 Database.
Sometimes (most recently) i get the folowing error:
Run-time error -2147467259 (80004005)
Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447
Expression: m_SizeRec > 0 && m_SizeRec <= MAXDATAROW
...
Thu, 18 Nov 2004 18:40:06 -0000
|
DTS and ODBC Data Sources
I can not get the Connection Property to close when trying to create a
connection using an ODBC data source. I click the 'OK' button and nothing
happens.
Any Ideas?????
____________________________________
Wayne Blosat
VP of Information Services
PRO Consulting Services, Inc.
713-523-1800
...
Thu, 18 Nov 2004 11:06:28 -0600
|
Getting the Server and Database Name from the Command Line
I am running a DTS project that calls 10 execute packages in a
workflow to create flat ASCII files from tables.
I know that in order to change the Source Server and Database name in
the Microsoft OLE DB Provider for SQL Server, that I will need to pass
in a global variable, but I am clueless on how to use Ac ...
18 Nov 2004 08:16:01 -0800
|
sucess
In my dts I have a logic in activex task where if file
exists then sucess else is fail. I wanted to have an
outcome of DTS as sucess, becuase the DTS actually runs.
How do I do this. I try to have a laststep activex-sucess
but it is not working. ...
Thu, 18 Nov 2004 07:37:08 -0800
|
Error in runing DTS
Hi Everyone
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
services installed on this system"
Any Idea About what cause this prob ...
Thu, 18 Nov 2004 17:01:14 +0200
|
Regarding flat file read
hi,
I have flat file with atleast 500,000 rows with fixed fields. But, the rows
were divided into 5 different types of rows. First 3 columns are same, 4th
column tells us what type of row it is, in all rows and each row length is
around 80. The remaining columns are different based on the row type.
My ...
Wed, 17 Nov 2004 18:19:02 -0800
|
Excel to SQL using DTS
The Excel file are like this:
Jan Feb Mar
Cost 1 2 3
Sales 3 5 6
....
The SQL tableA have colunms named cost, Sales,... and Month. It looks I have
to turn the table 90 degree.
Any one has good solution?
Thanks ...
Wed, 17 Nov 2004 11:12:03 -0800
|
Skip DTS steps
Hi
It is possible to make DTS skip a number of steps according to the result of
a query for example:
IF (SELECT *
FROM Modified_sage_tables
WHERE filenme = 'ACCESS1') IS NULL
GOTO "STEP XXXX"
ELSE
GOTO "STEP YYYY"
Where "STEP YYYY" and "STEP XXXX" would be the steps ...
Wed, 17 Nov 2004 17:54:11 -0000
|
Variable database.table access issue
I have a table that I need to reference that is not always in the same
database as all other tables. I have available to me the database name the
table exists in but can't get my sql statement to accept an input parameter
containing the database that I need to join to.
Does anyone know how to structure a ...
Wed, 17 Nov 2004 07:05:03 -0800
|
step dont'execute
I have the following code where I am executing the steps.
My problem is how do I not execute the steps and set the
DTSTaskExecResult as Success?
If DateDiff("h", File.DateLastModified, Now ) <= 24 Then
Set oPackage = DTSGlobalVariables.Parent
oPackage.Steps("DTSStep_DTSExecuteSQLTask_1").Execute
oPackage ...
Wed, 17 Nov 2004 06:54:50 -0800
|
Incremental changes ODBC via DTS
Hi
I currently have a DTS package scheduled to import some data from an odbc
datasource into sql. The problem is that the data needs to be more up to
date. However the import process takes quite some time and during the
updates the data is incomplete or unavailable.
Ideally I would report directly on the ...
Wed, 17 Nov 2004 10:26:42 -0000
|
LoadfromSQLServer hangs at OLAP task
Hi,
I try to load in a ActiveX script a DTS Package containing Analysis Services
Task.
But the "LoadFromSQLServer" command hangs before retrieving the Package
information.
For other DTS Packages the "LoadFromSQLServer" command is working fine.
Thanks for help.
Hermann.
...
Tue, 16 Nov 2004 19:35:22 +0100
|
DTSStepExecResult, DTSStepExecStatus, and execute package task
I have a package with several steps (execute package tasks) which
execute other DTS packages. Attached to each step, I have an ActiveX
workflow script to check the exection of the previous step (the
ultimate purpose will be to act as a failure step and send mail).
This script, as expected, runs prior to the e ...
16 Nov 2004 09:01:22 -0800
|