Intrebari generale

Re: dbf to sql server

p_iulian — Tue, 10 Mar 2009 12:00:56 GMT

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".

Re: dbf to sql server

ignatandrei — Mon, 09 Mar 2009 21:18:51 GMT

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...

Re: dbf to sql server

p_iulian — Mon, 09 Mar 2009 15:30:40 GMT

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.

Re: dbf to sql server

ungureandavid — Thu, 26 Feb 2009 13:52:01 GMT

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)

Re: dbf to sql server

ungureandavid — Thu, 26 Feb 2009 12:26:08 GMT

cred ca imi lipseste vreun driver din DATASOURCE ODBC

Re: dbf to sql server

ungureandavid — Thu, 26 Feb 2009 12:21:27 GMT

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.

Re: dbf to sql server

ignatandrei — Thu, 26 Feb 2009 12:17:20 GMT

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 ')

Re: dbf to sql server

ungureandavid — Thu, 26 Feb 2009 11:51:19 GMT

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

Re: dbf to sql server

ignatandrei — Thu, 26 Feb 2009 11:41:34 GMT

eu folosesc SSMS2008 Express - tu ce folosesti?

Re: dbf to sql server

ungureandavid — Thu, 26 Feb 2009 11:04:15 GMT

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!

Re: dbf to sql server

ignatandrei — Thu, 26 Feb 2009 10:49:25 GMT

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 ...

dbf to sql server

ungureandavid — Thu, 26 Feb 2009 10:46:02 GMT

Salutare,

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

Multumesc anticipat.