Lookup Failing

Oct 5, 2007



I am getting data from relational DB (RDB); column1 and column2 both type numeric (10,5). Column that I need to look up for Column1 is type string (10) and for Column2 is 2 byte signed integer.
So after I get data from RDB through Ole DB Source I have data conversion.
Column1 is Column1Converted (into string 10) and Column2 into Column2Converted (2 byte signed int)
Lookup is on the same table.
Trouble is following;
When I do this on my local SQL2005 it is all fine.
As soon as I point to another SQL Column1 lookup is failing, column2 is OK.
Error is:
[Lookup 07 1 1 [879]] Error: Row yielded no match during lookup.
I have checked data types for Column1 on my sql and other- all same.
I have a data viewer before lookup- it is there.
Column2 lookup is fine.

Any ideas?

thanks

View 5 Replies


ADVERTISEMENT

Lookup To Catch Failing Rows

Apr 2, 2008

Hi i have a look up from one table to another now i know that some data is set to null in one table and this is the row am doing the lookup on. I'd like the package to run as normal and still catch these failing rows. Is this possible to do ?.

I was trying to set the Configure Error output but i can't get my failing rows to be set to the text file.. the package runs ok But am getting the same problem again in another lookup as am using the same data to do a lookup again and its causing me the same problem.

View 2 Replies View Related

Performance Expectations For Fuzzy Lookup Against 25mill Row Lookup Table

Oct 31, 2007

We did some "at scale" fuzzy lookup tests today and were rather disappointed with the performance. I'm wanting to know your experience so I can set my performance expectations appropriately.

We were doing a fuzzy lookup against a lookup table with 25 million rows. Each row has 11 columns used in the fuzzy lookup, each between 10-100 chars. We set CopyReferenceTable=0 and MatchIndexOptions=GenerateAndPersistNewIndex and WarmCaches=true. It took about 60 minutes to build that index table, during which, dtexec got up to 4.5GB memory usage. (Is there a way to tell what % of the index table got cached in memory? Memory kept rising as each "Finished building X% of fuzzy index" progress event scrolled by all the way up to 100% progress when it peaked at 4.5GB.) The MaxMemoryUsage setting we left blank so it would use as much as possible on this 64-bit box with 16GB of memory (but only about 4GB was available for SSIS).

After it got done building the index table, it started flowing data through the pipeline. We saw the first buffer of ~9,000 rows get passed from the source to the fuzzy lookup transform. Six hours later it had not finished doing the fuzzy lookup on that first buffer!!! Running profiler showed us it was firing off lots of singelton SQL queries doing lookups as expected. So it was making progress, just very, very slowly.

We had set MinSimilarity=0.45 and Exhaustive=False. Those seemed to be reasonable settings for smaller datasets.

Does that performance seem inline with expectations? Any thoughts to improve performance?

View 4 Replies View Related

Fuzzy Lookup Error When Adding Additional Lookup Columns

Sep 26, 2007

I'm working with an existing package that uses the fuzzy lookup transform. The package is currently working; however, I need to add some columns to the lookup columns from the reference table that is being used.

It seems that I am hitting a memory threshold of some sort, as when I add 3 or 4 columns, the package works, but when I add 5 columns, the fuzzy lookup transform fails pre-execute:

Pre-Execute
Taking a snapshot of the reference table
Taking a snapshot of the reference table
Building Fuzzy Match Index
component "Fuzzy Lookup Existing Member" (8351) failed the pre-execute phase and returned error code 0x8007007A.

These errors occur regardless of what columns I am attempting to add to the lookup list.

I have tried setting the MaxMemoryUsage custom property of the transform to 0, and to explicit values that should be much more than enough to hold the fuzzy match index (the reference table is only about 3000 rows, and the entire table is stored in less than 2MB of disk space.

Any ideas on what else could be causing this?

View 4 Replies View Related

Reporting Services :: SSRS Lookup - Can Use More Than One Field When Doing Lookup

Sep 23, 2015

Say I want to lookup a value in another dataset, but there is a grouping that requires you to know what the values for each level is in order to get to the correct detail record.   Can you still use the lookup function with more than one field to compare against? So for example

Department
\___SalesPerson
     \___Measure

I want to be able to add a new row at the Measure level, but lookup each field from another dataset.  In order to do that I will need the Department AND SalesPerson values to do the lookup, but I dont think the Lookup function will let us do that will.

View 2 Replies View Related

Is It Possible To Lookup Value Based On Two Tables Using Lookup Task

Jun 27, 2007

Hi All,

Actually this is in regard to SCD Type 2 Dimension, Scenario is like that I am moving Fact table from some old source and I have dimensionA description value in fact which I want to replace with appropriate id from Dimension Table and that Dimension table is SCD Type 2 based on StartDate and EndDate and Fact Table doesn't contains direct date value rather there is timeId in Fact so to update the value in Fact table I have to Join Time Dimension table and other Dimension Table to replace fact Description with proper Id.



Lets assume DimensionA Structure

id

Description

StartDate

EndDate



Fact Table

id

measure1

measure2

TimeId

Description



Time Dimension

TimeId

Date

Day

Hour ...

View 1 Replies View Related

Row Yielded No Match During Lookup When Using 2 Columns In Lookup

Jul 24, 2007

I am doing a lookup that requires mapping 2 columns in the column mapping section. When I do this, I get the error "Row yielded no match during lookup" . The SQL that I captured in SQL profiler does find the record when I run it in Management Studio. I have already tried trimming everything to no avail.

Why is this happening?



I tried enabling memory restrictions but then I my package hangs and I get a SQLDUMPER_ERRORLOG.log file with the following logged:



07/24/07 13:35:48, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 5952
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0100C5D0
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
07/24/07 13:35:48, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 15 not used
07/24/07 13:35:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
07/24/07 13:35:49, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:Program FilesMicrosoft SQL Server90SharedErrorDumpsSQLDmpr0033.mdmp
07/24/07 13:35:49, ACTION, DtsDebugHost.exe, Watson Invoke: No


Why am I getting this error with "Enable Memory Restriction"?

View 12 Replies View Related

Row Yielded No Match During Lookup While There Is No Row Going Through The Lookup

Sep 29, 2006

Hi all,

I don't understand what's happening here.

I have a Conditional Split with 3 outputs. On the first output I have a lookup, when I execute the package I have 56 rows going through the Conditional Split, all rows are then going to the 2nd and 3rd output but the lookup on the first output generates an error "Row yielded no match during lookup".

I don't understand why the lookup is generating an error while there is no row going through it.

Any idea ?

Sébastien.

View 6 Replies View Related

How To Pick Nearby Text Of Lookup Terms With Help Of Term Extraction/Term Lookup

Oct 4, 2007

I am designing a ssis package,This is intends to mine text data(Data extracted from websites).
Term lookup/Term extraction has been used as tools for mining.
I have lookup terms defined with me for reference table,but the main problem lie in extracting the nearby text/number/charcters to these lookup terms during mining.
For example :
I found noun "Email" 200 (frequency score) times in my text,Now I want to extract nearby email address(this is also true for PhoneNumber,Address attributes also).so how can I achieve this with SSIS.
If u have some idea/suggestion to carry out this challenge with or without Term Extraction/Term Lookup,plz do write here.

View 1 Replies View Related

Bcp Failing

Jan 4, 2001

i ran it from the command prompt. I used my nt account which belongs to the domain admin nt group. my account does have sql access as sa.

also on one of the servers all jobs are failing with the following message - Unable to Connect to Sql Server (local). The nt log records the error that the specific user sqlexec (this is the account on which sql executive runs) is not defined as a valid user of a trusted sql server connection. I am not able to change the security setting on this server using EM nor am i able to use the sql security manager. I get an access denied error. What is the workaround for this problem? Will stopping and restarting the sql service help?
------------

How did you run bcp? In dos prompt or as sql job? Which nt account did you run bcp under? Did you grant sql access for that nt account?


------------
aruna at 1/3/01 4:39:49 PM

Subject:
From:
Date: bcp failing (reply)
Ray Miao ()
1/3/01 4:15:33 PM

yes i did. it still gives me the same error - 18452 error not associated with a trusted connection
-----------------

Did you enable mixed login mode on the server?

------------
aruna at 1/3/01 2:55:59 PM


hello ray

It still does not work. I granted SA rights for the nt group via sql security manager. For one of the servers i get the following error message -
This sql server does not support Windows NT SQL Server Security stored procedures.


--------------
From:
Date: bcp over trusted connections failing (reply)
Ray Miao ()
1/3/01 12:51:50 PM

Use security manager to grant access for nt account.


------------
aruna at 1/3/01 11:59:49 AM

i am attempting to bcp using the -T (trusted connection) option in sql 6.5. the login security mode is set to integrated. the bcp is however failing with msg 18452 error not associated with a trusted connection. why is this happening? i do not want to hardcode the sa password in the bcp command.

thanks

View 1 Replies View Related

Help With Failing Job

May 10, 2006

I have an excutable on the c drive and I have created a job to run that excutable

In the Job
C:Folderjob.exe BA

The job was running until we had a power outage. Now I can get it to run with a scheduled job, the only way I can get it to run is typing it on the command line. I have tried droping and recreating this job but nothing works.

The error is: The stip did not generate any out put.

Do I need to troubleshoot the excutable which is a whole other beast.

Any help would be great.

Thanks

View 4 Replies View Related

SQL Job Failing

Apr 19, 2004

We have a sqljob keep failing if we set the ownership of the job other than 'sa'. Any idea why this fails?

View 6 Replies View Related

Job Failing

Aug 22, 2005

Hi,

View 6 Replies View Related

Job Failing

Apr 9, 2007

I have a scheduled job on a SQL 2000 database which is failing. Here is the error message :



The job failed. Unable to determine if the owner (cacisnasir) of job Integrity Checks Job for DB Maintenance Plan 'IDS' has server access (reason: Could not obtain information about Windows NT group/user 'cacisnasir'. [SQLSTATE 42000] (Error 8198)).



I am the SA on the instance. I wonder why would I be getting this error message? I am able to logon to this instance and browse and change things. So clearly it recognizes me. But when I run the job it fails. Wonder why? my SQL Server version is 8.0.

View 6 Replies View Related

[C#] Failing To Use SCOPY_IDENTITY()

Dec 20, 2004

Dear Reader,

Currently I am building an application for a theme park where I work as a trainee for school, one project for me is to rebuild all the hundreds of databases into a few sql driven application's. Now I got a problem whit the use of SCOPE_IDENTITY(). Because the data has to be correct before inserting it into the database I use the transact features of .NET and I create 1 SQL string wich I dump in that method. The problem is that I can't be able to use the value of SCOPE_IDENTITY() for some reason, maybe you guys see a mistake in the actual (dynamic) query:
Here is the query built up by my program to write the data (of a single form) into the database:

DECLARE @OID int;
INSERT INTO Medisch (med_za_ID, med_WeekNr, med_Enen, med_Bijzonderheden, med_AfwijkendGedrag, med_SexGedrag, med_GemAdemhaling, med_GemHoesten, med_Temperatuur, med_Conditie, med_BloedGeprikt, med_Cupje, med_BasisVis, med_Eetlust, med_GemGewicht)VALUES(3,1123,,'','','',,,,'','False','False',45,'',);
SELECT @OID = SCOPE_IDENTITY();
INSERT INTO Medisch_Medicijnen_Details (mmd_mmt_ID, mmd_med_ID, mmd_Hoeveelheid, mmd_Aantal) VALUES(@OID, 2,23, 23 );

Everything else works unless the SCOPE_IDENTITY() things.
I hope someone can help me out fixing this mistake.
Tnx in advanced,

Grz.
Stefan

View 10 Replies View Related

DTS Failing(very Urgent)

Feb 13, 2002

Sql Guru's,

I have some DTS packages some times failing.one day sucess and next day it's failing. The following error showing.
DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_3 DTSRun OnError: DTSStep_DTSExecuteSQLTask_3, Error = -2147217900 (80040E14) Error string: OLE DB provider 'SQLOLEDB' reported an error. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147217900 (80040E14); Provider Error: 7399 (1CE7) Error string: OLE DB provider 'SQLOLEDB' reported an error. Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error: -2147217900 (80040E14); Provider Error: 7312 (1C90) Error string: [OLE/DB provider returned message: Timeout expired] Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_3 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRu... Process Exit Code 1. The step failed.

Any body help me. This is very urgent

View 2 Replies View Related

Login Failing....

Apr 24, 2001

this is the message that i'm getting and i dont know what to do so that i can access my SQL databases thru cold fusion:

ODBC Error Code = 37000(Syntax error or access violation)

[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

i didnt have any problems with this database until i moved it over to another SQL server and tried the cold fusion front end to it. i dont know what to do now.

View 1 Replies View Related

Who Is Failing SA Login

Feb 16, 2001

I have inherited the task of setting some standards for SQL Server setup and usage in my company. Use of SA with and without a password was rampant. As I get DTS jos and VB code changed to use another account I have been securing the SA account with a password that no one uses. I now get a multitude of failed logins for the SA account on multiple systems by people trying to logon as SA, not jobs. Is there any way to generate an error message that will pass the host PC or server, or network ID of the user trying to login with the SA account?

Thanks in advance.
Bill

View 2 Replies View Related

Scheduled DTS Failing

Mar 6, 2000

When I create a DTS to import data from Visual FoxPro it will work if I run immeadiately, but when I schedule it to run at a specific time it will Fail.
Any ideas why??

Thanks for any input,
Tom

View 1 Replies View Related

Trigger Failing!! I NEED HELP!!!

Dec 29, 2004

HELP!

I have a table with a field called remarks as text field. I have a trigger on it,
"Create Trigger trg_inbox_bess506a_mstr_on_del
On dbo.inbox_bess506a_mstr
For Delete
As
-- 040226, archive inbox to arc
set nocount on
insert into inbox_bess_mstr_arc (
pk_id,
batch_id,
py,
appropriation,
issueFrom,
issueTo,
submitBy,
submitDate,
validID,
validDate,
approveDate,
approveBy,
accountCode,
transType
--remark
)
select
pk_id,
batch_id,
py,
appropriation,
issueFrom,
issueTo,
submitBy,
submitDate,
validID,
validDate,
approveDate,
approveBy,
accountCode,
transType
--remark
from deleted
return



GO"

It fails with an error message:
"Server: Msg 21, Level 22, State 1, Procedure
trg_inbox_bess506a_mstr_on_del,
Line 8
WARNING - Fatal Error 7113 occurred at Dec 22 2004 11:25PM. Please
note the
error and time, and contact your System Administrator."

It's failing on a field with remarks greater than 1885 chars.

When I used a stored procedure to do the same, it worked. Why is the trigger failing now? Is there a limit on size for triggers and not procedures?

THANKS!!!!!!

View 3 Replies View Related

SQL 2000 DTS Failing

Jan 3, 2007

The DTS package would execute and immediately fail. a reboot of this server fixed the problems, but does anyone know how to get more info out of DTS to state why it failed, we have branch on error and NT event log entries, but nothing specific to state why. The 1st task is to assign global variables, but I'm not even sure it got that far.

Obviously the problem is fixed now, but if it happens again, some ideas of how to get data out would be useful.

View 2 Replies View Related

Insert Failing

Jul 10, 2007

Hello I have two tables that have the same data in them but not all the data is in the new table. the old one has 397 more records then the new one and I need to insert that data in the new table but it keeps giving me a primary key violation rule.

SELECT dbo.Revised_MainTable.[IR Number], dbo.Report.[Incident Report No], dbo.Report.Date, dbo.Report.[I/RDocument], dbo.Report.TypeOfIncident
FROM dbo.Revised_MainTable RIGHT OUTER JOIN
dbo.Report ON dbo.Revised_MainTable.[IR Number] = dbo.Report.[Incident Report No]
WHERE (dbo.Revised_MainTable.[IR Number] IS NULL)

Can anyone help me please???

View 14 Replies View Related

ADO Connection Failing

May 5, 2004

Error:
Microsoft OLE DB Provider for SQL Server error '80040e4d'
Login failed for user 'administrator'.
/ssconn.asp, line 12


Code:
oConn.Open "Provider=sqloledb;" & _
"Network Library=DBMSSOCN;" & _
"Data Source=198.107.136.50,1433;" & _
"Initial Catalog=GradeTrax;" & _
"User ID=administrator;" & _
"Password=password"

Your much wanted advice:

View 4 Replies View Related

Script Failing

May 15, 2008

got it, thanks

View 5 Replies View Related

SP Failing As Job Step

Oct 16, 2007

I have a SP that basically copies data from one table to another.
Some of the data could be duplicates and so the SP detects any primary
key violations (error 2627) and if detected uses a random number for
the PK and tries the insert again.

This SP works fine when run manually from Management Studio but when
scheduled as a job step, it fails. From investigation, it seems that
the logic to handle PK violations is being processed but if there are
more than around 16 PK violations in the batch copy, the job step
fails at around the 17th violation insert and fails to process the
rest of the step.

When this happens, as well as seeing the 2627 error logged in the
message field of the job log history, it also records an error code
3621 in the SQL Message ID field of the log with Severity 14.

Does anyone know why this SP should fail as a job? I have checked
permissions and also tried setting the agent login and job owner to
the same account that successfully ran the SP in Mangement Studio but
this also failed.

At present the only way to get this job to run is to set the step
retry attempts to a number greater than the number of fails. Each
time the job is rerun, it will process a certain number before failing
and it only fails after processing a certain number of PK violations.
This work around is fine in a test environment of a few hundred
records but this job needs to process roughly 75,000 records and if all
these happened to be duplicates, it would require over 4500 retries
assuming its fails after every 16 records.

Thanks in advance.

Matt

View 1 Replies View Related

SP Failing As Job Step

Oct 16, 2007

I have a SP that basically copies data from one table to another.
Some of the data could be duplicates and so the SP detects any primary
key violations (error 2627) and if detected uses a random number for
the PK and tries the insert again.

This SP works fine when run manually from Management Studio but when
scheduled as a job step, it fails. From investigation, it seems that
the logic to handle PK violations is being processed but if there are
more than around 16 PK violations in the batch copy, the job step
fails at around the 17th violation insert and fails to process the
rest of the step.

When this happens, as well as seeing the 2627 error logged in the
message field of the job log history, it also records an error code
3621 in the SQL Message ID field of the log with Severity 14.

Does anyone know why this SP should fail as a job? I have checked
permissions and also tried setting the agent login and job owner to
the same account that successfully ran the SP in Mangement Studio but
this also failed.

At present the only way to get this job to run is to set the step
retry attempts to a number greater than the number of fails. Each
time the job is rerun, it will process a certain number before failing
and it only fails after processing a certain number of PK violations.
This work around is fine in a test environment of a few hundred
records but this job needs to process roughly 75,000 records and if all
these happened to be duplicates, it would require over 4500 retries
assuming its fails after every 16 records.

Thanks in advance.

Matt

View 1 Replies View Related

SQL 2000 Job Is Failing

Dec 12, 2007

Job is failing for one DB

I receive below errors

EVENT LOG:

sql server scheduled job 'db name'
(0x5EA2833965097647B1D375899CE3E179)-Status Failed-Invoked on 2007-12-09 00:01-Message: The Job Failed.The job was invoked by schedule1 (sunday 12 am) . The last step to run was step 2(db name)

Job History:

step 1:
Excuted as user NT AUTHORITYSYSTEM. The step succeeded
step 2:
Excuted as user: NT AUTHORITYSYSTEM . Invalid object name '#DiskSize'.[SQL STATE 42S02][Error 208]. The step failed.
step 3:
The job failed. The job was invoked by Schedule 1 (sun 12 am). The last step to run was step 2{db name}

I am new to SQL server, please help?
Thanks in advance

View 7 Replies View Related

Some Jobs Failing In SQL

Dec 20, 2007

I was hoping if someone can help me shed some light on the following error messages -

Some of the billing jobs in SQL are failing, here is the message from application log - This is happening on the production server.

"SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan3'' (0x8BCD2C33DF5EC447BC7F1228E2C455E4) - Status: Failed - Invoked on: 2007-12-20 06:00:01 - Message: The job failed. The Job was invoked by Schedule 54 (Schedule 1). The last step to run was step 1 (Step 1)."

Has anyone seen this message before, whats a way to fix this issue.

Nishi

View 2 Replies View Related

Backup Job Is Failing

Dec 24, 2007

Backup job for User databases is failing.
I found below errors
View job history

Step 0:
The job failed. The job was invoked by schedule 4(DBMP_User). The last step to run was step 1(subplan)
Step 1:

Message: Executed as user ServernameSystem. The package execution failed. The step failed


Appln-event log:

SQL server scheduled job DBMP_User failed. Invoked on 2007-12-24 , the job was failed.

Sql server error log

Database backed up. DBname creation,date()time……paged dumped 8434659,first LSN: 21126:101410:48,last LSN :21128:933:1, number of dump devices:1, device information: file=1,type=disk (E:MSSQLBACKUP )
This is an informational message only. No user action is required

Error log:

Date:
Log: SQL Agent (current …)
Message:
(396) An idle CPU condition has not been defined-OnIdle job schedules will have no effect.


Please advice how to proceed?

View 11 Replies View Related

Failing A DTSX

Dec 27, 2007

I have been trying in vain to get a DTSX to return to a vb.net application that it has failed, all i get back is a

ReturnResult = success.

In the dtsx is the following;

Secquence

- Transaction Option set to Required
- FailParentonFaluire set to True
- FailPackageonFaluire set to True
- MaximumErrorCount set to 0

Inside the sequence Container
DataFlowTask
- Transaction Option set to Required
- FailParentonFaluire set to True
- FailPackageonFaluire set to True
- MaximumErrorCount set to 0

ExecuteSQLTask
- Transaction Option set to Required
- FailParentonFaluire set to True
- FailPackageonFaluire set to True
- MaximumErrorCount set to 0


I have run the package from my vb.net application and it runs fine, importing data from a file. I tried running it with a bogus file name that doesnt exsist and it still returned a ReturnResult = success. I need it to return a failed result on any errors, which is what i thought it would do as i have it sey to fail the package on errors throughout each task ... am i missing something ?

View 3 Replies View Related

DTS 2000 Failing

Nov 13, 2007



I have SQL Server 2000 DTS package


There are four task


1. creating a temp table by joing different table on same server server 1.
2. Truncate table on Server 2
3. Transform data from Server 1 to server 2.
4. do update on table in Server 2.


I have full access to server 1 and 2. it works fine for me. When one of our developer, she doesn't have rights on server 1.
whenever she runs dts package it not showing any error but dts successfully completed. but there data is not poluated on server 2.


if she run task by task, task 1 failed reason log in failed, that's is correct that what we expect
but when run as package it is not failing, dts reported success, on popup window shows all task not run


is there any setting that tells DTS to fail if any task is failed. or any form of notification.
we can't use sa for connection, we have to use windows login only, we are looking for a solution that will tell us dts failed.




thanks
Kal

View 1 Replies View Related

Backup Job Failing

Apr 25, 2007

I have an SSIS package that does one simple thing: perform a FULL backup of a database.



I executed this package yesterday at 2:00. The package backs up to four individual files on a network share. The network share is accessible from the SQL Server. THe database in question is 245GB in size.



The package was running fine when I left for the day. When I got in today, there was an error in the SQL Server log:



Error: 3041, Severity: 16, State: 1.


BACKUP failed to complete the command BACKUP DATABASE ServicingODS. Check the backup application log for detailed messages.



Where is this infamous backup application log?!? The Event Viewer says the same thing. Needless to say, the error message is a bit vague.



There were no "issus" overnight (power outages, network issues, etc.)



Anyone have any ideas?



Thanks!

View 5 Replies View Related

Backups Failing

Sep 21, 2007

I set up a full backup maintenance plan for my databases and the database portion of the backup jobs completes successfully, but the transaction log portion successfully backs up master and model, but fails for the other databases with the message:
Backup can not be performed on database 'msdb'. This sub task is ignored.
What's the problem?
Bob

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved