Advertisement

09.10.2007 at 05:52PM PDT, ID: 22819359
[x]
Attachment Details

Calling SSIS package from ASPX page

Asked by BoggyBayouBoy in MS SQL DTS, C# Programming Language, SQL Server 2005

Tags: ssis, package, calling, from, aspx

After moving my application to IIS (from the VS.NET app server) - I get permissions errors when I call my SSIS package from a static method in one of my C# classes.

Package package = app.LoadPackage("c:/folder/package1.dtsx",null);

The error I get is in the flat file connections.  I'm really unsure which account ASP.net is using to run this code - so for the time being, I've granted full access to the IIS account and ASPNET account - but to no avail.  Can someone assist me thru this sticky deployment issue?

Thanks.Start Free Trial
 
Loading Advertisement...
 
[+][-]09.10.2007 at 07:52PM PDT, ID: 19865631

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.11.2007 at 05:10AM PDT, ID: 19867775

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.17.2007 at 04:22PM PDT, ID: 19909198

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: MS SQL DTS, C# Programming Language, SQL Server 2005
Tags: ssis, package, calling, from, aspx
Sign Up Now!
Solution Provided By: BoggyBayouBoy
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628