all groups > sql server dts > august 2005 >
You're in the

sql server dts

group:

Using LoadFromSQLServer method



Using LoadFromSQLServer method Paul
8/30/2005 9:34:05 AM
sql server dts: 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
Re: Using LoadFromSQLServer method Allan Mitchell
8/30/2005 8:44:26 PM
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

[quoted text, click to view]
AddThis Social Bookmark Button