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 |
|
gerryd429
Starting Member
2 Posts |
 Posted - 2009-12-03 : 13:47:06
|
| I've got an interesting situation. I've got to build a stored proc that will encrypt sensitive data and load a required/matching XML file into a table. I can do one or the other, but my sql fails telling me it cannot find the file?Any ideas?Gerry Donaldson |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2009-12-03 : 14:52:17
|
What do you mean by a required/matching xml file?Also keep in mind that any file stored will be accessed on the machine running sql, so if you are running your query on computer1, but sql is running on computer2, it will look for the file on computer2, not 1. Also make sure the sql service account on computer2 has access to the file.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
gerryd429
Starting Member
2 Posts |
Posted - 2009-12-03 : 15:53:22
|
The requirement is that sensitive data is pulled out of 1 XML file and stored in Biztalk...then Biztalk will output an XML file to be stored, along with the sensitive data stored encrypted, in a single table. I've set the variables as I believe they should and the Bulk XML load works fine outside of this, but when added into the other fields being loaded into the table, the query bombs.This isn't my forte, but some kind of a template that would load the XML into a variable while inserting other fields, would be great!quote:
Originally posted by Vinnie881
What do you mean by a required/matching xml file?Also keep in mind that any file stored will be accessed on the machine running sql, so if you are running your query on computer1, but sql is running on computer2, it will look for the file on computer2, not 1. Also make sure the sql service account on computer2 has access to the file.
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881
Gerry Donaldson |
|
|
|
|
|
|
|
|
Inserting XML file into table with other fields