Post reply

Macro in SSIS, pops up for user name password

  • August 4, 2019 at 5:04 pm

    #3668642

    Hi Guys,

    I am running a Macro file in SSIS VB script task.

    My macro pulls data from a https url and url requires user name and password.

    My package works fine in visual studio project solution but it pops up to enter user name and password.

    I need to schedule this package to run every 1 min. How can i achieve this?

    Thanks

     

  • August 4, 2019 at 6:30 pm

    #3668647

    Contact the web site admins and ask them, maybe?

    Why not script out the entire thing in VB? What does your macro do?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • August 6, 2019 at 12:13 am

    #3669007

    Thanks. I end up using something else.

Viewing 3 posts - 1 through 2 (of 2 total)

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