Hejsa,
Jeg har lavet en DTS-package og den virker når jeg kører den pr. håndkraft,
men når den køres af SQL Server Agenten, fejler den.
Det skal også lige siges at jeg har brugt guiden til at oprette en
"standard" vedligeholdelse/backup rutine. Den går heller ikke så godt. Den
kører optimization's men ikke integrity check eller backup (vist fordi
integrity check'et fejlede).
Følgende er i log-filen:
Executed as user: HT-DOMAIN\INTRAB-SQL. ...:
DTSStep_DTSExec uteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExec uteSQLTask_2
DTSRun OnStart: DTSStep_DTSExec uteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExec uteSQLTask_1 DTSRun OnStart: DTSStep_DTSData PumpTask_1
DTSRun OnStart: DTSStep_DTSData PumpTask_3 DTSRun OnError:
DTSStep_DTSData PumpTask_1,
Error = -2147024891 (80070005) Error string: Access is denied.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 1100 Error Detail Records:
Error: -2147024891 (80070005); Provider Error: 0 (0) Error string:
Access is denied. Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context:
1100 Error: -2147024891 (80070005); Provider Error: 0 (0)
Error string: Cannot open a log file of specified name. Access is denied.
Error source: Micr... Process Exit Code 1. The step failed.
Log-fil slut.
Mine "data-sources"/Connections er sat til at bruge sql-server
authentication hvor jeg angiver superbruger navn+kodeord, ikke windows
authentication.
Hvis jeg i SQL-EM kigger lidt på bruger intrab-sql:
Under Security - Logins HT-DOMAIN\intrab-sql:
Faneblad General: Grant Access
Faneblad Server Roles: System Administrators
Faneblad Database Access: checkmark ved Mbestil, user=dbo; database roles
for mbestil = public + db_owner
Jeg har også en smule svært ved at se hvor det fejler, for selv om jeg har
givet de enkelte "steps" i DTS-pakken nogen "gode" navne, så er det stadig
de "gamle" navne der bruges i log-filen.
Det DTS-pakken gør, er at tømme en tabel, derefter (forhåbentlig, jeg synes
ikke det er særligt nemt at sætte rækkefølgen af steps op) hente data fra en
anden SQL-server over i den tomme tabel etc etc.
Er der nogen der har nogen gode ideer ?
/jim 2 3622
Ups.. this isn't a .dk group :-)
Hi,
I made a DTS-package and it works when I execute it manually, but when it is
run by the SQL Server Agent, it fails.
I have use the guide to create a maintenance plan. That doesn't work so good
either. It runs Optimizations, but not integrity checks or backups (probably
because integrity checks failed).
The following from the log file:
Executed as user: HT-DOMAIN\INTRAB-SQL. ...:
DTSStep_DTSExec uteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExec uteSQLTask_2
DTSRun OnStart: DTSStep_DTSExec uteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExec uteSQLTask_1 DTSRun OnStart: DTSStep_DTSData PumpTask_1
DTSRun OnStart: DTSStep_DTSData PumpTask_3 DTSRun OnError:
DTSStep_DTSData PumpTask_1,
Error = -2147024891 (80070005) Error string: Access is denied.
Error source: Microsoft Data Transformation Services (DTS) Package
Help file: sqldts80.hlp Help context: 1100 Error Detail Records:
Error: -2147024891 (80070005); Provider Error: 0 (0) Error string:
Access is denied. Error source: Microsoft Data Transformation
Services (DTS) Package Help file: sqldts80.hlp Help context:
1100 Error: -2147024891 (80070005); Provider Error: 0 (0)
Error string: Cannot open a log file of specified name. Access is denied.
Error source: Micr... Process Exit Code 1. The step failed.
Log-file endeth here.....
My "data-sources"/Connections is set up to use sql-server
authentication where I enter superuser name+password, not windows
authentication.
If I browse around using SQL-EM:
Under Security - Logins HT-DOMAIN\intrab-sql:
Tab General: Grant Access
Tab Server Roles: System Administrators
Tab Database Access: checkmark at Mbestil, user=dbo; database roles
for mbestil = public + db_owner
I also have som problems identifying where the package fails. I have given
the individual "steps"/"transformation s" some pretty good names, but in the
log-file it still shows the "old" names.
The DTS package empties a table, then fills it by copying data from another
table in another database on another server.
Anyone with some useful tips ?
/jim
Jim Andersen wrote: I also have som problems identifying where the package fails. I have given the individual "steps"/"transformation s" some pretty good names, but in the log-file it still shows the "old" names.
Have solved this by using "disconnect ed edit". can change a lot of stuff
there that is inaccessible via the GUI.
And then I found out that the "problem step" (as the only one) was set up to
log any errors to a logfile.txt on the Desktop......
Problem solved.
/jim This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: kakaz |
last post by:
Hi All there!
I am quite new in MS SQL administration so let me explain how it work
on Your instances of SQL Servers.
We have several DTS packages on our server, all of them managed on
some station which have seriously hardvare problem. So we wolud like
to catch two problems at one time and decided to develop systematic
way of DTS...
|
by: Trent |
last post by:
Hello, folks.
I'm searching for some good must-have books on SQL Server DTS. If you
are in the DTS business daily, you probably know which books are good
for DTS. I can browse some online book reviews but they are not all
trustworthy...I trust you better....hihi.
Please do me a favor.
Thanks.
|
by: Geetha |
last post by:
Create a table (each time different table) – we have a DTS to do that
-- 1
There is a fixed delimited text file; we need to Import this file into
the created table above and we have another DTS to do that. –2
We want to combine these two DTS into one.
The problem is when the table does not exist it will not show in the
drop down list for...
|
by: Elaksomfan |
last post by:
Hi,
I am having trouble importing data from an excel spreadsheet into MS
SQL Server 2000 using DTS Wizard. The DTS import process is
successfull, no errors, but only 50 rows of approx. 1500 rows of data
are imported. I tried to remove 20 rows in the excel spreadsheet in
the interval row 0-50. When i later ran the import, only 30 rows were...
|
by: Rysiek |
last post by:
Hi All,
I'm trying to use a mail message DTS in my project. I have got example in vb
6.0.
Dim objPackage As DTS.Package2
Dim objStep As DTS.Step
Dim objTask As DTS.Task
Dim objSendMail As DTS.SendMailTask
Set objStep = objPackage.Steps.New
Set objTask = objPackage.Tasks.New("DTSSendMailTask")
| |
by: RSH |
last post by:
Hi,
I am deep into creating a VB .Net application that basically creates SQL
Server versions of our Access databases and copies over all the data. I
Extracted the VB DTS script and brought it into .Net and got the script to
work copying over a single database. Then I turned it into a much more
dynamic application and it works perfectly...
|
by: chris.feyrer |
last post by:
I need to export data from SQL server 2000 (or SQL server 2005 with a
db connection to the SQL 2000 server) to a DB4 file via DTS.
When I use Windows 2000 server to attempt the export, I keep getting an
error message saying that one of my columns does not exist from the
Server 2000 DTS, and don't even see an option for 2005 DTS export to...
|
by: JCC |
last post by:
Hi all
Could someone help me with the following problem? Hours of googling
yesterday couldn't get me the answer. I'm using SQL 2000 and DTS and
trying to import a huge fixed width text file.
File is >1m rows and >200 columns and is defined by a proprietory (i.e. not
bcp produced) format specification of the form
Name Start ...
|
by: Bill_DBA |
last post by:
I have the following stored procedure that is called from the source of
a transformation in a DTS package. The first parameter turns on PRINT
debug messages. The second, when equals 1, turns on the openning,
fetching, and closing of a cursor. Things are fine if only one of the
two parameters was set to 1.
When run with both parameters...
|
by: othellomy |
last post by:
Why is dts packages out of server 2005? In server 2k they were there
but in 2005 it's gone? I tried to connect to 2k using 2005 client
interface and can't seem to locate the dts packages I seem to notice.
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |