Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pkav
  • Order by date
  1. pkav

    Multiple Databases?

    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...
  2. pkav

    DTS Permissions problem

    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...
  3. pkav

    Transform Data Task - Error Handling Question?

    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.
  4. pkav

    Help with a raiserror problem?

    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...

Part and Inventory Search

Back
Top