Welcome to Sign in | Help
in Search

executa dts dar schimba automat sursa - SQL Server 2005

Last post 12-11-2008, 4:53 PM by Alex. 20 replies.
Page 2 of 2 (21 items)   < Previous 1 2
Sort Posts: Previous Next
  •  12-11-2008, 10:34 AM 6377 in reply to 6362

    Re: executa dts dar schimba automat sursa - SQL Server 2005

    Alex:

    si am mai gasit si linkul asta

    http://education.sqlfarms.com/education/ShowPost.aspx?PostID=1771

    prin care cu ajutorul lui xp_cmdshell si WHILE pot citi/importa toate dbf-urile dintr-un folder

    alex.

    Asta poti face si cu functia Openrowset.Iti poti face o stocata care sa ia ca parametru numele fisierului.Trebuie sa ai activat la novel de server enable openrowset si enalble opendataspurce asta se poate face si cu sql server surface area configuration


    Secolul XXI ori va fi religios ori nu va fi deloc
  •  12-11-2008, 11:43 AM 6379 in reply to 6377

    Re: executa dts dar schimba automat sursa - SQL Server 2005

    am facut astfel pana la urma:

    declare @var varchar (50)

    set @var = 'dir /B C:\TMP'

    if object_id('tempdb..#tbl_dbf ') is not null drop table #tbl_dbf

    create table #tbl_dbf

    (

    NameDbf varchar (50)

    )

    insert into #tbl_dbf

    exec xp_cmdshell @var

    delete from #tbl_dbf where NameDbf is null

    declare @dbf as varchar (50)

    declare c cursor for

    select replace(NameDbf, '.DBF', '') from #tbl_dbf

    open c

    fetch next from c into @dbf

    while @@fetch_status=0

    begin

    exec Insert_DBF @dbf

    fetch next from c into @dbf

    end

    close c

    deallocate c

    iar procedura Insert_DBF este:

    ALTER PROCEDURE [dbo].[Insert_DBF]

    ( @Fisier varchar(10))

    AS

    DECLARE @SqlToRun NVARCHAR(MAX)

    SET @SqlToRun = N'INSERT INTO Table

    SELECT * 

    FROM OPENROWSET(

    ''MSDASQL'',

    ''Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\TMP\'',

    ''SELECT * FROM ' + @Fisier + ''')'

    exec (@SqlToRun)

    go

    si merge super ok mai trebuie doar sa descoper de ce primesc eroarea:

     Msg 7399, Level 16, State 1, Line 1

    The OLE DB provider "MSDASQL" for linked server "(null)" reported an error. The provider did not give any information about the error.

    Msg 7303, Level 16, State 1, Line 1

    Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".

    si am o banuiala ca este de la un dll si anume sqlunirl.dll pe care l-am inlocuit cu cel de pe o statie pe care tot acest proces merge f bine doar ca nu pot da restart la server decat la noapte ca sa testez daca merge

    multumesc.

    alex.

  •  12-11-2008, 12:30 PM 6380 in reply to 6379

    Re: executa dts dar schimba automat sursa - SQL Server 2005

    Posibil sa ai eroarea aia pentru ca ,contul subcare ruleaza serviciul sql server nu are permisiuni de read in folderul de unde citesti fisierele,verifica asta
    Secolul XXI ori va fi religios ori nu va fi deloc
  •  12-11-2008, 1:28 PM 6381 in reply to 6380

    Re: executa dts dar schimba automat sursa - SQL Server 2005

    are full control

    alex.

  •  12-11-2008, 3:12 PM 6384 in reply to 6381

    Re: executa dts dar schimba automat sursa - SQL Server 2005

    Alex:

    are full control

    alex.

    Eu cand am facut asa ceva am folosit ca oledb provider providerul JET al ACCEului si mi-a mers incearca cu ala vezi ca sunt exmple pe net


    Secolul XXI ori va fi religios ori nu va fi deloc
  •  12-11-2008, 4:53 PM 6391 in reply to 6384

    Re: executa dts dar schimba automat sursa - SQL Server 2005

    aceeasi eroare imi da si daca folosesc

    FROM OPENROWSET(

    'MICROSOFT.JET.OLEDB.4.0',

    'dBase 5.0;DATABASE=D:\TMP',

    'SELECT * FROM R0680507'

    )

    eroare:

    OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)" returned message "Unspecified error".

    Msg 7303, Level 16, State 1, Line 1

    Cannot initialize the data source object of OLE DB provider "MICROSOFT.JET.OLEDB.4.0" for linked server "(null)".

    multumesc.

    alex.

Page 2 of 2 (21 items)   < Previous 1 2
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems