loading dts package through command line

• rameshkondru

  SSC Enthusiast

  Points: 124

  More actions

  February 10, 2004 at 2:48 am

  #493345

  Hi,

  Can any one explain how to save with SaveToRepository option using transact sql i tried in the following way but it is not wrking out.

  Exec @hr = sp_OAMethod @obj,

  'SaveToRepository',

  @RepositoryServerName = '(local)',

  @RepositoryDatabaseName = 'master'

  @RepositoryUsername = 'SA',

  @RepositoryUserPassword = 'abcd',

  @flags = 256

   

  Thanks

  ramesh