Hi all,

I have been looking at deploying an SSIS package which is called by a web
service. I have had to reconfigure the package so that all connections use
windows authentication. This windows account will be the one used by the
application pool which calls the web service. On my development machine i
have the package running with no problems what so ever.

When i deploy it to a test server which also has SQL 2005, and the web
service installed i get errors in my log files. The error is as follows:

Executing the query "Set ? = (select max(URC_ID) AS URC_ID FROM
VIEW_A1021_URC
WHERE SerialNumber = ?)
" failed with the following error: "Syntax error, permission violation, or
other nonspecific error". Possible failure reasons: Problems with the query,
"ResultSet" property not set correctly, parameters not set correctly, or
connection not established correctly.

This as i mentioned previously works on the development machine and the user
rights should be set identically on both SQL server instance.

Can anyone suggest why this may be failing. It always seems taht i get 95%
of apps down with no problems then the last 5% takes days to find a solution
to. I'm assuming that it can be done.

All help greatly recieved.
Thanks in advance,

Grant

I have the package now working when i execute it from SQL server management
studio. Once i runit from the web service however it processes once and deals
with one folder. Upon reaching the same query the second time round it fails
with the smae error message. This just gets stranger and stranger.

"GSwan" wrote: