Sunday, February 19, 2012

fails using LoadFromSqlServer

hi everyone,

I'm trying to load a dtsx from my front-end app but says the following:

pkg = app.LoadFromSqlServer(ActObject.packageName, "SRVDESASQL2005", "usrSSIS", "ninot", Nothing)

ActObject.packageName = "\SSISdev"

usrSSIS is a sql user which own enough permissions over MSDB

Try returns me: "Specified package could not have been loaded in Sql Server"

Any ideas? I'm stuck.

TIA

ok, works I set this path:"Maintenance Plans\Tru_DevolucionesRecibidas"

but another error raises (there is another post related with) Acquire Connection.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=646743&SiteID=1

Thanks a lot

No comments:

Post a Comment