Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: SSIS Permission Problem

Started 1 month, 4 weeks ago by vuyiswam
Good Day All I have a Package created and hosted in a Machine(Theresa) that has SQL 2008 and i have my Development Machine(Vuyiswa) that has IIS and am Debugging from the my machine. i have a ASP.NET 2.0 App and am executing a Package that in another machine. The First thing i did was to share a directory where the Packages are stored when i install the packages and supplied "Everyone","ASP....
Site: CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions  CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions - site profile
Forum: Database  Database - forum profile
Total authors: 2 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: codeguru.com

Other posts in this thread:

toddmcdermid replied 1 month, 4 weeks ago
A couple things to change/check: 1. Don' t use mapped drives. Mapped drives aren't restored in a user-profile-less session, regardless of who you're "running as" in ASP.Net. Use UNCs instead. Notes on running SSIS packages remotely: http://msdn.microsoft.com/en-us/library/ms403355.a spx 2. Make sure you have SSIS tools installed on the ASP.Net machine - because that's where you're ...

vuyiswam replied 1 month, 4 weeks ago
Good Day toddmcdermid Thank you for your Reply. toddmcdermid Wrote : 1. Don' t use mapped drives. Mapped drives aren't restored in a user-profile-less session, regardless of who you're "running as" in ASP.Net. Use UNCs instead. Notes on running SSIS packages remotely: http://msdn.microsoft.com/en-us/library/ms403355.a spx The Approach in the Link you gave me is for SQL Job...

 

Top contributing authors

Name
Posts
vuyiswam
2
user's latest post:
SSIS Permission Problem
Published (2009-10-29 01:47:00)
Good Day toddmcdermid Thank you for your Reply. toddmcdermid Wrote : 1. Don' t use mapped drives. Mapped drives aren't restored in a user-profile-less session, regardless of who you're "running as" in ASP.Net. Use UNCs instead. Notes on running SSIS packages remotely: http://msdn.microsoft.com/en-us/library/ms403355.aspx The Approach in the Link you gave me is for SQL Job. Am Creating a Package and running it...
toddmcdermid
1
user's latest post:
SSIS Permission Problem
Published (2009-10-28 10:33:00)
A couple things to change/check: 1. Don' t use mapped drives. Mapped drives aren't restored in a user-profile-less session, regardless of who you're "running as" in ASP.Net. Use UNCs instead. Notes on running SSIS packages remotely: http://msdn.microsoft.com/en-us/library/ms403355.aspx 2. Make sure you have SSIS tools installed on the ASP.Net machine - because that's where you're attempting to execute...

Related threads on "CodeGuru Forums - A Developer.com Community for C++, C#, VB, Java and .NET Solutions":

Related threads on other sites:

Thread profile page for "SSIS Permission Problem" on http://www.codeguru.com. This report page is a snippet summary view from a single thread "SSIS Permission Problem", located on the Message Board at http://www.codeguru.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity