Post reply

Can i run a Access procedure/functions from the sql server.

  • April 12, 2005 at 6:57 am

    #552119

    how can i do it from the dts?

  • April 12, 2005 at 7:29 am

    #552127

    I'm no expert in this but you can use the import wizard to find out how :

    Right click on the db in which you want to import the data

    -- All task

    -- Import data

    -- Next

    Select microsoft access as the source, then enter the path of the db and login info if needed

    then select the target db on sql server

    copy one or more tables or views from the source database

    select which tables you need to transfer.

    then on the bottom of that screen You'll see save teh dts lot, check that option (uncheck the execute immediatly if you don't want to do the transfer)

    enter the dts lot name and password info, next, next

    This will give you a dts package that imports the tables, then you'll see how it's done.

  • April 12, 2005 at 7:32 am

    #552130

    Thanks alot Anyway Its not what i meant

    bye.

  • April 12, 2005 at 10:22 am

    #552181

    Lital,

    What are you trying to do in terms of final results?  What updates do you wish to make to the Access tables? 

    For example are you trying to log the results of an import/export?  Are you generating a reporting database?

    The more info that you can give us the better advice you will recieve!

  • April 12, 2005 at 10:25 am

    #552183

    running internal access function from sql server dts.

  • April 12, 2005 at 11:21 am

    #552191

    We're gonna say this one more time. There's no point in mixing both technologies, you either work from sql server or from access, whereever the data is. There's no point in having the data in access, the macros/functions in access and calling from sql server.

    Can EXPLAIN what you are trying to do and why you think you need to use functions from dts?

  • April 15, 2005 at 2:40 am

    #552872

    Lital,

    Take a look at http://www.sqldts.com/ to see some of the good things that you can do with a DTS job.  You may be able to find something of use. 

    From the little I've read about what you are trying to do, I don't think that there is any reason that your Access macro cannot be converted to a DTS VB Script.

     

Viewing 7 posts - 16 through 21 (of 21 total)

You must be logged in to reply to this topic. Login to reply