question

apple avatar image
apple asked

DTS runtime error

i! i am getting an error DTS scripttask Runtime error cannot get IIS pickup directory.I am using script task to send email.I would appreciate any help to solve this issue.
dts
3 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Can you provide the following: * version of SQL Server * How you're trying to pick up IIS directory * the exact error message
0 Likes 0 ·
apple avatar image apple commented ·
I am using sql server 2008 r2 this is a script task that has to send email so the variables include from email ,emailserver,to email and includes the reference system.net.email
0 Likes 0 ·
ThomasRushton avatar image ThomasRushton ♦♦ commented ·
So... * how are you trying to get the IIS Pickup Directory? * And what's the full error message? * What *is* the IIS pickup directory (path)? * What credentials does the DTS job run in? (ie what login / user id) * Does that user ID have access to that path?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.