SQL Server 2005 does not come with ADO.NET connection so you need to create XSD to load the XML into a XML data flow task then create execute SQL Task...

If permissions is not the issue it may related to the attachement definition in the code. There are two ways to send attachments with...

dmbaker (11/19/2010)

---

I'm not...

Another thing this is the attachment definition not enough to hold large files so change that to NVarchar (max).

@strAttachments [nvarchar](4000)

Matthew Clifford (11/9/2010)

---

If the user is in IIS5 which runs in Win2k trusted for delegation is not valid because Delegation comes with Win2003 some of the reasons creating an account...

Matthew Clifford (10/12/2010)

---

If I remember correctly you need to trust your accout that is running your SQL Service for delegation.

Add your SQL Service Account to SeEnableDelegationPrivilege under user rights.

I...

mytrashcan (11/5/2010)

---

Thanks, but i dont understand what you are telling me.

I am getting this exact message in two environments; first is Vista Home with SQL Express, second is XP with...

mytrashcan (11/5/2010)

---

I am receiving the following message:

Msg 6522, Level 16, State 1, Procedure p_SendEMail, Line 0

A .NET Framework error occurred during execution of user-defined routine or aggregate "p_SendEMail":

System.Security.SecurityException: Request...

amet gbas (11/4/2010)

---

hi..

tested it an get this error while trying to run stored procedure;

Msg 6522, Level 16, State 1, Procedure p_SendEMail, Line 0

A .NET Framework error occurred during execution of...

The net is the great equalizer it is the reason very few code sets impress me because most are modified Microsoft or now Oracle code. I have also met...

christina.sharp (10/27/2010)

---

Make sure the new service account is set up in the Local Security Policies as well (Administrative tools/Local Security Policy/security settings/users right assignment). Another thing to check is the...

Waianapapa (10/1/2010)

---

I was just wondering if anyone else is having trouble opening packages in VS BIDS 2008 on a Windows 7 64-bit machine? If open a package that a co-worker...

DucatiRider (9/23/2010)

---

Hi, I saw this post and am interested in the topic. I 'm a newbie to SSRS and am exploring how I can dynamically change the connection string....

There is code samples you could download and run in the link below, also run a search for prediction modeling for third party implementation...

I think you need to start with your connection string it is saying your application is connecting to the...