Macro in SSIS, pops up for user name password

• SqlServerLover

  Ten Centuries

  Points: 1348

  More actions

  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

   

• Phil Parkin

  SSC Guru

  Points: 246987

  More actions

  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

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• SqlServerLover

  Ten Centuries

  Points: 1348

  More actions

  August 6, 2019 at 12:13 am

  #3669007

  Thanks. I end up using something else.