Create table from text file, extract data, create new table from extracted data.

Hello all,

Please help...

I have a text file which needs to be created into a table (let's call it DataFile table). For now I'm just doing the manual DTS to import the txt into SQL server to create the table, which works. But here's my problem...

I need to extract data from DataFile table, here's my query:

select * from dbo.DataFile
where DF_SC_Case_Nbr not like '0000%';

Then I need to create a new table for the extracted data, let's call it ExtractedDataFile. But I don't know how to create a new table and insert the data I selected above into the new one.

Also, can the extraction and the creation of new table be done in just one stored procedure? or is there any other way of doing all this (including the importation of the text file)?

Any help would be highly appreciated.

Thanks in advance.select *
INTO ExtractedDataFile
from dbo.DataFile
where DF_SC_Case_Nbr not like '0000%'|||Thanks so much Brett!

I have more question though......

I will be needing to do the importation of text file & extraction of data at least once a month. Then after I import & extract data I will need to append the extracted data into the table ExtractedDataFile. But I will only need to append the data if there is no duplicate DF_SC_Case_Nbr.

Can all this be done in just one stored procedure? How will I do this?

Thanks again.|||What's a duplicate?

Do you have books online?

Open it up, and leave it open...

Look into bcp

Create SSAS cube from ADO MDX cubedef

Hello MDX Gurus!

I have a third party OLAP from which I can extract data in form of a ADO MDX cubedef.

Now I want to create a SSAS cube from it for which SSAS use ADOMD.NET. The object model of the two are slightly different. Does it exist any converter, mapping code or whatever that could help me convert from MDX to ADOMD.NET effortlessly.

Thanks a lot!

Not sure what the question is.

MDX is a multidimensional query language. Similar to SQL query language. ADOMD.NET is object model you use to build client applications to connect to Analysis Server and issue MDX queries.

Hope that helps.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.