Post reply

Execute sql task

  • January 26, 2011 at 2:35 pm

    #1278804

    keywestfl9 (1/26/2011)

    the machine which is working is not having ssis running only BIDS installed and enterprise edition

    other machine is developer edition and ssis running - this is where it doesn't work.

    What do you mean when you say "ssis running" ? Can you elaborate ?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 26, 2011 at 6:01 pm

    #1278886

    i have just installed tools (BIDS) and not integration service

  • January 26, 2011 at 6:23 pm

    #1278889

    keywestfl9 (1/26/2011)

    i have just installed tools (BIDS) and not integration service

    Then how do you execute SSIS packages on this machine if you don't have integration service installed?

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 27, 2011 at 7:52 am

    #1279087

    thru Bids

  • January 27, 2011 at 8:06 am

    #1279094

    keywestfl9 (1/27/2011)

    thru Bids

    You cannot execute SSIS packages if you don't have the SSIS framework installed. So again I would recommend you compare the versions on both machines and also check if you are using the same ODBC driver versions.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

  • January 27, 2011 at 10:13 am

    #1279201

    i am using same driver (.net) but different edition in machines.

  • January 27, 2011 at 10:15 am

    #1279204

    can you also tell me if i can do the same using script task if so how i do get the reference of teradata driver

  • January 27, 2011 at 1:07 pm

    #1279337

    keywestfl9 (1/27/2011)

    i am using same driver (.net) but different edition in machines.

    Compare the versions of the installed editions.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Viewing 8 posts - 16 through 22 (of 22 total)

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