Assertion Task Or Something Like It

Dec 7, 2006

I am playing around trying to develop a thing in SSIS that would be like an assertion elsewhere -- e.g., test a precondition and raise an exception if the precondition isn't true. I'm posting this to see if folks have already done something like this or have suggestions how to go about it in a semi-general way that could be re-used.

My toy thingamabob right now has the goal of comparing the grand totals for a numeric field in two xml files and raising an exception if they aren't equal. I've implemented it as two XML tasks, each of which uses XSLT to compute the total and post it as a string into a variable, then a script task to convert the string variables into numbers, compare them, and take appropriate action.

chw

View 1 Replies


ADVERTISEMENT

SQL Server Assertion: File: &&<lckmgr.cpp&&>, Line=10846 Failed Assertion

Dec 26, 2006

Now I moved Sql Server 2005 sp1 into production, but I've got so many the following "SQL Server Assertion Failed" exception.

Who can help me? Thanks in advance!

=========== Exception INFO from SQL LOG =====================

=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server
version 9.00.2047.00
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.


Computer type is AT/AT COMPATIBLE.
Bios Version is DELL - 1
Phoenix ROM BIOS PLUS Version 1.10 1.1.0
Current time is 17:27:14 12/25/06.
4 Intel x86 level 6, 1995 Mhz processor (s).
Windows NT 5.2 Build 3790 CSD Service Pack 1.

Memory
MemoryLoad = 52%
Total Physical = 4094 MB
Available Physical = 1963 MB
Total Page File = 5973 MB
Available Page File = 3757 MB
Total Virtual = 2047 MB
Available Virtual = 251 MB
**Dump thread - spid = 63, PSS = 0x713695C0, EC = 0x713695C8
***Stack Dump being sent to F:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump1698.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 12/25/06 17:27:14 spid 63
*
* Location: lckmgr.cpp:10846
* Expression: GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()
* SPID: 63
* Process ID: 5464
*
* Input Buffer 404 bytes -
* 3 ? [SQL SCRIPT OVER HERE]


*
*
* MODULE BASE END SIZE
* sqlservr 01000000 02BCEFFF 01bcf000
* ntdll 7C800000 7C8BFFFF 000c0000
* kernel32 77E40000 77F41FFF 00102000
* MSVCR80 78130000 781CAFFF 0009b000
* msvcrt 77BA0000 77BF9FFF 0005a000
* MSVCP80 7C420000 7C4A6FFF 00087000
* ADVAPI32 77F50000 77FEBFFF 0009c000
* RPCRT4 77C50000 77CEEFFF 0009f000
* USER32 77380000 77411FFF 00092000
* GDI32 77C00000 77C47FFF 00048000
* CRYPT32 761B0000 76242FFF 00093000
* MSASN1 76190000 761A1FFF 00012000
* Secur32 76F50000 76F62FFF 00013000
* MSWSOCK 71B20000 71B60FFF 00041000
* WS2_32 71C00000 71C16FFF 00017000
* WS2HELP 71BF0000 71BF7FFF 00008000
* USERENV 76920000 769E3FFF 000c4000
* opends60 333E0000 333E6FFF 00007000
* NETAPI32 71C40000 71C97FFF 00058000
* SHELL32 7C8D0000 7D0D3FFF 00804000
* SHLWAPI 77DA0000 77DF1FFF 00052000
* IMM32 76290000 762ACFFF 0001d000
* LPK 62D80000 62D88FFF 00009000
* USP10 75490000 754F0FFF 00061000
* comctl32 77420000 77522FFF 00103000
* psapi 76B70000 76B7AFFF 0000b000
* instapi 48060000 48069FFF 0000a000
* sqlevn70 4F610000 4F7A3FFF 00194000
* sqlevn70 00890000 00A23FFF 00194000
* SQLOS 344D0000 344D4FFF 00005000
* rsaenh 33B40000 33B6EFFF 0002f000
* AUTHZ 76C40000 76C53FFF 00014000
* MSCOREE 341E0000 34224FFF 00045000
* ole32 77670000 777A3FFF 00134000
* msv1_0 76C90000 76CB6FFF 00027000
* iphlpapi 76CF0000 76D09FFF 0001a000
* kerberos 34450000 344A7FFF 00058000
* cryptdll 766E0000 766EBFFF 0000c000
* schannel 76750000 76776FFF 00027000
* COMRES 77010000 770D5FFF 000c6000
* XOLEHLP 57B10000 57B15FFF 00006000
* MSDTCPRX 61150000 611C7FFF 00078000
* msvcp60 780C0000 78120FFF 00061000
* MTXCLU 51620000 51638FFF 00019000
* VERSION 77B90000 77B97FFF 00008000
* WSOCK32 71BB0000 71BB8FFF 00009000
* OLEAUT32 77D00000 77D8BFFF 0008c000
* CLUSAPI 51640000 51651FFF 00012000
* RESUTILS 51660000 51672FFF 00013000
* DNSAPI 76ED0000 76EFEFFF 0002f000
* winrnr 76F70000 76F76FFF 00007000
* WLDAP32 76F10000 76F3DFFF 0002e000
* rasadhlp 76F80000 76F87FFF 00008000
* security 51AB0000 51AB3FFF 00004000
* msfte 52320000 52578FFF 00259000
* dbghelp 52580000 52692FFF 00113000
* WINTRUST 76BB0000 76BDAFFF 0002b000
* imagehlp 76C10000 76C38FFF 00029000
* dssenh 52980000 529A3FFF 00024000
* hnetcfg 5F270000 5F2C8FFF 00059000
* wshtcpip 52A10000 52A17FFF 00008000
* NTMARTA 77E00000 77E21FFF 00022000
* SAMLIB 5CCF0000 5CCFEFFF 0000f000
* ntdsapi 766F0000 76704FFF 00015000
* xpsp2res 52B20000 52DE4FFF 002c5000
* CLBCatQ 777B0000 77832FFF 00083000
* sqlncli 52E00000 53021FFF 00222000
* COMCTL32 77530000 775C6FFF 00097000
* comdlg32 762B0000 762F9FFF 0004a000
* SQLNCLIR 53050000 53082FFF 00033000
* msftepxy 53190000 531A4FFF 00015000
* xpsqlbot 55B80000 55B85FFF 00006000
* xpstar90 55A20000 55A67FFF 00048000
* SQLSCM90 55A70000 55A78FFF 00009000
* ODBC32 55A90000 55ACCFFF 0003d000
* BatchParser90 55AD0000 55AEEFFF 0001f000
* ATL80 7C630000 7C64AFFF 0001b000
* odbcint 55F00000 55F16FFF 00017000
* xpstar90 562F0000 56315FFF 00026000
* xplog70 56350000 5635BFFF 0000c000
* xplog70 56370000 56372FFF 00003000
* dbghelp 56500000 56612FFF 00113000
*
* Edi: 532AC278: 0016DFC0 0414E040 521F4040 532ADACD 027D6FA0 0414E3D0
* Esi: 00000000:
* Eax: 532AC15C: 000042AC 00000000 00000000 77E55E02 00000000 7C821B34
* Ebx: 0000003F:
* Ecx: 532AC7CC: 00000000 00010007 00000000 0090008E 0016DFC4 532AC18C
* Edx: 0000003D:
* Eip: 77E55E02: 10C2C95E 90909000 A1649090 00000018 C334408B 891C428B
* Ebp: 532AC1AC: 532AC1F0 02187744 000042AC 00000000 00000000 00000000
* SegCs: 0031001B: 09022800 28000800 08000A02 08022000 20000000 00000902
* EFlags: 00000246:
* Esp: 532AC158: 713695C0 000042AC 00000000 00000000 77E55E02 00000000
* SegSs: 78130023: 00000000 00000000 00000000 00000000 00000000 00000000
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
77E55E02 Module(kernel32+00015E02)
02187744 Module(sqlservr+01187744)
0218B600 Module(sqlservr+0118B600)
0202CCDA Module(sqlservr+0102CCDA)
01590ED5 Module(sqlservr+00590ED5)
021C7486 Module(sqlservr+011C7486)
0165C09E Module(sqlservr+0065C09E)
01468A13 Module(sqlservr+00468A13)
014688D5 Module(sqlservr+004688D5)
01023E34 Module(sqlservr+00023E34)
01C2935A Module(sqlservr+00C2935A)
0121B069 Module(sqlservr+0021B069)
010251BC Module(sqlservr+000251BC)
01025741 Module(sqlservr+00025741)
01023E34 Module(sqlservr+00023E34)
01041DD5 Module(sqlservr+00041DD5)
0103DFD4 Module(sqlservr+0003DFD4)
01006A96 Module(sqlservr+00006A96)
01006BBC Module(sqlservr+00006BBC)
01006DAB Module(sqlservr+00006DAB)
01447562 Module(sqlservr+00447562)
0144859B Module(sqlservr+0044859B)
0144789A Module(sqlservr+0044789A)
01447720 Module(sqlservr+00447720)
781329AA Module(MSVCR80+000029AA)
78132A36 Module(MSVCR80+00002A36)

PSS @0x713695C0
---------------



CSession @0x71368278
--------------------
m_spid = 63 m_cRef = 12 m_rgcRefType[0] = 1
m_rgcRefType[1] = 1 m_rgcRefType[2] = 9 m_rgcRefType[3] = 1
m_rgcRefType[4] = 0 m_rgcRefType[5] = 0 m_pmo = 0x71368040
m_pstackBhfPool = 0x00000000 m_dwLoginFlags = 0x03e0 m_fBackground = 0
m_fClientRequestConnReset = 0 m_fUserProc = -1 m_fConnReset = 0
m_fIsConnReset = 0 m_fInLogin = 0 m_fReplRelease = 0
m_fKill = 0 m_ulLoginStamp = 34123 m_eclClient = 5
m_protType = 5 m_hHttpToken = FFFFFFFF

m_pV7LoginRec
---------------------
00000000: 22010000 02000972 401f0000 00000006 c00e0000 € "......r@...........

00000014: 00000000 e0030000 00000000 00000000 5e000300 € ................^...

00000028: 64000900 76000000 94001c00 cc000b00 e2000000 € d...v...............

0000003C: e2001c00 1a010000 1a010400 57a89cec 1de02201 € ............W.....".

00000050: 00002201 00002201 00000000 0000€ € € € € € € € € € € € € € € .."...".......



CPhysicalConnection @0x71368188
-------------------------------
m_pPhyConn->m_pmo = 0x71368040 m_pPhyConn->m_pNetConn = 0x71368788 m_pPhyConn->m_pConnList = 0x71368260
m_pPhyConn->m_pSess = 0x71368278 m_pPhyConn->m_fTracked = -1 m_pPhyConn->m_cbPacketsize = 8000
m_pPhyConn->m_fMars = 0 m_pPhyConn->m_fKill = 0

CBatch @0x71368A90
------------------
m_pSess = 0x71368278 m_pConn = 0x713689F0 m_cRef = 3
m_rgcRefType[0] = 1 m_rgcRefType[1] = 1 m_rgcRefType[2] = 1
m_rgcRefType[3] = 0 m_rgcRefType[4] = 0 m_pTask = 0x00D947A8


EXCEPT (null) @0x532ABA6C
-------------------------
exc_number = 0 exc_severity = 0 exc_func = 0x023F4C60



Task @0x00D947A8
----------------
CPU Ticks used (ms) = 4 Task State = 2
WAITINFO_INTERNAL: WaitResource = 0x00000000 WAITINFO_INTERNAL: WaitType = 0x0
WAITINFO_INTERNAL: WaitSpinlock = 0x00000000 SchedulerId = 0x3
ThreadId = 0x146c m_state = 0 m_eAbortSev = 0



EC @0x713695C8
--------------
spid = 63 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x40 ec_atomic = 0x4 __fSubProc = 1
ec_dbccContext = 0x00000000 __pSETLS = 0x71368A30 __pSEParams = 0x71368CD0
__pDbLocks = 0x713698B0

SEInternalTLS @0x71368A30
-------------------------
m_flags = 0 m_TLSstatus = 3 m_owningTask = 0x00D947A8
m_activeHeapDatasetList = 0x71368A30 m_activeIndexDatasetList = 0x71368A38


SEParams @0x71368CD0
--------------------
m_lockTimeout = -1 m_isoLevel = 4096 m_logDontReplicate = 0
m_neverReplicate = 0 m_XactWorkspace = 0x062ACC58 m_pSessionLocks = 0x71369AC0
m_pDbLocks = 0x713698B0 m_execStats = 0x0414C8B8 m_pAllocFileLimit = 0x00000000


View 7 Replies View Related

SQL Assertion

Sep 21, 2004

Hey everyone,
I just signed up today as i am new to sql, and have a little problem i was hoping for some feedback.

I have a table called Nurse (see below). Nurse has an attribute called Exp_date which is the expiry date of their license. Their licenses have to be renewed every 2 years so i am trying to write an Assertion to check this (see below). unfortunaltey i am quite new to this and am not sure if it will work. I was wondering if anyone could let me know if it is wrong or if it will work. if it is wrong can i have some suggestions.

here is the Nurse table:
CREATE TABLE Nurse
(
Nurse_ssn varchar(12),
Lic_no varchar(9),
Exp_date date NOT NULL,
CONSTRAINT _PK PRIMARY KEY(Nurse_ssn),
);

here is my assertion to check that the license has been renewed in the last 2 years:CREATE ASSERTION expiry-constraint CHECK
(
SELECT Exp_date
FROM Nurse
((Sysdate - Exp_date)< 2)
);

Not a specific database application; im learning from a text book and im not trying to get this to work on a system, im just doing it on paper. its a question im having trouble with.

anyone help me with that?

Thanks for anyone who is willing to help me...

regards,

mitchell page

regards,

mitchell page

View 2 Replies View Related

Assertion Errors:

Jul 23, 2005

Hi All,I have started getting Assertion Errors in SQL.It appears when I process a cube (Most of the time)Other SQL statements, usually with a join or 6 do the same thing.Whaving a scratch around google, I noticed the most people who getthese errors are using SATA drives. Either RAID or not.Surprise, I am using SATA in RAID 1.Is this a common thing with SATA? I can't go to the pwers that be andsay I need a couple large SCSI drives because I _think_ it's theSATA's.Another very odd thing that happened thismorning was I copied the mdfand ldf files off my machine (About 70GB) and onto the server. attachedthem and SQL was happy.Select Count(*) from aview gave me the count I was expecting.Select * From aview returned no rows. most of the time.I thought I was going mad. F5 works, then it doesn't then it does then,you get the point.Backup and restore seemed better until the errors below started...HELP!!!!ThanksCheers,Crispin17066 :SQL Server Assertion: File:<q:SPHINXNTDBMSstorengdrsinclude
ecord.inl>, line=1447Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.

View 3 Replies View Related

SQL Server Assertion ERROR

Feb 5, 2007

We have a browser based application that is doing some updates on the database. This app was earlier built to run on SQL server 2000 and we are in the process of migrating to SQL server 2005. Until now the application was seamlessly working on the new SQL server 2005 database. I got the following error message on the web when an item was clicked on the web that triggered a set of database updated through our app server. This is first time i am seeing anything like this.

---------------------------
Windows Internet Explorer
---------------------------
Unable to delete the selected items. Warning: Fatal error 3624 occurred at Feb 5 2007 2:34PM. Note the error and time, and contact your system administrator.

A severe error occurred on the current command. The results, if any, should be discarded.

Location: IndexRowScanner.cpp:370
Expression: m_sizeOfBuffer > currentOffset + colLen
SPID: 54
Process ID: 2712
---------------------------
OK
---------------------------

In the beginnning we thought it may be some thing in the app server or the CLR. But when I checked the process ID in the task manager it turned out to be SQL server 2005 process. the SPID was the application servers connection to the database.

This is what I got when i ran the profiler.

SQL Server Assertion: File: <IndexRowScanner.cpp>, line=370 Failed Assertion = 'm_sizeOfBuffer > currentOffset + colLen'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check
the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

Warning: Fatal error 3624 occurred at Feb 5 2007 3:00PM. Note the error and time, and contact your system administrator.

2007-02-05 15:00:23.04 spid54 Error: 3624, Severity: 20, State: 1.
2007-02-05 15:00:23.04 spid54 A system assertion check has failed. Check the SQL Server error log for details

Any clues on what this is all about????

Thanks..

View 7 Replies View Related

Sql Server Assertion - Pretty Urgent.

Oct 4, 2000

Hi,
I am getting many instances of the following error, and I cannot find any documention on it, or how to remedy. Any help/suggestions would be GREATLY appreciated.
Thanks in advance - jason


SQL Server Assertion: File: <xcbmgr.cpp>, line=1299
Failed Assertion = 'pss->IsXcbLocked ()'.
Dump thread - spid = 58, PSS = 0x2e637158, EC = 0x2e637308
Stack Dump being sent to C:MSSQL7logSQL00115.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 10/04/00 16:39:54 spid 58
*
* Input Buffer 42 bytes -
* s e l e c t u i d = N E W I D ( )
*
************************************************** *****************************

View 1 Replies View Related

System Assertion Failed During Restoration

Apr 25, 2008

Hi All,

I am trying to restore sql 2000 database backup on sql 2005. I get below error.

SQL Server Assertion: File: <mdupgrad.cpp>, line = 3342 Failed Assertion = 'f' No object for Index!. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or

Error: 928, Severity: 20, State: 1.

During upgrade, database raised exception 3624, severity 20, state 1, address 000000000247E5A1. Use the exception number to determine the cause

Error: 3624, Severity: 20, State: 1.

I feel this could be due to upgrade from sql 2000 to sql 2005.
I could restore other 2000 databases successfully to 2005. However only this particular database is throwing this error.

Can anyone advise on this please.

Thanks in Advance

Kiran

View 13 Replies View Related

SQL Server File Assertion Error

Nov 23, 2005

Hi,

I keep getting this error

Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 112, PSS = 0x49b051f0, EC = 0x49b05520
*Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0576.txt

Stack Signature for the dump is 0x16F06946

SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.

Error: 3624, Severity: 20, State: 1.

DBCC gives me consistency errors with index id 0.

Restarting the sql server services and the error disappears but then reappears after 2-3 days.

All help is appreciated....

View 5 Replies View Related

Sql Server File Assertion Error

Nov 23, 2005

ask192 writes "Hi,

I keep getting this error

Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid = 112, PSS = 0x49b051f0, EC = 0x49b05520
*Stack Dump being sent to D:Program FilesMicrosoft SQL ServerMSSQLlogSQLDump0576.txt

Stack Signature for the dump is 0x16F06946

SQL Server Assertion: File: <recbase.cpp>, line=1378
Failed Assertion = 'm_offBeginVar < m_SizeRec'.

Error: 3624, Severity: 20, State: 1.

DBCC gives me consistency errors with index id 0.

Restarting the sql server services and the error disappears but then reappears after 2-3 days.

All help is appreciated...."

View 2 Replies View Related

SQL 2005 Sp2a Assertion Failure

Jun 25, 2007

Anyone else seen this specific error message before:

quote:
SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

google gets several hits for a different line number, and different type of lock.

Environment: SQL 2005 Sp2a (3402), 64bit, clustered.

We've had 3 of these today, in a 1h20 minnute period. Apparently, this first raised it's head last friday (3 on friday, 2 on Saturday).
All the same line number. DBCC CheckDB to be run asap (getting approval as we type).

*##* *##* *##* *##*
Chaos, Disorder and Panic ... my work is done here!

View 11 Replies View Related

DBCC And Failed Assertion Errors - HELP!

Jul 20, 2005

Hey all -We are running SQL 2000 with ALL available service packs, etc.applied. We just built a brand new database server, which has dual2Ghz XEONs, 2GB memory, and the following disk configuration:RAID 1 array (2 disks) Operating System Windows Server 2003RAID 1 array (2 disks) Database LogsRAID 10 array (4 disks) Database DataDisks are SATA, with a 3Ware hardware RAID controller. The machineSCREAMS.We run 5 databases on this machine. 2 of these are fairly large (byour standards, anyway). The second largest database (and the busiestand most important) is consistently generating consistency errors thatbring many important queries down. These are almost ALWAYS in theform of index corruption on one single table. The corruption does notnormally occur on other tables, although it DOES happen once in awhile - rarely - on one of the other tables), nor does it EVER occuron any other databases on the server.The corruption seems to happen right in the neighborhood of midnightALMOST every day, give or take a few minutes, but does not seemdirectly associated with any of our MANY scheduled database cleanuptasks (believe me, we've tried desperately to find an associationusing SQL profiler). At midnight, our database traffic is fairly low,so it does not seem associated with a high traffic level.We are using the FULL recovery model, with log backups every 15minutes, and full backups daily at 12:15am. However, the corruptionhappens consistently BEFORE 12:15, like between 11:50pm and 12:10am.The most frustrating thing is, the database can go WEEKS without anycorruption at all, and then it'll go 4 or 5 days in a row with thisstrange corruption stuff.************************************************** ***********************Typical query errors when the corruption exists include:************************************************** ***********************SQL Server Assertion: File:<p:sqltdbmsstorengdrsinclude
ecord.inl>, line=1447Failed Assertion = 'm_SizeRec > 0 && m_SizeRec <= MAXDATAROW'.SQL Server Assertion: File: <recbase.cpp>, line=1378Failed Assertion = 'm_offBeginVar < m_SizeRec'.Server: Msg 3624, Level 20, State 1, Line 7Location: recbase.cpp:1374Expression: m_nVars > 0Connection Broken************************************************** ***********************Most of the responses to this type of issue (failed assertions) on thenewgroups appear to point to hardware failures. However, this isbrand new hardware, AND, it seems to us that if this was a hardwareissue, other databases, tables, and indexes would be affectedrandomly. Isn't that a valid assumption (that if it was hardware,particularly the RAID controller, the corruption would not be in sucha predictable place)? What if we moved the physical database files toanother location on the disk? Would/could that help?If anyone could offer some suggestions as to what may be causing thiscorruption, we would be eternally grateful. It is getting to be areal pain in the A*** to run DBCC CHECKDB with REPAIR_ALLOW_DATA_LOSSevery day or two (it always seems to solve the problem without dataloss, but still...).Again, thanks in advance for your response.Sincerely,Morgan LeppinkJoin Bytes!

View 4 Replies View Related

Periodic SQL Server Assertion Error

Mar 21, 2007

Hello,

Since we started using another sales program (1C Enterprise), SQL Server started "crashing" (connection between our program and SQL Server breaks)
with this assertion error:
Event ID: 17066
SQL Server Assertion: File: <"xrange.cpp">, line=399 Failed Assertion = '0 == pxteRangeHrow->m_pxteFetch'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.

After this error DBCC CHECKDB doesn't find any priblems.

I can't find what exactly causes it, sometimes we get it only once a week, but today I got it four times in a row.

We had the same error on all versions of SQL Server 2005, SQL Server SP1, SQL Server SP1+Hot fixes, etc.

select @@version
Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Feb 10 2007 00:59:02 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

View 11 Replies View Related

SSRS Not Responding ASSERT: Assertion Failed

Oct 12, 2007

Hi all

I am facing this prob with SSRS.
please sugges any solution.

Problem:

I have a few reports deployed on the report server.

When I click them I get the following error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Checking the log file has the following entries

w3wp!processing!1!10/12/2007-17:02:12:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension renderer, DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc, CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, GetReportChunk getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext reportContext, ItemProperties properties, ParameterInfoCollection effectiveParameters, Guid reportId, ClientRequest session, String description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean cachingRequested, Boolean isLinkedReport, Warning[]& warnings, ReportSnapshot& resultSnapshotData, DateTime& executionDateTime, RuntimeDataSourceInfoCollection& alldataSources, UserProfileState& usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderReportAction.Render(String format, String deviceInfo)
Microsoft.ReportingServices.WebServer.ReportExecution2005Impl.InternalRender(String Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.ReportingServices.WebServer.ReportExecutionService.InternalRender(String Format, String DeviceInfo, Stream& Result, String& Extension, String& MimeType, String& Encoding, Warning[]& Warnings, String[]& StreamIds)
Microsoft.Reporting.WebForms.ServerReport.InternalRender(String format, String deviceInfo, String& extension, String& mimeType, String& encoding, String[]& streams, Warning[]& warnings)
Microsoft.Reporting.WebForms.ServerReport.Render(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& extension)
Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension)
Microsoft.Reporting.WebForms.ReportControlSource.RenderReportHTML4(String deviceInfo)
Microsoft.Reporting.WebForms.ReportControl.RenderReport(ReportControlSource controlSource, String instanceIdentifier, String navigationID, ZoomMode zoomMode, Int32 zoomPercent, Int32 pageNumber, String prefix, String searchText, String linkTarget, String replacementRoot, String alertMessage, Int32 searchStartPage, Boolean sizeToContent)
Microsoft.Reporting.WebForms.ReportAreaPage.OnPreRender(EventArgs e)
System.Web.UI.Control.PreRenderRecursiveInternal()
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
System.Web.UI.Page.ProcessRequest()
System.Web.UI.Page.ProcessRequest(HttpContext context)
System.Web.HttpServerUtility.ExecuteInternal(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage, VirtualPath path, VirtualPath filePath, String physPath, Exception error, String queryStringOverride)
System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm, Boolean setPreviousPage)
System.Web.HttpServerUtility.Execute(IHttpHandler handler, TextWriter writer, Boolean preserveForm)
System.Web.HttpServerUtility.Transfer(IHttpHandler handler, Boolean preserveForm)
Microsoft.Reporting.WebForms.ReportAreaPageOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response)
Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

w3wp!library!1!10/12/2007-17:02:12:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., un-named assertion fired for component processing;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details.
w3wp!library!1!10/12/2007-17:02:15:: i INFO: Exception dumped to: C:apps_srvSQL 2005 Analysis ServicesMSSQL.2Reporting ServicesLogFiles flags= ReferencedMemory, AllThreads, SendToWatson



The reportserver also generates SQLDumper log file and a crash dump file

The report executes fine sometime and sometime gives the error mentioned above.
The reportserver at some point in time stopped doing anything.
I tried to delete those reports created I couldn€™t delete one report.
When I try to delete it takes a long time and says request timeout error.

Then I opened the web.config file of reportserver and report manager and just saved it so that the application reloads. And then it worked fine for few moments. I was also able to delete that report which was not getting deleted before. But after some time I again get the assertion failed error.

I have the same reports deployed in another server where they are working fine.
The database is SQL Server 2005 with SP2
How do it solve this problem

View 18 Replies View Related

Run Dts Package From External App Gives Assertion Failed Dialog Box

May 16, 2007

Hello,



To quote my honorable colleague who posted some time ago in this forum "If i'd had any hair left, I'd pull it all out".



I am trying to run package from an external .NET app. The package is stored in the SQL server MSDB with protection level to 'Rely on sql server'

The package uses an environment variable for the configuration dtsconfig file.

I use manageddts to load the package from the sql server

LoadFromSqlServer



When I launch my app from the visual studio environment (in debug mode) I get this error message window:

Assertion Failed

at STrace.ReadTraceValues()

at STrace..cctor()

at ...

at ManagedHelper.GetNextManagedInfo(DTs_M...



This message window comes several times, one after the other. I have to click ignore to continue.

When i run this program from the command line , it runs without this message.

I've already put my package load in a separate function with debuggerstepthroug, but to no avail.

<System.Diagnostics.DebuggerStepThrough()> _

Private Function LoadPkg(ByRef app As Application, ByVal PackageName As String) As Package

Return app.LoadFromSqlServer(PackageName, m_SSISServername _

, "myname", "mypassw", Nothing)

End Function



Is there anything that can be done to avoid these warnings?

View 3 Replies View Related

SQL Server Assertion: File: &<recbase.cpp&>, Line=1374

May 19, 2004

Checkdb reported errors against 1 index on 1 table in a database. When I try and fix the index, I get the message 'SQL Server Assertion: File: <recbase.cpp>, line=1374 (s sqldmp file is created). When I tried dropping the index and recreating, this also caused the Failed Assertion message. At this point I could not select any records from the database or copy the database to another source. Everything I tried produced the same error message. I was able to rename the table and recreate the database from another server.

After rebooting the machine, I was able to add an index to the renamed table. I can't find any information to indicate what my problem might be.

Has anyone else seen this behaviour and if so what was the resolution?

View 1 Replies View Related

SQL Server Assertion: File: &&<lckmgr.cpp&&>, Line=10850

Jun 26, 2007

Anyone else seen this specific error message before:


quote:


SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = 'GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'. This error may be timing-related. If the error persists after rerunning the statement, use DBCC CHECKDB to check the database for structural integrity, or restart the server to ensure in-memory data structures are not corrupted.





google gets several hits for a different line number, and different type of lock.

Environment: SQL 2005 Sp2a (3042), 64bit, clustered.

We've had 3 of these Monday, in a 1h20min period. This first raised it's head last friday (3 on friday, 2 on Saturday).
All the same line number.

We failed over, ran DBCC Checkdb no_infomsgs - reported no problems.
restarted SQL on passive node (previously active node that had erported the assertion failures)
Then we had assertion failure on new active node.
ran DBCC CHECKDB , and it also report 0 errors, 0 consistency errors.

Today (Tuesday 26th june) we've had many of these failures - in excess of 20, this morning.



As yet, we can't detect any specific issues in terms of user impact/website. Our concern is whether we are going to have data inconsistencies at some point.... and that locking , if failing, may be causing inaccurate results (depending on the specific locks that fail) - for example stock levels, causing overselling.

View 25 Replies View Related

Assertion Failed Message Loading SSIS Package In Vb.net

Sep 21, 2007

I have SSIS packages created to import .xls files into sql tables. I now have vb.net code within which I am trying to execute individual packages whenever my code notices the .xls files being deposited within a network folder. When I try to run my code I get the error message:

Assertion Failed:Abort=Quit, Retry=Debug, Ignore=Continue
at STrace.ReadTraceValues()
at STrace..cctor()
at STrace.Trace(String strComponentName, String strLine)
at ManagedHelper.GetNextManagedInfo(DTS_Managed_INFO&nextManagedInfo)

here is my code:


Sub RunPackage(ByVal pkgCMD As String)

'

Dim app As New Application

Dim pkg As New Package

Dim pkgResults As DTSExecResult

'Dim pkgevents As IDTSEvents

'

pkg = app.LoadPackage(pkgCMD, Nothing)

pkgResults = pkg.Execute()


The error occurs during the pkg=app.LoadPackage(pkgCMD, Nothing) statement. Any idea of how I determine why the SSIS package will not load thru my vb app? It runs fine if I load the SSIS package in SSBIDS.
Thanks for any help or guidance.

View 6 Replies View Related

Assertion Failed Error While Resizing A Vector In A Plug-in Algorithm

May 1, 2007

I got an Assertion failed error while resizing a vector in a plug-in algorithm.

In order to isolate the problem I created a simple model class in Navigator.h file as shown below:

//========================= begin code =======================

class CStateStats
{
public:
DOUBLE m_dblSum;
DOUBLE m_dblSqrSum;
public:
CStateStats()
{
m_dblSum = 0.0;
m_dblSqrSum = 0.0;
}
};

class CAttStats : public DMHALLOC
{
public:
dmh_vector<CStateStats> vstatestats;
public:
CAttStats() : vstatestats (*this)
{
}
};

//========================= end code =======================



The access to DMHALLOC is provided in that class and in Navigator class as shown below:



//========================= begin code =======================

class ATL_NO_VTABLE NAVIGATOR :

public DMHALLOC,

public CComObjectRootEx<CComMultiThreadModel>,

public CComCoClass<NAVIGATOR, &CLSID_NAVIGATOR>,

public ISupportErrorInfo,

public IDMAlgorithmNavigation

{

public:

NAVIGATOR() : _viAttributeOutput(*this), _vCAttStats(*this)

//========================= end code =======================


I succeded making room for _vCAttStats vector, but when I tried providing room for the vectors of the vector I got an Assertion failed error (file dmhallocator.h Line:56 Expression assert(_dmhalloc._spidmmemoryallocator != NULL)). Please, see the code below, included in NAVIGATOR::GetNodeArrayProperty function:



//========================= begin code =======================

_vCAttStats.resize (2); // <<<<< succeeded here!

// make space for the states

_vCAttStats[0].vstatestats.resize(ulStates); // <<<<<<< assertion failed here!

//========================= end code =======================



I tried using a vector-of-vector approach and I also succeeded.

But I have to use that kind of structure: a vector of class with a vector inside.

I think I must provide a similar approach of vector-of-vector existing in DmhVector.h but I don't know how to do it.

I would apreciate any help.

View 3 Replies View Related

Failed Assertion = &#39;m_activeSdesList.Head () == NULL&#39; (in Combination With Error: 1203)

Jun 6, 2000

On our datawarehouse server we are regularly having a 1203 error, causing the sql-server to hang. We get this message in the errorlog: Failed Assertion = 'm_activeSdesList.Head () == NULL'. In the knowledgebase I found a bug description that is very lookalike to our problem.

Article: Q240853 FIX: Lock Escalation With Parallel Query May Cause 1203 Error And Server Shutdown

*** part of the article ***
SYMPTOMS
If a lock escalation occurs while running a parallel query, it is possible to encounter error message 1203 as follows:

spid7 Process 7 unlocking unowned resource: KEY: 13:117575457:2 (35010560ebcd)
spid7 Process 7 unlocking unowned resource: KEY: 13:117575457:2 (35010560ebcd)
spid7 Error: 1203, Severity: 20, State: 1
spid7 Process ID 7 attempting to unlock unowned resource KEY: 13:117575457:2 (35010560ebcd).
spid7 Error: 1203, Severity: 20, State: 1
spid7 Process ID 7 attempting to unlock unowned resource KEY: 13:117575457:2 (35010560ebcd).

The error message included in the error log probably mentions the same lock resource in several of the error messages.

Once the error is printed, an assertion message similar to the following is also printed:
1999-08-09 13:15:26.79 kernel SQL Server Assertion: File: <proc.c>, line=1866 Failed Assertion = 'm_activeSdesList.Head () == NULL'.
After a dump of the stack for all threads, the server initiates a shutdown of the SQL Server process.
...
*** end ***

You can find the complete article on: http://support.microsoft.com/support/kb/articles/q240/8/53.asp?LN=EN-US&SD=gn&FR=0

We can't use the workaround, because that would shut out parallelism, which is necessary for the project.

There is a fix, but in the article Microsoft says: "A supported fix that corrects this problem is now available from Microsoft, but it has not been fully regression tested and should be applied only to systems experiencing this specific problem.".
You understan,d this is not one of my favorite type of fixes...

Does anyone have already installed the fix mentioned? Had any problems with it, or did it cause some other troubles?

Thx,
Kurt De Cauwsemaecker
Database Administrator
Telepolis Antwerpen

View 1 Replies View Related

Send Mail Task Problem Using A Combination Of ForEach Loop, Recordset Destination, Execute SQL Task And Script Task

Jun 21, 2007

OK. I give up and need help. Hopefully it's something minor ...



I have a dataflow which returns email addresses to a recordset.

I pass this recordset into a ForEachLoop configuring the enumerator as (Foreach ADO Enumerator). I also map the email address as a variable with index 0.



I then have a Execute SQL task which receives this email address as a varchar variable (parameter 0) which I then use in my SQL command to limit the rows returned. I have commented out the where clause and returned all rows regardless of email address to try to troubleshoot this problem. In either event, I then use a resultset to store the query result of type object and result name 0.



I then pass this resultset into a script variable to start parsing the sql rows returned as type object. ( I assume this is the correct way to do this from other prior posts ...).



The script appears to throw an exception at the following line. I assume it's because I'm either not passing in the values properly or the query doesn't return anything. However, I am certain the query works as it executes just fine at the command prompt.



Try

ds = CType(Dts.Variables("VP_EMAIL_RESULTS_RS").Value, DataSet)



My intent is to email the query results to each email address with the following type of data by passing the parsed data from the script to a send mail task. Email works fine and sends out messages but the content is empty. I pass the parsed data as string values to the messagesource and define the messagesourcetype as a variable in the mail task.



part number leadtime

x 5

y 9

....



Does anyone have any idea what I might be doing wrong?

thanks

John

View 5 Replies View Related

Integration Services :: Stored Procedure In Execute Task Fails But Task Does Not Fail

Jul 1, 2015

I'm using SSIS in Visual Studio 2012. My Execute SQL Task calls a Stored Procedure where I have a TRY-CATCH. Last week there was a problem and the CATCH was executed and logged an error to my error table, but for some reason the Execute SQL Task didn't fail. Is there a setting to make the Execute SQL Task fail when an SP encounters a failure?

View 3 Replies View Related

Error: The Task With The Name Data Flow Task And The Creation Name DTS.Pipeline.1 Is Not Registered For Use On This Computer

May 4, 2006



Hi,

I am trying to create a simple BI Application for SSIS. In Visual Studio 2005 I just get a Data Flow Task from the toolbar and add it to the project. When I double click it I get the following error:

The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.1" is not registered for use on this computer.

Then when I try to delete it it gives this other error:

Cannot remove the specified item because it was not found in the specified Collection.

I am creating this application in an administrator account in this computer, so I doubt the problem is related to permissions. I am running SQL Server 2005 and Visual Studio 2005 in WinXP Tablet PC Edition.

Any suggestions why this is happening and how to fix it?

View 17 Replies View Related

SSIS Task Transfer SQL Server Objects Task And Default Constraints On Tables

Feb 21, 2008



I am using the "Transfer SQL Server Objects Task" to copy some tables from database A to database B including data.

The tables, primary key constraints, Foreign key, data and all transfers nicely except for "DEFAULT CONSTRAINTS" on the tables.

I have failed to find any option in the "Transfer SQL Server Objects Task" task to explicitly say "copy default constraints". So I guess logically it should happen automatically but it doesn't. I hope it is not a bug :-)

Any option anyone knows will help.

Thanks.

View 17 Replies View Related

Compare Performance (Execute SQL Task Insert And Data Flow Task)

Mar 12, 2008



I am using SQL 2005 SSIS. I am joining several large tables and then the move result into another table in the same database.

I would like know which method is faster:


Use Execute SQL Task to insert the result set to the target table

Use the Data Flow Task to insert the result set to the target table. (Use OLE DB source to execute SQL command and then use the SQL destination)
Could you tell me why then other is slower?

Thanks.

View 7 Replies View Related

Execute SQL Task – Output Parameter On Stored Procedure Causes Task To Fail.

Dec 2, 2005

I have a SQL Task that calls a stored procedure and returns an output parameter.  The task fails with error "Value does not fall within the expected range."   The Stored Procedure is defined as follows: Create Procedure [dbo].[TestOutputParms]             @InParm INT ,             @OutParm INT OUTPUT as Set @OutParm  = @InParm + 5   The task uses an OLEDB connection and has a source type of Direct Input.  The SQL Statement is Exec TestOutputParms 7, ? output    The parameter mapping is: Variable Name Direction Data Type Parameter Name User::OutParm Output LONG @OutParm  

View 7 Replies View Related

Writing Full Result Set From Execute SQL Task Into A File Using Script Task

Mar 28, 2007

In the Control flow tab, I have an Execute SQL Task that outputs full Result set into a variable of an object type. Now how can I write the contents of the Full Result Set into a text file using Script Task. I also want to format the following way while I output into a file:

Column Name 1 : Column Value

Column Name 2: Column Value and so on

I tried writing the contents of the Object Variable into a file, but the file had an output of single word: System.__ComObject.




Code for Writing the Full Result Set into a Text File

Dim RSsqloutput as String = Dts.Variables("objVariable").Value.ToString

Dim strVal as String = "File completed on " & Now() & vbCrLf & "------------------------------------------------------" & vbCrLf

oLogFile.WriteAllText("C:MyFile.txt", strValue)

oLogFile.WriteAllText("C:MyFile.txt", rsSQLOutput)



I went through this link that explains how to write XML Result Set into a File, But this doesn't help as it writes in XML format.

Would you please give me a hint of code how I can go upon.





View 7 Replies View Related

SSIS (Integration Services) Transfer SQL Server Objects Task: This Task Can Not Participate In A Transaction

Feb 1, 2007

In short, does the €œTransfer SQL Server Objects Task€? support distributed transactions?

In trying to use a €œTransfer SQL Server Objects Task€? in a container using a transaction on the container. The task is set to support the transaction. It is setup to copy table data from several tables from a non-domain server (sql server 2000) to a domain-based server (sql server 2005). I get an error stating, €œThis task can not participate in a transaction€?.

I am wondering if it means exactly what it says €“ this task in SSIS can€™t participate at all. Or does it mean that it won€™t in this scenario for some reason. I attempted a simple copy of data from mssql 2005 to mssql 2005 (same server) and the task still failed). MSDTC appears to be running properly on my machine and such (I can do a simple distributed transaction across linked server to the 2000 server in Query Analyzer (QA)). Also, MSDTC appears to be working on both servers with distributed transaction query tests in QA.

Here€™s the error info€¦

SSIS package "Development BusinessContacts and Products Migration.dtsx" starting.
Information: 0x4001100A at Copy BusinessContacts Data: Starting distributed transaction for this container.
Error: 0xC002F319 at Copy BusinessContacts database table data 1, Transfer SQL Server Objects Task: This task can not participate in a transaction.
Task failed: Copy BusinessContacts database table data 1
Information: 0x4001100C at Copy BusinessContacts database table data 1: Aborting the current distributed transaction.
Information: 0x4001100C at Copy BusinessContacts Data: Aborting the current distributed transaction.
SSIS package "Development BusinessContacts and Products Migration.dtsx" finished: Failure.
The program '[4700] Development BusinessContacts and Products Migration.dtsx: DTS' has exited with code 0 (0x0).

View 9 Replies View Related

How To Fetch The Recrods From MS Access And Using It In Script Task Using Control Flow Tools(Execute SQL Task)

Jun 14, 2006

Hi

I have an application like fetching records from the DataBase(MS Access 2000) and results i have to use in Script Task. At present i have used the record fetching query,connection string in Script itself. I would like to use in Independently. Is there any Tools like (Control Flow Tools like Execute SQL Task) are there to fetch the result set from Acccess and can use the fetching results in Script Task....

Thanks & Regards

Deepu M.I

View 5 Replies View Related

Can A Result Set From SQL Script Task Be Used As A Source For Data Flow Task?

Oct 2, 2007

I have a stored procedure that is executed via a sql script task that returns a full result set. I map this result set to a variable or object type. Is there a way to use this variable as a data source in a subsequent data flow task?

A.

View 14 Replies View Related

How To Enable Or Disable A Task Programmatically Using Script Task

Mar 6, 2006

I have made one package which extracts data from the source does transformation and submits the data to destination. Subsequently it also updates the required control files.

Now I want to add a functionality :

If the package is executed again it should check the status of previous execution in control file if success mark all tasks disable and stop

if failure mark all tasks at enable and start extracting data and continue further with execution.

I was able to attain similar functionality in SQL Server 2000 using activeX script. What code do I need to write as a part of Script Task in order to attain above functionality.

View 3 Replies View Related

Execute DTS 2000 Package Task. Mischievous Task??

Sep 21, 2006



Hi everyone,

For first time I'm testing this task and surprisingly, when I try "Edit Package" option:


1)The DTS host failed to load or save the package properly
2)The selected package cannot be opened
3)Error HRESULT E_FAIL has been returned from a call to a COM component

But after these messages you can see all the tasks but they haven't name!!

It seem as if RCW mechanism has failed between managed and unmanaged coded-partially.

I don't dare to follow doing more stuff, I don't know if that package is well-loaded or not from there. ?¿

Any guidance or idea about this?

View 5 Replies View Related

How Do I Start A Transaction :-Dataflow Task + Excute SQL Task

Mar 7, 2007

1 :Control Flow Excute SQL task: Truncate Table

2: Dataflow Task: Datareader--Script componant--OLE DB Destination (SQL Server 2005--a single table --always around 600,000 rows)

How do I set up a transaction where if there is a failure the Truncate Table command will roll back---and the OLE Destination (A single SQL Server table) will be left the same as before the load started.

Another question with that volume of data --600,000 rows will a truncate table be pratical in a transaction

Any ides welcome

thanks in advance

David

View 3 Replies View Related

File Watcher Task (Konessans) Vs For Each Loop Task

Dec 6, 2007



HI, I need to trigger some packages upon existance of specific files in a particular directory. Sound lkike the file watcher task (from SQLIS) would do the job but I am wondering what is the difference of using this tool instead of a for each loop container. I mean, If a file exists in a directory, the for each loop container will detect it. Since the file watcher is not a service, the package containing it needs to ne scheduled on a regular basis for the filewatcher to detect the file, right? So, a for each loop container would do the job? So, waht wouldbe the advantage of using the file watcher task?

Thank you,
Ccote

View 11 Replies View Related







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