I changed the package to EncryptAllWithPassword and that worked.

As for the suggestion of using the exact path of the config file, my issue was that the config file was deleted...

Any help would be appreciated. Does anyone have any idea on why this behavior is occurring?

When I run master..xp_cmdshell "dir c:\Test.txt"

I get the following recordset:

Volume in drive C has no label.

Volume Serial Number is 48C9-F18C

NULL

 Directory of c:

NULL

File Not Found

NULL

I tried the xp_cmdshell function above on...

The exact files' names are Test2.txt and Test.txt.  So changing the case of Test2.txt to test2.txt will not help if it's case sensitive. 

Both these files are located in the...

Both files exist on the test server I'm using.  The SQL I posted (modified with more useful values of course), was run in a SQL Query Analyzer session on the...

I'm doing this as part of a data conversion, where I've been told I need to update certain account data in SQL Server and Oracle. 

I was hoping to do...

My Oracle proc populates a staging table and then I use a cursor in order to update other tables according to the data in the staging table (ie update TableA...

Wow.  Lately I don't get any responses to my posts. 

Any particular reasons why?  Was I not descriptive enough?  I searched the forums before posting.