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

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

DTS Import/Export

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :Sql Server
i need to import data from dbf to mssql using DTS Import/Export wizard. But there isn't "dBase" selection in DataSource combobox. And i tried to select "Flat File Source", it display error dialog. Plz help me

View Complete Post

More Related Resource Links

sql server 2008 import/export wizard... completely useless??



import/export wizard in 2000 had lots of options.

I could copy databases without a care in the world. Including constraints, stored proc., AND the data, etc.

Now, with v2008, the wizard is dumbed down too much. It's a "stupid" copy function that fails on the first constraint it meets.

"Copy database.." is not an option here: it needs sysadmin on both source and destination server.

Re-adding the constraints manually is not an option either: the database is WAY too large. 

I'm actually hoping there is a temporary bug in the import/export wizard. Each option (and you have THREE...) returns with a new error.

Googling, I found I am not alone:


This post is exactly my situation. Here's what his post says: (bolded key parts)


I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy.

Firstly I created a new empty db on the local machine. Then I scripted the structure of the db on the remote machine and ran the resulting query on the local machin

SSIS Import/Export Wizard: "Unexpected Unrecoverable Error"

For whatever reason, whenever the SSIS Import/Export Wizard needs to display an error message, it throws up "Unexpected Unrecoverable Error" instead. The three buttons - Abort, Retry, and Ignore - all cause the wizard to close. I see some activity in Process Monitor that looks like DTSWizard.exe is probing around for some System.Web assemblies, and not finding them. I'm running 2008 SP1 on Win 7 x86, and I've reinstalled the client tools and Integration Services. Anybody else seen this issue? Should I file a report on Connect?

stsadm export / import custom view / personal view views

Hi, i have to export and import a website with a sharepoint list including all personal views. The personal views are used by the endusers in excel data connections binded to the list.  Loss of personal views during import is not mentioned in the technet discription of export / import command ( http://technet.microsoft.com/en-us/library/cc766807(office.12).aspx  ) I am actually testing the export / import between two site collections, but always losing the personal views (MOSS 2007 with CU April 2010). This discussion had the same topic http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/4e299838-72c2-4f56-8dc3-05ba2a2999d9  but with no definite answer. Please tell me if this is by design or what could cause this behavior. Thanks in advance. Boris Boris Schlotthauer

Import / Export - Workflows

I exported my site, then imported it on a new empty site. Result was unsatisfying by many reasons (which i can overcome postfactum though), but specially - i lost all workflow information. So, can i save workflows during import/export ? PS And is it possible to make 100 % twin site by export/import operations ?

export not compatible with import for null smallints

We have one system that exports a table to a pipe-delimited "|" csv file, and another that reads the csv file into a very similar table. One field in the table(s) is a nullable smallint. When the values in the table are null, SSIS exports to the flatfile as an empty field, just two adjacent separators. When I try to read that file back in, it generates an error, can't convert string to smallint. So, what's up with that? I suppose I can fix this one field, but is this going to be a general problem?  Is there a quick fix other than put in my own transformation? Thanks. Josh  --- oh hey, I think I fixed it!  Well, worked around it anyway.  Went to the source in the dataflow, in the advanced editor changed the output column type to DT_I2.  Now it imports as 0 instead of null.  Hmm, is that good enough?

how can i export/import maintenance plans from 2005 to 2008?

I have this link http://sqlservernewbie.blogspot.com/2008/10/how-to-importexport-sql-server.html However, it is not the solution for me. When I expand SERVERNAME (Integration Services), all I can see it is Running packages and Stored packages, and I cannot expand any deeper. And the scripting way which described in the link above, seems is not finished. It just tells you about the select...JulieShop

Issue with Picture Library Slideshow Web Part after export/import of site collection (SP2010)


I recently exported/imported an SP2010 site collection from Dev to Prod. The site collection had about 90 sites, which were all driven from a site template. Once the export/import had taken place, I created an additional 15 sites (in Prod), using the original site template that was created in the Dev environment. Everything seemed to be working just fine, but I found an issue with the Picture Library Slideshow Web Parts (PLSWP) on all the sites that were created in Prod. Basically, I have a Picture Library, and any pictures added to this library show up in the PLSWP. The original 80 site's PLSWP works fine, but the new 15 sites will not show the pictures through the PLSWP (the viewer just shows up blank). Here is the difference in the html output of the picture viewer:

 PLSWP from Dev:

 <a target="_blank" href="http://forefronttest/realestate/RE/West/HOU/3560/Project%20Pictures/test.jpg" id="MSOPictureLibrarySlideshowWebPart_ctl00_m_g_28b22a62_6d8

Export MySQL and import into CRM


I'd like to export an non-MS MySQL database and re-import it into CRM but I'd like to keep the relationships (foreign keys) between tables in the MySQL database in the CRM system. Does anyone know the best way to do such a thing?


Import and Export data between servers


I hope this is the right place to ask.

I am conencting two different sql server with different IPs. I want to copy some of data from one server table to another server table. I saw from my friend there was Import and Export Data from Tools menu (he said that he added before), he wrote ips and then choose tables and columns ... I couldn't find this right now in Management Studio. Where is it? I anyone can help me, i will be appreciated.


I am using sql server 2005 standart edition



Ahmet UZUN

Site export/import not getting all docs in a library

I am using stsadm to move a site form one site collection to another and for some reason a doc library in the restored site is missing docs. Any thoughts?

Last modified by and last modified date changes after doing stsadm export/import


After doing an stsadm export/import of a document library, all the document modified dates are changed to current date and modified by changed to the person who did the import. How do I retain the last modified dates and modified by values as in the source library? I know we can preserve metatdata using the Manage content and structure GUI and saving as templates, but anyway to do it via stsadm?


Text was truncated with "nvarchar(max)" data type and size by using SSIS Import and Export Wizar



I am using SSIS Import and export Wizar to load data from Excel file, I have set the datatype as "nvarchar(max); those data are not biger than 1000 bits but was failed to transfer as the error says:

[Source - TreatmentPlans$ [1]] Error: The "output column "SchoolPlan" (57)" failed because truncation occurred, and the truncation row disposition on "output column "SchoolPlan" (57)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.

Import and Export List data in excel sheet


Hi ,

I need to import based selective data from excel sheet and export data from sharepoint list, I'm new in Sharepoint.

can anybody guide me? What all possible ways are there and which would be the best.



Import/Export Translations :: Variations 2010


1) Options available [Import/Export] Transaltions in SharePoint 2010. My root site http://Mysite/. is in English. and when I  crated variation heirarchy I got http://Mysite/EN/ and http://Mysite/FR webaddress. Then I created 2 publishing sites under English. Now

a) when I make content changes in English\siteA and click on publish... does it create a new page under French or I need to create new publishing site in French?

b) If do Export of my english\SiteA does the resource file will contain all custom webparts and contents available to change by a transaltor or only standard Transtable columns availble in resource files?

c) When I import the .resx file to French, I need to have similar site exists in french like French\siteA to reflect the changes?

Thanks in advance.

Sharepoint Export Import List Items



My requirement is to export the list items in Pages library with its meta data i.e. Created Time and Modified Time.

I am trying Export Import code, but it does not import time. It imports the CreatedBy and ModifiedBY acuurately but createdTIme and Modified Time comes as current time, the time i run the import.

Pls help


private static void ExportItems()
      string exportFolder = @"C:\exports\";
      string exportFileName = "Export_File.cmp";

      using (SPSite site = new SPSite(sourceSiteUrl))
        using (SPWeb oWeb = site.OpenWeb())
          SPList oList = oWeb.Lists["Pages"];
          SPListItem oItemA = oList.GetItemById(2480);

          SPExportObject exportObject = new SPExportObject();
          exportObject.Id = oItemA.UniqueId;
          exportObject.Type = SPDeploymentObjectType.ListItem;

          SPExportSettings exportSettings = new SPExportSettings();
          exportSettings.LogExportObjectsTable = true;
          exportSettings.LogFilePath = exportFolder + "Exportlog.log";
          exportSettings.SiteUrl = sourceSiteUrl;

SQL Server Import/Export Wizard Crashes


Whenever I try to import or export data using SQL Server Import And Export Wizard, everything is great until I click on the "Finish" button. 

The wizard gets to the "Setting Source Connection" step and at 0% complete, I get the message "SQL Server Import and Export Wizard Has Encountered A Problem And Needs To Close."  This happens every time I run the Wizard, whether it be from SSMS, BIDS, or the file manager.  It doesn't matter what type of database table/file I import to or export from.

If I select to Debug, I get this message:  "Windows Has Triggered A Breakpoint In DTSWizard.exe.  This may be due to a corruption of the heap, and indicates a bug in DTSWizard.exe or any of the DLL's it has loaded.  The output window may have more diagnostic information."  Here is the output:

'DTSWizard.exe': Loaded 'C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSWizard.exe', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\ntdll.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\mscoree.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\kernel32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\advapi32.dll', No symbols loaded.
'DTSWizard.exe': Loaded 'C:\WINDOWS\system32\rpcrt4.dll', No

Import Export Record


Hi Guys

Here is what I need to figure out, any suggestions would really help.  Thanks.

We have a db which is laid like hierachy style, so lets say we have a top level table of object, all other tales begin with an entry from object, so newobject would create an entry in object table and will have its own details, a further table could again be added to the newobject table and use the id from there to link itself to its parent.  Object will link to many other tables that use its ID and inherit properties, you should start to get the picture.

All works fine in NHibernate as its the choice for this project.  Heres where the issue is.

I need to be able to export a reocd from a db, say from newobject into xml this is easy as sql does this with the FOR XML command.

The result I end up with is what I want i.e

select * from object where objectid=1 for xml auto





all good so far

next I do

select * from newobject where objectid=1 for xml auto

again all good and gives me





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