Hi,
I'm looking at implementing a SQL Server Reporting Solution to report on a set of databases (across a number of servers). The reports would need to be able to display information from a combination of these databases.
Am I right in thinking that the only way to create the result set for a...
Hi,
I'm not going to offer much hope to you, but I'd suggest you recheck the permissions for your server.
I created a very simple DTS package with a transform data task followed by yuor active-X code snippet and it seemed fine when writing to a local dirve.
If you know the name of the...
Hi,
Is there way to configure a transform data task to populate an error table instead of the destination table if a transform fails?
Or is this something I'll need to do using some form of ActiveX scripting?
Any help would be great, thanks.
Paul.
Hi,
I'm trying to write a new storedproc to call some existing code in a released application.
The original code was written to be called by a .NET application and had RAISERROR statements as follows:
RAISERROR ('blah %s', 10, 1, @variables) WITH SETERROR
Ideally I'd like to piggy back on this...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.