data-import

How can I specify a variable file name using SSIS?

I'm a newbie to using SSIS for data imports - I have a couple of files that I want to import into my database schema, but I'm going to need to run this once every 3 months; the file names change based on the quarter e.g. SKU1QTR will become SKU2QTR. How can I handle a situation like this with SSIS? Is there a way to specify the file ...

Importing data from an XML file into R

I want to import an XML file from polarpersonaltrainer.com that stores heartrate data into a R data.frame. Is there a package that makes importing XML easy or do I have to write my own parser? ...

Fastest way to import CSV files in MATLAB

I've written a script that saves its output to a CSV file for later reference, but the second script for importing the data takes an ungainly amount of time to read it back in. The data is in the following format: Item1,val1,val2,val3 Item2,val4,val5,val6,val7 Item3,val8,val9 where the headers are on the left-most column, and the da...

excel to oracle db using VS 2005 C#

I want to build a utility that can import data from excel sheet(columns are fixed but sheets can be any number) to oracle db. Can you suggest how should I: Read excel sheets(n number)?(Best way) Validate data? Bulk insert into DB? My concern is performance here. Each sheet can have 200,000+ rows. PS - please remember I am a complet...

Module or tool for web-based data import and ETL?

I'm going to be adding a feature to a web application that allows users to import data. I don't want to reinvent wheel, so I am looking for any module I could integrate that would handle this. The interface should be similar to that of importing a file into Excel or Access plus some more complex mapping and type conversion functions ...

How to import data with SSIS for sequential guids?

Is there anyway to import data into SSIS where I expect the PKs to be sequential guids? The only method I've been able to come up with so far is to create a temporary table with the column defaulting to newsequentialid() loading the data in there then copying it to the correct table. This isn't very elegant and is somewhat time consumin...

How should I create & map an XML file describing some import data to a DTO?

I have to write a import utility which will import some data held in an xml file. I imagine that I will create a simple DTO object which is the representation of the import data and then write all my code so that it does the import based on this object. The XML file will be the definition of the transfer format, so I expect that 3rd pa...

What is the best 3rd party component for importing flat files using C#?

Just looking for a component that can be programmatically called in a fairly simple way to import a flat file of data. The data is typically 100,000-500,000 rows, each row contains about 200 fields of text anywhere from about 5 to 250 characters long. Data could be CSV, tab-delimited, etc. There is some budget for this, but would like...

Can you automatically create a mysqldump file that doesn't enforce foreign key constraints?

When I run a mysqldump command on my database and then try to import it, it fails as it attempts to create the tables alphabetically, even though they may have a foreign key that references a table later in the file. There doesn't appear to be anything in the documentation and I've found answers like this that say to update the file aft...

import txt files using excel interop in C# (QueryTables.Add)

Hi all, I am trying to insert text files into excel cell using Querytables.Add; no error, but the worksheet is empty. except for the single cell manipulation using Value2 property. I already using macro to record the object used. Can you help me on this(I am using vs2008, C# , excel 2003 and 2007; both shown empty cell). Below is my ...

Import 5 millions records to the rails application

We need to import large amount of data(about 5 millions records) to the postgresql db under rails application. Data will be provided in xml format with images inside it encoded with Base64. Estimated size of the xml file is 40GB. What xml parser can handle such amount of data in ruby? Thanks. ...

Problem with zohmg data import into hbase

Hello, I have used zohmg and successfully created mapper, table in HBase and test-imported my data (using --local switch). But I have problem inserting my data after mapping into HBase, this is error I get: Exception in thread "main" java.lang.RuntimeException: class org.apache.hadoop.hbase.mapreduce.TableOutputFormat not org.apache.had...

import table data to another database in another computer in sql server 2005

i have generated the script and created the schema in my computer. now how can i get the tables data? i dont have enough access in the remote database to copy it. Can it be done using sql server? ...

SQL Server 2008 - Change the MaximumErrorCount or fix the errors.

I am trying to copy all the tables and views from a database on SQL Server 2005 to a database on SQL Server 2008 using the Import data wizard, but after running for some time it just copied 230 tables from 570 tables and views and gave the following warning. Warning 0x80019002: Data Flow Task 46: SSIS Warning Code DTS_W_MAXIMUMERRORC...

Error While Copying database from SQL server 2005 to SQL server 2008 using Import wizard

I am getting the following error when I am trying to copy database and it's getting stopped at this point. Error 0xc0047008: Data Flow Task 46: The package contains two objects with the duplicate name of "output column "ErrorCode" (720)" and "output column "ErrorCode" (737)". Warning 0x80019002: Data Flow Task 46: SSIS Warning Code DTS...

What are some alternatives to using a cursor in SQL Server 2008?

I've been creating imports that use SSIS to import data into a temp table, then using a stored procedure, steps through the data one by one with a cursor to process the data and insert information into 3 different tables. The inserts in the first 2 tables are complicated because if there is a record that already exists with the same dat...

best way to import dataset into matlab and organize data into appropriate structure

Hi, I have a text file of 10001 lines, where first line contains the name of the attributes and the following lines contain values. The attribute types are mixed (strings and floats) and delimited by '\t'. Does anyone know what is the best way to import such text file into matlab and organize these data into appropriate structure for f...

App Engine BadValueError On Bulk Data Upload - TextProperty being construed as StringProperty

bulkoader.yaml: transformers: - kind: ExampleModel connector: csv property_map: - property: __key__ external_name: key export_transform: transform.key_id_or_name_as_string - property: data external_name: data - property: type external_name: type ...

Import selected columns from a CSV files to SQL Server table

Hi, I am trying to import data from a CSV file to a SQL Server 2008 table. Data upload is working, but I want to import only selected columns, not all, and add them to a a new table, of same no. of columns, using the wizard, but its not happening, the wizard is selecting all the columns. So is it possible using wizard that I only impor...

Importing a TXT file to a DataTable so it matches how Excel imports it - C# .NET

I have a txt file, and I can import it into Excel with the following settings perfectly: Type: Delimited Delimiters: TAB Text Qualifier: None I tried loading it into a DataTable by reading the input file into a String[] array, and then splitting that String[] array. However how do you represent a TAB when splitting a string? Is this...