Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pazzy11
Posting Yak Master
145 Posts |
 Posted - 2008-05-21 : 10:06:48
|
| I have a problem, something I thought would be simpleis turning out to be a nightmare.I have a table with email info, except the body field just containsa path to a file, I need to extract to a txt file the email info including the body.I thought it would be easy just to use ActiveX transformations, but the best i can do is get the bodies of emails on a separete fileas im not able to use the main destination file of the package in the ActiveX transformation .. it is saying "permission denied" .. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-21 : 10:20:08
|
Seems that the user running the package does not have permission to read and/or write to the folder.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
pazzy11
Posting Yak Master
145 Posts |
Posted - 2008-05-21 : 11:03:25
|
| Yes but if I use a different file name (same folder) I can and do write to this file, it seems it's because it's the same file thats specified as the flat file destination that causes the permission problem. |
|
|
|
|
|
|
Problem ...