data mining viwer

i want to ask how i can deal with data mining viewr to viwe result

on excel file or on application (get just the chart dynimaclly )

( export or import it )

thanks

Can you please clarify your question?

When browsing existing model using DM Excel add-in you can copy data from viewer to Excel spreadsheet by clicking "Copy to Excel" button. Is this what you are looking for?

(Without add-ins, you can copy viewer data to the clipboard and paste it to other applications such as Excel, Word, notepad etc).

Tatyana

|||first thanks in know after i put the Q about add ins
but without add-ins how i can copy viewer data to the clipboard in dynamic way
not manual

my regards
|||

I will be able to help you better if you tell me more about your scenario and what you are trying to achieve.

Do you have viewer hosted inside your application and you want to get information from the viewer to present it differently?

May be you can call the same store procedures viewers are calling to get the information?

Tatyana

data mining viwer

i want to ask how i can deal with data mining viewr to viwe result

on excel file or on application (get just the chart dynimaclly )

( export or import it )

thanks

Can you please clarify your question?

When browsing existing model using DM Excel add-in you can copy data from viewer to Excel spreadsheet by clicking "Copy to Excel" button. Is this what you are looking for?

(Without add-ins, you can copy viewer data to the clipboard and paste it to other applications such as Excel, Word, notepad etc).

Tatyana

|||first thanks in know after i put the Q about add ins
but without add-ins how i can copy viewer data to the clipboard in dynamic way
not manual

my regards
|||

I will be able to help you better if you tell me more about your scenario and what you are trying to achieve.

Do you have viewer hosted inside your application and you want to get information from the viewer to present it differently?

May be you can call the same store procedures viewers are calling to get the information?

Tatyana

Data migration using Import/export wizard SQL 2000 to SQL 2005

I am trying to import data from SQL 2000 to SQL 2005

The Data schemas are the same in both (tables, relationships, key and triggers).

Using the wizard I am trying to import data from SQL 2000 to SQL 2005. The issue I face is to manage the Idenity columns. I do not want the identity values from the SQL 2000 DB which may be at say 5000, instead I want to use the identity values from the SQL 2005 database which will problably start at 1

Is there a way to do this, should I use a custom query instead of a direct table dump. If using a custom query do I need to just specify a Select query or does it have to be a specific "INSERT INTO Table ..." type query

If I do import the data directly with Identity "ON" how can I advance the identity column value to current +1 on the SQL 2005 table.

Thanks

javahar

You need to ignore the IDENTITY column in the source table. Use a custom query to specify the remaining columns.|||Could you give me diffrent kinds of query of Data migration using DTS package 2000 to 2005.

Data migration using Import/export wizard SQL 2000 to SQL 2005

I am trying to import data from SQL 2000 to SQL 2005

The Data schemas are the same in both (tables, relationships, key and triggers).

Using the wizard I am trying to import data from SQL 2000 to SQL 2005. The issue I face is to manage the Idenity columns. I do not want the identity values from the SQL 2000 DB which may be at say 5000, instead I want to use the identity values from the SQL 2005 database which will problably start at 1

Is there a way to do this, should I use a custom query instead of a direct table dump. If using a custom query do I need to just specify a Select query or does it have to be a specific "INSERT INTO Table ..." type query

If I do import the data directly with Identity "ON" how can I advance the identity column value to current +1 on the SQL 2005 table.

Thanks

javahar

You need to ignore the IDENTITY column in the source table. Use a custom query to specify the remaining columns.|||Could you give me diffrent kinds of query of Data migration using DTS package 2000 to 2005.

Data Management tool for SQL Server 2000

Hi,
We're shopping for a data management tool with the
following core features
- import data from MS Access/MS Excel/CVS to SQL Server
2000
- export data from SQL Server to MS Access/MS Excel/CVS
- Web-based application
- application security for user groups/roles
Do you know/use such product tool?
Thanks in advance for your input.
Tuan
Tuan
You should have a look at myLittleAdmin on
http://www.myLittleTools.net/mla_sql
A free lite version is download-able for your tests.
A live demo is also available on
http://www.myLittleTools.net/livedemo/mla_sql
Best regards
Elian Chrebor
Tuan Le typed:
> Hi,
> We're shopping for a data management tool with the
> following core features
> - import data from MS Access/MS Excel/CVS to SQL Server
> 2000
> - export data from SQL Server to MS Access/MS Excel/CVS
> - Web-based application
> - application security for user groups/roles
> Do you know/use such product tool?
> Thanks in advance for your input.
> Tuan

Data Import/export fails to start

While logged onto an SQL server through enterprise manager, when I select a
database, right click and select import or export nothing happens. No boxes
or errors appear.
If I try it through Tools|Data Transformation Services|Import - I get a MMC
error
Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
ModVer:2000.80.194.0 offset 002606e0
Clicking OK kills MMC
This functionality works if I connect using Remote Desktop.
Any Ideas?
Hi
Apply the same service pack on your client machine as you have on the
server, reboot and see if it still occurs. You don't have any SP's on the
client machine based on the build version of sqldmo.dll.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
news:686D1C15-A11E-4A98-8949-8121E5B0496A@.microsoft.com...
> While logged onto an SQL server through enterprise manager, when I select
> a
> database, right click and select import or export nothing happens. No
> boxes
> or errors appear.
> If I try it through Tools|Data Transformation Services|Import - I get a
> MMC
> error
> Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
> ModVer:2000.80.194.0 offset 002606e0
> Clicking OK kills MMC
> This functionality works if I connect using Remote Desktop.
> Any Ideas?
>
|||Thanks Mike,
That did the trick.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Apply the same service pack on your client machine as you have on the
> server, reboot and see if it still occurs. You don't have any SP's on the
> client machine based on the build version of sqldmo.dll.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
> news:686D1C15-A11E-4A98-8949-8121E5B0496A@.microsoft.com...
>
>

Data Import/export fails to start

While logged onto an SQL server through enterprise manager, when I select a
database, right click and select import or export nothing happens. No boxes
or errors appear.
If I try it through Tools|Data Transformation Services|Import - I get a MMC
error
Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
ModVer:2000.80.194.0 offset 002606e0
Clicking OK kills MMC
This functionality works if I connect using Remote Desktop.
Any Ideas?Hi
Apply the same service pack on your client machine as you have on the
server, reboot and see if it still occurs. You don't have any SP's on the
client machine based on the build version of sqldmo.dll.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
news:686D1C15-A11E-4A98-8949-8121E5B0496A@.microsoft.com...
> While logged onto an SQL server through enterprise manager, when I select
> a
> database, right click and select import or export nothing happens. No
> boxes
> or errors appear.
> If I try it through Tools|Data Transformation Services|Import - I get a
> MMC
> error
> Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
> ModVer:2000.80.194.0 offset 002606e0
> Clicking OK kills MMC
> This functionality works if I connect using Remote Desktop.
> Any Ideas?
>|||Thanks Mike,
That did the trick.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Apply the same service pack on your client machine as you have on the
> server, reboot and see if it still occurs. You don't have any SP's on the
> client machine based on the build version of sqldmo.dll.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
> news:686D1C15-A11E-4A98-8949-8121E5B0496A@.microsoft.com...
>
>

Data Import/export fails to start

While logged onto an SQL server through enterprise manager, when I select a
database, right click and select import or export nothing happens. No boxes
or errors appear.
If I try it through Tools|Data Transformation Services|Import - I get a MMC
error
Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
ModVer:2000.80.194.0 offset 002606e0
Clicking OK kills MMC
This functionality works if I connect using Remote Desktop.
Any Ideas?Hi
Apply the same service pack on your client machine as you have on the
server, reboot and see if it still occurs. You don't have any SP's on the
client machine based on the build version of sqldmo.dll.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
news:686D1C15-A11E-4A98-8949-8121E5B0496A@.microsoft.com...
> While logged onto an SQL server through enterprise manager, when I select
> a
> database, right click and select import or export nothing happens. No
> boxes
> or errors appear.
> If I try it through Tools|Data Transformation Services|Import - I get a
> MMC
> error
> Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
> ModVer:2000.80.194.0 offset 002606e0
> Clicking OK kills MMC
> This functionality works if I connect using Remote Desktop.
> Any Ideas?
>|||Thanks Mike,
That did the trick.
"Mike Epprecht (SQL MVP)" wrote:
> Hi
> Apply the same service pack on your client machine as you have on the
> server, reboot and see if it still occurs. You don't have any SP's on the
> client machine based on the build version of sqldmo.dll.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "TLuebke" <TLuebke@.discussions.microsoft.com> wrote in message
> news:686D1C15-A11E-4A98-8949-8121E5B0496A@.microsoft.com...
> > While logged onto an SQL server through enterprise manager, when I select
> > a
> > database, right click and select import or export nothing happens. No
> > boxes
> > or errors appear.
> >
> > If I try it through Tools|Data Transformation Services|Import - I get a
> > MMC
> > error
> > Details are: AppName mmc.exe AppVer:5.1.2600.2180 Modname:sqldmo.dll
> > ModVer:2000.80.194.0 offset 002606e0
> > Clicking OK kills MMC
> >
> > This functionality works if I connect using Remote Desktop.
> >
> > Any Ideas?
> >
>
>

Data import from oracle to sql server 2000

Hi

I am using sql import/export wizard in server 2000 to import data from oracle. I got an following error when I try to copy a table cross to existing table in sql server with existing data:

Can not insert duplicate key row in object TABLE_NAME with unique index TABLE_NAME_I

Does import funtion in sql server 2000 not allow to overwrite the data? If it does, how to configure it to overwrite the existing records? I try to tick Enable identity insert box but it doesn't work.

Any idea? Please help

Thanks

Li

It does allow to overwrite existing data...

If you are using the wizard...I believe it is 5th window called "select source table and views" click the transform button (...) , another window called "Column mapping and Transformations" will popup where you can choose the option to overwrite the data...

|||

Yes, that's what I have tried to do, but it seems not working.

What I have odne:

In Column mappings and transformation window

select Appending rows to destination table, then choose Enable identity insert.

After I have done that, it still doesn't allow me to overwrite the existing data.

Li

|||

I think that 'Over write existing records' checks for completely duplicate rows. Perhaps you have a rows that have duplicate values in the Unique Index, but other fields are not duplicate, so the import process is trying to import the non-duplicate row.

You need to find and correct the duplicate key values -or remove that column from the import. I recommend importing data into a 'staging' table, then you can easily add a WHERE criteria to the INSERT..SELECT statement that does not attempt to insert the rows with duplicate key values. Then you will have identified the rows that need 'correction' and can take appropriate action.

Data Import & Export Error in DLL

标题: Microsoft SQL Server

由于以下错误，将关闭此向导:

有关帮助信息，请单击: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476

其他信息:

DLL 中出错 (异常来自 HRESULT:0x800401F9 (CO_E_ERRORINDLL)) (Microsoft.SqlServer.DTSRuntimeWrap)

按钮:

确定

Please post you question in english, this is the common language that everybody understand here, thanks.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Data Formating for export

I need to have a date that is exporting as this 2005-05-18 to export as
5/18/2005.
Is there anyway to write this into the query?I figured out my own answer CONVERT(char(10), DATE , 101)
"Diane" wrote:

> I need to have a date that is exporting as this 2005-05-18 to export as
> 5/18/2005.
> Is there anyway to write this into the query?|||convert(varchar(10),'2005-05-18',101)
--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Diane" wrote:

> I need to have a date that is exporting as this 2005-05-18 to export as
> 5/18/2005.
> Is there anyway to write this into the query?