dBase importing was handled by the import/export tool provide with SQL 2000. I see no way to import .dbf files in sql 2005 except to load the sql 2000 tools. I realize that the dbf format is old, but there is still a lot of stuff that comes in dbf and sql2005 needs to support this.
Where can I find an importer for dbf to sql2005?
I keep hearing lots of work arounds but nothing to explain why a common data format can't be easily imported/exported in sql2005 tools. Whats the deal?
also i was wondering, that i have been reading that with this sp2 for sql server 2005 express you are able to use the dts wizard, is this true? i have a few databases in access that i would like to import into sql, would i have to create the tables first in sql then import or will the import also bring the tables & structure in?
I'm really new to the whole database deal (as well as VB.net) - specifically with the capabilities surrounding VB and SQL Server 2005. My question is open to any recommendations...
What I have is an application that a user uses to create 'new' products. They are presented a form to enter the information regarding the product they wish to create. They enter the details of the product and also locate an image that represents the product, too. Currently, this application saves the product information (including binary image data) into a SQL Server 2005 Express Edition database. This application and database reside on a client pc. What I need to do is to be able save updated and newly created product data into a file of some sort. That file will make its way to a memory stick (USB) and then be transported to a 'field' machine. Quite simply, what is the best way to do this? Are there walk-throughs on this sort of thing? The target database is also SQL Server 2005. I thought I'd post this question on here to get the best design ideas... Any help would be greatly appreciated.
may i know where to find more detail like how to importing and exporting data in ms sql server.? Hope can get the more detail about it and also teach me step by step. (hope can include the photo).
Not sure if this is the correct Forum, anyway lemme me know your views. I have SQL Server running in two remote machines (in different geographical locations). I need to import a database from one SQL Server installation to another installation. What is best possible solution:
1) Transfering the .mdf and .ldf file from one installation to another installation
2) Generating the records of all the tables in the database to a common file format CSV and then loading it in destination database. If this is ok then how to generate import and export data using CSV format
I am not quite sure whether it is possible to export a sql table farmat into a , for instance, dbf format table using solely sql statements from my VB application. We know that ACCESS has this profile , however I have no success regarding it for my 7.0 SQL version.
When I right click on a database I don't have Import/Export under tasks. However I do have C:Program FilesMicrosoft SQL Server90DTSBinnDTSWizard.exe installed and can invoke it manually.
What do I need to do to get it to show up in tasks?
This may be a simple question with an obvious answer, but I'm fairly new to databases and I can't seem to find the right procedure.
I created a database on my machine. If I want to copy the information from this database (columns, tables, and entries specifically) from my machine to another SQL server on a different machine, what is the best way to do this without manually re-entering all of the information?
Is there a simple export/import of a database for transferring it from one server to another?
I have a web application I created in asp.net + sql2005 and am deploying a genercized version of it to multiple clients. I have created a script which dynamically generates a database to a server and creates all of the tables, procs, and views. I now need data from the old database, which will be imported into the new database. It's basically default users, lookup values, etc. What are some methods of getting this data out of the old server and into the new server? I was thinking about generating flat files with the data, then writing code to loop through and insert the data, but it seems very tedious. Do I have any other options? I cannot use Backup and Restore because I have no access to the new sql server's filesystem.Thanks.
I'm fairly new to MS SQL & I have a problem copying tables from one d/b to another. When I do an import or export select Copy tables, the tables & the data get transferred, but all the Identities are set to NO. My D/Bs have 188 tables & it's a pain to reset all of them manually.
Is there a setting I don't know about that will transfer the tables & maintain the Identity? (I'm using SQL Server Management Studio 9.0)
I am currently redirecting lookup failures into error tables with ErrorCode and ErrorColumn. It works fine until I want to transfer data into the archived database. The SSIS pacakage generate by SQL Exporting tool is throwing an "duplicate name of 'output column ErrorCode and ErrorColumn" error. This is caused by oledb source error output. The error output automatically add ErrorCode and ErrorColumn to the error output selection and not happy with it.
I think the question is down to "How to importing/exporting data when table contains ErrorCode or ErrorColumn column?"
I have a MSSQL database running on my SQL 2005 server and I want to export the entire contents to a file as SQL statements with INSERT statements. How do I do this?
I've discovered how to export the contents as a flat comma deliminiated file (although only one table at a time) and how to export the CREATE statements in SQL for each table but so far I cannot find a way to just export the entire DB as SQL.
I'm developing a web app in .NET 2.0 using SSRS 2000 and 2005. Some of the reports need to be exported directly to PDF when clicked, but the problem is in the fact that the user must select the parameters from the report manager window.
Is there any way to allow the direct export to PDF when generate is clicked, or to limit the options the user has to export to in the report manager.
P.S. If it is possible, I DO NOT want to accomplish this using code.
Scenario : SQL table has 2 columns SQ1, SQ2 Excel sheet has three columns : EX1, EX2, EX3
SQ1 matches with EX2 SQ2 matches with EX3
I would like to insert the rows where EX1='X'. EX1 is the left most column in th Excel sheet.
Here's what I am trying. Could you suggest any changes/suggestions?
-- Link server logic IF EXISTS (SELECT srv.name FROM sys.servers srv WHERE srv.server_id != 0 AND srv.name = N'Config_spreadsheet_load')EXEC master.dbo.sp_dropserver @server=N'Config_spreadsheet_load', @droplogins='droplogins' GO
--This is the link logic to connect the spreadsheet to the database sys.sp_addlinkedserver 'Config_spreadsheet_load', Excel', 'Microsoft.Jet.OLEDB.4.0', In : @ExcelfileName, 'excel 8.0; IMEX=1; GO
-- Insert Plan Codes, for the column (PLC_NEW_COL) marked as ‘X’ insert into Plan_code (SQ1, SQ2) -- **** How can I have the logic for checking EX1='X' where PLC_NEW_COL like ‘X’ -- Once the data has been created, clean-up
Total SQL newbie here. Hope I'm posting in the correct forum.
I have a Exchange 2003 server that archives all email to a large(55GB) SQL database. I have a situation where I have to export several emails from that database. However at this point I am clueless on how to accomplish this.
I have been able to export to Excel with success. However, here is a big issue
Destination spreadsheets that contain colums. This seems to work OK but what is strange (by design???) is that appearently it reads the first seven or several rows and then determines the data types (numeric or string). Why doesn't it just use the data types from the source fields? If the last row is column headings (strings, such as Jan, Feb, etc) it treats EVERY row data element in the column as string or character data type. Why??? For my testing, I had to put a full row of 0's in my monthly buckets, so the data would be imported as numbers in the spreadsheet, otherwise it was string or charater data type.
Please tell me there is some logical reasoning behind this Excel export "feature". Or is there someting I am missing? I really want the destination Excel spreadsheet to be a template and have formated Title, Headings (different fonts), columns etc. My thinking is that it would just drop the data at the end of the spreadsheet (in this case the first row following the column headings) with the same data types as the fields in the source. I hope I am wrong and there is away to accomplish exporting to Excel as described above. A very simple approach, Microsoft could have possibly taken is have the ability to specify the starting row, column as a propert(ies) in the Excel Destination object / control.
Hi Im using the SQL SERVER MANAGEMENT STUDIO. and when I try try to export the data to excel using the import/export wizard, I get an error saying 'external table is not in the expected format (MICROSOFT JET database engine)' can someone tell me what is this error due to?? Also, please let me know where I can find details about the MS JET database..I hv no idea on that one.
I want to be able to grant the ability to print and export reports in Report Manager to individual users or a group of users. I know I can disable or enable printing and exporting for all users. What I would like to do is create user groups and place everyone who needs to ability to print or export into those groups.
I need advice on how to get data from xml file into the preexisting table. Right now I have a process that scrapes data from the website and generates xml file everyday. I need to get this data into sql table every night and I would like to make this automated process. What do I need to use in sql to accomplish this? It would be great if you can point me to a tutorial or give me few pointers.
I've imported a couple of DTSs from 2k to 2005, now I know that they are stored in MSDB and I know that I need to export them to a file before I can work on them in SSIS.
The problem is:
How do I export them to a flat file?? I've looked everywhere and it's driving me nuts!
Also I can't seem to find out how to delete them either?! I can see the data sotred in the dtspackages90 table but how do I edit/get rid of them.
I am getting an error: "Damage to the file was so extensive that repairs were not possible. Excel attemted to recover your formulas and values, but some data may have been lost or corrupted." in some instances when exporting toexcel.
The report is no different than any othere report. This report uses rectagles and text boxes to control layout with two tables but it's pretty straight forward. This only happens for this particular report when exported only to Excel. I am using SQL2005 SP1.
I tried to export a reort using SQL 2005 Reporting Services. However Iam getting the following log on the screen : [logs After upgrading the SQL 2005 with SP2 ]
Execution 'ssem4cntbzve525531im5aup' cannot be found (rsExecutionNotFound) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: Microsoft.Reporting.WebForms.ReportServerException: Execution 'ssem4cntbzve525531im5aup' cannot be found (rsExecutionNotFound)
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Importing CVS to SQLServer 2005 in a web application: I need to import CSV file to a table. This is a .Net 2.0 web application running in the WebServer which has .Net 2.0 installed. SQL Server 2005 is a database in another machine. What are my options? Would SSIS work in WebServer if no database installed in that machine. Thanks
I am getting a dump of information from SAP into an Excel file. I would like to take this excel file and import the data into a SQL 2005 Express database. Is this possible? Or will I need the full version of SQL to do this?
I have about 50 Excel files from which I have to import data with some transformations to Sql Server. My first approach was to use Excel Source component in a data flow to read the data . However, as it turned out column X in some files was being converted to a DT_NTEXT blob and in other files it was mapped to WSTR. The reason I guess is because column X contained string of varying sizes - some greater than 255 characters while others less than 255 ( max was 3000 ) . My package used a ForEach loop to iterate over all the Excel files in a directory and feed that to the data flow task. I played around with IMEX and TypeGuessRows setting but they didnt help me . In my second approach I used 2 Excel sources ; one set up for the blob type and the other for the string type . I joined them together using a precedence contraint. This worked but I then figured out that there were 2 other columns in my data that exhibited the same behavior. I couldnt continue with the mulitple Excel source approach cause I would then have 8 Excel source components. Finally, I played around with Execute SQL Task . I selected the columns X,Y and Z , initialized 3 variables of type Object , used a ForEach to enumerate over the dataset and feed that to a script component that converted the objects to Strings. This seems to work for all types of data in the mulitple columns.
My question - has anyone encountered such problem ? What was the solution ? Just thought I would share this with the rest of the community. I cant seem to recall what the exact error I was getting ..but it was something like "cant convert long data to string " or something . I also keep getting annoying error icons in my Excel Source components used in the foreach loop. Something to do with acquire connection failed even after I set DelayValidation to "true".
Please help - I am dealing with data transfer from multiple tables to multiple tables - what is the best practice to get this done? So far I have my connection to MySql figured out and I am using a DataReader source to get the data. What is the approriate Data Flow Transformation to pump data into three different tables in MS Sql 2005 database from three different tables in MySlq database? So far I was able to figure out how to do this for one table only...
I am new to DTS 2005; having trouble on how to connect to MS Access to pull data? what kind of connection manager should I use (OLE?) and what specific Data Flow Source type? Please respond.
I need to import csv data into a SQL Server 2005 database using SQL Server Management Studio Express. I can't find any menu options for accomplishing this. Is this a limitation of the Express edition, or am I missing something when I try to find this feature?Thanks for any help provided.
