Groups | Blog | Home
all groups > sql server dts > may 2006 >

sql server dts : DTS package won't run


David
5/31/2006 2:44:01 PM
Within Enterprise Manager, I created a DTS package on our database server and
it runs fine from computer 'A'. I then went to computer 'B' to run the same
DTS package that is located on the same database server and only half of the
DTS package runs successfully. 5 of my 10 steps get the message that is like
the following: "Step 'Update_Staging' was not executed". Why is this? What
David
6/1/2006 5:31:02 AM
After I have logging enabled, how do I view the logs?

[quoted text, click to view]
petery NO[at]SPAM online.microsoft.com (
6/1/2006 6:16:53 AM
Hello,

How do you run the package on computer B, do you log on as the same domain
account and use Windows authentication?

You may want to enable dts package logging to see more details about the
issue:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
_dts_pkgmng_6vqr.asp

If you run with same account, it might be some issue on SQL components
installed on computer B.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

petery NO[at]SPAM online.microsoft.com (
6/2/2006 12:00:00 AM
Hello,

You could refer to the following link to view log file:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
_dts_pkgmng_3b1v.asp

If you could not find related information, you may want to log it as txt
file and post back:

HOW TO: Log Data Transformation Services Package Execution to a Text File
http://support.microsoft.com/?id=316043

Best Regards,

Peter Yang
MCSE2000, MCSA, MCDBA
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security

=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
| Thread-Topic: DTS package won't run
| thread-index: AcaFdz5sKgUBOh99QyS0VoNPBJL3/Q==
| X-WBNR-Posting-Host: 162.111.235.16
| From: =?Utf-8?B?RGF2aWQ=?= <dilworth@newsgroups.nospam>
| References: <2AE141B2-AEDE-4769-8C38-91EA978816C5@microsoft.com>
<0hEcAMUhGHA.1740@TK2MSFTNGXA01.phx.gbl>
| Subject: RE: DTS package won't run
| Date: Thu, 1 Jun 2006 05:31:02 -0700
| Lines: 33
| Message-ID: <03262AC6-23C9-47DC-9DBF-76D0D6773E8A@microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
| Newsgroups: microsoft.public.sqlserver.dts
| Path: TK2MSFTNGXA01.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.dts:66246
| NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
| X-Tomcat-NG: microsoft.public.sqlserver.dts
|
| After I have logging enabled, how do I view the logs?
|
[quoted text, click to view]
|
| > Hello,
| >
| > How do you run the package on computer B, do you log on as the same
domain
| > account and use Windows authentication?
| >
| > You may want to enable dts package logging to see more details about
the
| > issue:
| >
| >
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht
| > _dts_pkgmng_6vqr.asp
| >
| > If you run with same account, it might be some issue on SQL components
| > installed on computer B.
| >
| > Best Regards,
| >
| > Peter Yang
| > MCSE2000/2003, MCSA, MCDBA
| > Microsoft Online Partner Support
| >
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| >
| > =====================================================
| >
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| >
| >
|
AddThis Social Bookmark Button