从Visual Studio运行asp.net Web应用程序时，将使用您的帐户激活SSIS程序包，因为该网站在您的登录名下运行.凭据.

但是，当您将网站部署到IIS时，它将在Windows 2003中的网络服务"帐户和Windows XP中的"ASPNET"帐户下运行.因此，您需要提供对SQL Server中这些帐户的访问权限.

When you run your asp.net web application from Visual Studio, SSIS package will be activated using your account as the web site is running under your login credentials.

But when you deploy your web site to IIS, It will run under Network Service account in Windows 2003 and ASPNET account in Windows XP. Therefore you need to provide access to these accounts in SQL Server.