.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

SMO.Transfer crash with DtsRuntimeException

Posted By:      Posted Date: October 14, 2010    Points: 0   Category :Sql Server

I am trying to write a method to make a copy of an SQL database so it may be used for testing etc.
I am using VB with .NET 2.0 and SQL Server 2008 Standard Edition. 

What I'm trying to do is:
            Dim connection As New SqlConnection(General.gWorkMandantConnectionString)
            Dim server As New Server(New ServerConnection(connection)) 'the connection seems to work fine

            Dim transfer As New Transfer(server.Databases("Workdef"))
            transfer.CopyAllTables = True
            transfer.CopyData = arguments.data
            transfer.CopySchema = True
            transfer.DestinationServer = server.Name
            transfer.DestinationDatabase = "WorkM" & number.ToString("000")
            transfer.CreateTargetDatabase = True
            transfer.DestinationLogin = "blah"
            transfer.DestinationPassword = "blah"
            transfer.DestinationLoginSecure = False
            transfer.Options.ContinueScriptingOnError = True
            transfer.CopyAllXmlSchemaCollections = False


View Complete Post

More Related Resource Links

HttpContext.Items and Server.Transfer/Execute

The problem was basically that when a Server.Transfer call was applied the script container (and also various ClientScriptProxy script embedding routines) would potentially fail to load up the specified scripts.

Using Conditional Split data Transfer in SSIS 2008

This article uses the Integration Services Conditional Split Data Transformation element to filter and transfer data from a set of flat text files to SQL Server database table. The concept can be easily extended to apply to any other source or destination such as Microsoft Excel. This scenario is useful in creating denormalized database tables in a reporting and analysis situation.

How to transfer files between computer and mobile device using bluetooth

What is Bluetooth? How can I have it on my computer?

Bluetooth wireless technology is a communication technology that allows two devices to communicate wirelessly. Most of the notebooks are nowadays equipped with bluetooth. For those notebooks or computers that don't, you can use a bluetooth dongle to add the functionality and it just costs you around $5. Although higher price range bluetooth dongles are available but it makes no sense of buying them if you just plan to connect your mobile device to the computer. Look for one that has Bluetooth v2.0 + EDR (Enhance Data Rate) supporting speeds of upto 3Mbps and with Vista support. You can easily have one of that kind in just $5.

Setting up bluetooth to work on your computer

Just Insert the bluetooth dongle in the USB.
It should get detected by your Operating System and should be ready to use. In case it is just detected as a new hardware, you need to install drivers for it that came with your bluetooth dongle (You can try Google to find the drivers).
Once drivers are installed, a bluetooth notification icon will appear in your system tray.
Right Click on it to access Settings (This may vary with your bluetooth dongle).
Make sure you have turned Discovery On (It allow others to see your computer).
Switch On the bluetooth on the mobile device.

Cutting Edge: Pros and Cons of Data Transfer Objects


After a brief refresher on procedural and object based patterns for organizing the business logic layer, the author focuses on data transfer objects and the impact they have on the development of the software project.

Dino Esposito

MSDN Magazine August 2009

Crash Course: Analyze Crashes to Find Security Vulnerabilities in Your Apps


Here the authors analyze program crashes to help you understand if you have the potential for read or write violations in your applications, and how they can lead to security vulnerabilities.

A. Abouchaev, D. Hasse, S. Lambert, and G. Wroblewski

MSDN Magazine November 2007

Visual C++ 6.0: Don't Let Memory Allocation Failures Crash Your Legacy STL Application


Most C++ developers make extensive use of the Standard Template Library (STL) in their code. If you are one of them and are using STL and Visual C++ 6.0 directly out of the box, your application is at high risk of crashing under low memory conditions. The problem arises because checking for failure of operator new is such an uncommon practice. To make things worse, when new does fail, the response is not standard. Some language compilers return NULL while others throw an exception.In addition, if you are using STL in an MFC project, be aware that MFC has its own set of rules. This article discusses these problems, explains how the default behavior has changed in Visual C++ .NET 2003, and outlines the changes you must make if you're using Visual C++ 6.0 so that you can safely use the STL when operator new fails.

James Hebben

MSDN Magazine September 2003

BITS: Write Auto-Updating Apps with .NET and the Background Intelligent Transfer Service API


Both the .NET Framework and Windows have some very interesting APIs for creating applications that are capable of updating themselves automatically over a network. There are many advantages to writing your application to update itself like Windows Update does, including convenience for your users, from easier maintenance to network administration. Automatic updates require attention to factors such as discovery, security, and file replacement. In this article, the author covers the BITS API as well as a number of features of the .NET Framework that take care of these facets of auto-updating using the same facilities that the Windows Update uses.

Jason Clark

MSDN Magazine February 2003

Marshalling Your Data: Efficient Data Transfer Techniques Using COM and Windows 2000


The way you choose to transfer data is vitally important in a distributed application. Windows 2000 provides several new features that allow you to transfer data more efficiently. Lightweight handlers allow you to write smart proxies that can cache results and perform buffered reads and writes, minimizing the number of network calls. Windows 2000 also allows you to use pipe interfaces to transfer large amounts of data efficiently through a read-ahead facility. This article illustrates several ways to improve data transfer in Windows 2000 using these new features. It also reports the results of transfer time tests and provides recommendations for transferred buffer sizes.

Richard Grimes

MSDN Magazine September 2000

SharePoint Workspace 2010 Crash



I was redirected from Office forum to here, hope someone can help. The Problem is:


When trying to access certain account in Office SharePoint Workspace 2010, the user gets the following error:

Problem signature:

  Problem Event Name:                        APPCRASH

  Application Name:                             GROOVE.EXE

  Application Version:                    &nb

XBAP causing IE crash?

Our application is a C# XBAP.  Near as I can tell, the problem we are running into seems to be within IE rather than our code, so I tried looking for an appropriate IE forum, but the best I could find was "Internet Explorer Extension Development" and I got no response there, so trying here instead. Our application consists of a main IE instance (which contains the XBAP).  From the C# code in this XBAP, we obtain a reference to the IHtmlWindow2 object.  From that, we periodically call .open(...) to launch various other dialogs of interest to the user.  These dialogs typically contain a fair amount of Javascript as well. Our users began reporting random crashes, some with IE7, some with IE8.  I have been able to recreate a similar crash on my development system (Windows 7, IE8, Visual Studio 2010). Upon crashing, no information is sent to Event Viewer, and nothing is caught by our C# Exception handling either - IE simply exits.  I had to attach a native debugger (rather than managed) to get anything on this.  The debugger gave me the following error: Unhandled exception at 0x61755473 (mshtml.dll) in iexplore.exe: 0xC0000005: Access violation reading location 0xfeeefeee.   The error is apparently occuring in a native thread with the following callstack:      mshtml.dll!CRunPtrBase::SetRun()  + 0x3a b

IIS Crash with Faulting application w3wp.exe, faulting module mscorwks.dll, version 2.0.50727.42

The scenario is that, a .Net Webservice is making calls to C++ DLL (made from VC6 studio) This app works perfectly well for sometimes or over a period or for a high volume of hits and suddenly you see IIS crash along with service crash with the following error "Faulting application w3wp.exe, faulting module mscorwks.dll, version 2.0.50727.42" There is no pattern for this problem. The work around is to restart the IIS.    Can anybody tell me what could be the issue here?

Unexplained Crash on .NET Windows Form, Potentially a Common Crash?

Hi, I have a continuous problem with a .NET Framework 3.5 Windows Form application crashing with the "...this application has performed an illegal error..." error message.  No errors are being caught through a Try-Catch (using a generic Exception, so to my knowledge it should catch any exception?) block throughout the application, so it appears to be something external.  At first we thought it may have been the users computer, but even after a replacement computer the same error continues.   I was just wondering if there are any common crashes which have any hotfixes etc. for .NET Framework 3.5? Or if anyone else has experienced anything similar?   Thanks

How to Rip DVD, Convert Video and Transfer Your Files From ipod to Computer

Are you always afraid of losing or damaging your precious DVD movie collection or want to put them on your computer for more convenient use? Or you prefer to convert video among different video formats or wonderful videos on portable devices such as iPod, iPhone, PSP, Mobile Phone, Zune, Creative Zen, iRiver, Sansa, etc.? Or you need transfer your files on iPod/iPhone to your computer in fear of losing them? Tipard DVD Ripper Pack is such a pupular and useful program that is combined with DVD Rip software, Video Converter and iPod to PC Transfer. It can rip DVD and convert video to MP4, H.264, AVI, MP3, WMV, WMA, FLV, MKV, MPEG-1, MPEG-2, 3GP, 3GPP, VOB, DivX, MOV, RM, RMVB, M4A, AAC, WAV, etc. If you are interested in it, why not have a try?To start it you should free download Tipard DVD Ripper Pack and install it.Note:Shown as the image above, if you want to rip DVD, please select DVD Ripper; convert video select video converter or transfer files select iPod Transfer to PC. Take one piece of them for example.How to Convert video to popular videoAfter you click "Video Converter", another interface appears as follows:Step 1: Add filesClick "Add File" to add your video files.Step 2: Set output video formatClick "Profile" button from the drop-down list to select the output video format such as AVI, MPG, MPEG and WMV. You can click the "Settings&

Sporadic .NET application crash with "Fatal Execution Engine Error"

I have a .NET application that runs for several hours.  It is a multi-threaded app that does some calculations and saves the results to the database.   On one machine in particular, it has been crashing recently with the following exception recorded in the Event Log: .NET Runtime version 2.0.50727.4206 - Fatal Execution Engine Error (6C9D7B6E) (80131506) Faulting application AnalyzerConsole.exe, version, time stamp 0x4c76d28b, faulting module mscorwks.dll, version 2.0.50727.4206, time stamp 0x4bf4c6a7, exception code 0xc0000005, fault offset 0x0011627d, process id 0x%9, application start time 0x%10. Sometimes it runs for hours without crashing, but usually it will crash eventually. I have captured a dump, and this is the call stack: > ntdll.dll!_DbgBreakPoint@0()   mscorwks.dll!WatsonLastChance()  + 0x133 bytes   mscorwks.dll!EEPolicy::LogFatalError()  + 0x23c bytes   mscorwks.dll!EEPolicy::HandleFatalError()  + 0x47 bytes   mscorwks.dll!CLRVectoredExceptionHandlerPhase3()  + 0x10dae2 bytes   mscorwks.dll!CLRVectoredExceptionHandlerPhase2()  + 0x20 bytes   mscorwks.dll!CLRVectoredExceptionHandler()  + 0xb7 bytes   mscorwks.dll!CPFH_RealFirstPassHandler()  + 0x8ac bytes   mscorwks.dll!_COMPlusFrameHandler()  + 0xb9 bytes   ntdll.d

What is the difference between Server.Transfer & response.Redirect()

Hello Friends,This is the very favourate question available on every interview questions site.I have searched for it. But didnt get the satisfactory practical difference between these two.Please show me the difference between this two through a working sample demo.Please ilustrate it through a simple sample.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend