Salutare,

Poate cineva sa ma ajute? incerc sa transfer datele dintr-un fisier dbf (fox Pro) intr-un server sql!

Multumesc anticipat.

ungureandavid:

Salutare,

Poate cineva sa ma ajute? incerc sa transfer datele dintr-un fisier dbf (fox Pro) intr-un server sql!

Multumesc anticipat.

click dreapta pe database / tasks / import data ...

---

Ignat Andrei
http://serviciipeweb.ro/iafblog

Domnule Ignat Andrei,

Multumesc pentru raspunsul dvs.

Am urmarit pasii dvs, dar nu am optiunea IMPORT !

Am doar urmatoarele optiuni

Task ->
             1. Detach ...
             2. Shrink                  ->
             3. Back up...
             4. Restore                ->
             5.Generate scripts

Multumesc!

eu folosesc SSMS2008 Express - tu ce folosesti?

---

Ignat Andrei
http://serviciipeweb.ro/iafblog

Microsoft SQL Server Management Studio Express                        9.00.2047.00
Microsoft Data Access Components (MDAC)                        2000.085.1117.00 (xpsp_sp2_rtm.040803-2158)
Microsoft MSXML                        2.6 3.0 5.0 6.0
Microsoft Internet Explorer                        6.0.2900.2180
Microsoft .NET Framework                        2.0.50727.42
Operating System                        5.1.2600

ok, nu am 2005
dar incearca ceva de genul :

SELECT *
into NewTable
FROM OpenRowSet('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=<cale>/tabela.dbf', 'SELECT * FROM tabela ')

---

Ignat Andrei
http://serviciipeweb.ro/iafblog

am incercat si primesc err asta:

[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver does not support this function]
OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005:   ].
Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL' reported an error. 

cred ca imi lipseste vreun driver din DATASOURCE ODBC

ok, am reusit sa imi instalez sql management 2008, si sa transfer din dbf in sql, si primesc eroarea asta! oare de ce? tabela intradevar e mare 10 500 inreg!

Warning 0x80202066: Data Flow Task 1: Cannot retrieve the column code page info from the OLE DB provider. 

- Validating (Error)
Messages
Warning 0x80202066: Data Flow Task 1: Cannot retrieve the column code page info from the OLE DB provider.  If the component supports the "DefaultCodePage" property, the code page from that property will be used.  Change the value of the property if the current string code page values are incorrect.  If the component does not support the property, the code page from the component's locale ID will be used.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "nume" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "prenume" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "domiciliu" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "epicriza" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "sectia" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "codmed" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "medic" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "compet" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc02020f4: Data Flow Task 1: The column "recomand" cannot be processed because more than one code page (1250 and 1252) are specified for it.
 (SQL Server Import and Export Wizard)
 
Error 0xc004706b: Data Flow Task 1: "component "Destination - pacienti" (73)" failed validation and returned validation status "VS_ISBROKEN".
 (SQL Server Import and Export Wizard)
 
Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
 (SQL Server Import and Export Wizard)
 
Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
 (SQL Server Import and Export Wizard)
 

Salut.

Import and Export Wizard foloseste Integration Services care nu se regaseste in  Sql Express

Mai jos ai o solutie alternativa.

http://anzme.blogspot.com/2008/06/importexport-data-with-sql-server-2005.html

 

Cu respect, Iulian.

 

p_iulian:

Salut.

Import and Export Wizard foloseste Integration Services care nu se regaseste in  Sql Express

Esti sigur ca nu se gaseste in Sql Express 2008 ? Eu cu 2008 Express am reusit sa import din Excel...

---

Ignat Andrei
http://serviciipeweb.ro/iafblog

David se referea la sql2005expres (vezi versiunea scrisa de el mai sus). In sql 2005 nu ai ssis.

In Sql2008 au pus un ssis "light".