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.
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]
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.
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'.
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
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 ( ) * ************************************************** *****************************
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.
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
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
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.
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!
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!
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)
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
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?
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.
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.
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.
//========================= 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 =======================
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
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.
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?
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?
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?
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 :-)
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?
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
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
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).
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....
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?
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.
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. ?¿
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
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?
