Using LoadFromSQLServer method

#1

Hi,
I am currently using the LoadFromStorageFile method i.e.
myPkg.LoadFromStorageFile DTSPkgFile, "", , ,
DTSGlobalVariables("UploadSubPackageName").Value which works great, however I
would rather use the LoadFromStorageFile method but get various security
errors - any ideas?
Thanks
Paul

#2

What are those "security errors"?

Remember you will need a valid login to the SQL Server which you specify in the method.

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know

On Tue, 30 Aug 2005 09:34:05 -0700, "Paul" <Paul (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Hi,
I am currently using the LoadFromStorageFile method i.e.
myPkg.LoadFromStorageFile DTSPkgFile, "", , ,
DTSGlobalVariables("UploadSubPackageName").Value which works great, however I
would rather use the LoadFromStorageFile method but get various security
errors - any ideas?
Thanks
Paul

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Using LoadFromSQLServer method

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Using LoadFromSQLServer method - 08-30-2005 , 11:34 AM

Re: Using LoadFromSQLServer method - 08-30-2005 , 02:44 PM