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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-15 : 08:09:14
|
| Dalveer Singh Marwah writes "Hi,We have written a job to load text file data into files.The step unzip the zip file is executed first using the dts package.Another step will call the dts package which using transformation will extract the txt content in tables.But, when the zip files are extracted, the unzipped text files get's attribute 'E'-encrypted.And when the transformation is about to be performed, dts package throws an error 'Access is denied'.Please let know what can be the issue over here.Regards,Dalveer" |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2005-09-15 : 08:37:42
|
| a) ".....get's attribute 'E'-encrypted"...are they encrypted???b) IF so...unencrypt first....or change attribute in DOS...or request SENDER to send unencrypted files. |
 |
|
|
|
|
|
Job failing while working with zip file