Tuesday, March 27, 2012
executing one .sql file from another
I can't find out if it is posible or not. I triet using EXEC but that doesn't work.if you create each as stored procedures, you can exec them from eachother...otherwise (though it is a terrible habit and not recommended) you can use xp_CMDShell
Monday, March 12, 2012
Execute Stored Proc from OLE DB Destination
is is posible to execute a stored proc (with parameters) from an OLE DB Destination ?
reason we are trying this is cos
our current setup is an OLE DB Command doing the first database update and then passing over to an OLE DB Destination that does the second update. There is error handling coming off the OLE DB Command to a Script component that passes to an OLE DB Destination.
we are having a problem getting the error reporting working from the OLE DB Command - the updates work fine - but not getting any updates of the error database when there is an error.
have got the error reporting fine on the OLE DB Destination.
if we can execute the stored proc from the OLE DB Destination, we will then do both updates via one stored procedure executed by the OLE DB Destination.
thx
m
n.b. think the updating of the error logs from the OLE DB Command used to work - but cant get it to work now ?!!!!?
cos we cant get the error logging to work from the OLE DB Command
and we want to know if any records dont make it
m
|||Well, why can't you get error logging to work? Any, ahem, error messages you can provide us with?|||phil
thx for this
we couldn't get it to work and could not understand why (followed and re-followed all of the instructions)
today
new member on project, new PC, new SQL installation (SP1), works fine ?
so
am uninstalling SQL from my machine and re-installing it (back to what it was - SP1) - and will see