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 Chriss Miller 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: ddiamond
  • Content: Threads
  • Order by date
  1. ddiamond

    SSIS - help with Execute Package Task

    I am using SSIS 2008. I am trying to use the execute package task to execute a child package that is password protected. Eventhough I have entered the child's password into the execute package task's password property, I still get prompted for the child's password when I run the parent...
  2. ddiamond

    help calling stored proc on linked server

    I have a linked server pointing to DB2 on AS400. I am trying to call a stored proc on the AS400 from SQL Server 2008. I first tried:select * from openquery ( ADM_AS400_LPAR, 'CALL XGGNDTAADM.EFILE_GET_QUICK_SEARCH (''C007984A'')')I get the error message: The OLE DB provider "IBMDA400" for...
  3. ddiamond

    help with openquery update statement

    I am attempting to update a table on our AS400 from a SQL Server 2008 stored proc using a linked server. UPDATE OPENQUERY( ADM_AS400_LPAR, 'SELECT grbpqs AS RequestStatus, FROM xggndta.zagrdf00 a WHERE grbpqs = ''10'' AND grcrda = 1100809 AND grcrti = 1514 AND...
  4. ddiamond

    SSIS - how to select odbc data source

    In SSIS 2008, I was able to define an odbc connection manager. But when I go to the tool bar, I can't find an ODBC data flow source. The only data flow sources I see on the tool box are ADO NET, Excel, Flat File, OLE DB, Raw File, and XML. So how can I use my odbc connection manager?
  5. ddiamond

    Error - Agg expression containing outer reference...

    Here is my original query:UPDATE #AdjustedPremium SET AdjustedNetPremium = c.NetPremium FROM #AdjustedPremium a INNER JOIN AccountCurrent b ON a.AccountCurrentID = b.AccountCurrentID INNER JOIN #PremiumFinancialTemp c ON b.ProductCode = 'CHIRO1' AND b.BookDate...
  6. ddiamond

    create custom scalar functions for use in SSIS

    I'm attempting to re-write an ETL solution with SSIS that was originally written using MS Access 97. The Access 97 solution contains a lot of custom VBA scalar functions that encapsulate business logic. These scalar functions are used to create derived columns in many different queries. The...
  7. ddiamond

    compiling stored proc with sqlcmd vrs management studio

    I noticed that not all of my stored procs behaved the same when compiled using sqlcmd instead of management studio. The culprit appears to be how QUOTED_IDENTIFIER is defaulted. Management studio defaults it to ON. Sqlcmd defaults it to OFF. So I'm now tempted to explicitely put SET...
  8. ddiamond

    Help with XML nodes function

    The following code snippet works:DECLARE @Response XML SET @Response = '<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <soap:Body> <ProcessUWResponse>...
  9. ddiamond

    bug with sql server 2005 oledb provider

    When using the sql server 2005 oledb provider, I've found that the only way to get a resultset back from a stored proc that updates data behind the scenes is to include SET NOCOUNT ON in your stored proc. If I don't include SET NOCOUNT ON, I get the following error after I open my recordset...
  10. ddiamond

    help with &quot;FOR XML RAW, ELEMENTS&quot; clause - SQL 2k5

    I'm trying to create and xml representation of many tables (1 to many relationships). I've found the easiest way to do this is using the "for xml raw, elements" clause. All of the more advanced techniques involve creating a schema which I would like to avoid if possible. The only problem I...
  11. ddiamond

    AS400 query using CQE instead of SQE

    When I run my query through i-series navigator's explain tool, it says that the query will use the CQE because translation is required. I've searched, but the only examples I've found of translation functions are upper, lower, and CCSID conversions. My query includes none of these. What other...
  12. ddiamond

    Difference between system_user, current_user, and user_name()?

    What is the difference between the functions system_user, current_user and user_name()?
  13. ddiamond

    Better to use bulk insert or cursor

    I come from an Oracle and DB2 backgroud. I am new to SQL Server. When using Oracle and DB2, I was always told to avoid large bulk inserts because you are likely to blow your rollback segments. I was told to instead use a cursor and commit after every 50,000 rows or so. Now on SQL Server...
  14. ddiamond

    How to load null values into text fields using BCP

    I am using BCP to import a fixed width flat file into an sql server staging table. The problem is that when a text field is blank, BCP is loading spaces into the staging table. I would like BCP to treat a blank field as null, not spaces. Is this possible? - Dan
  15. ddiamond

    AS400: edit source member using external editor?

    I have a source file QDDSSRC that contains many source members of type TXT (SQL scripts that are to be executed with strsqlstm). Editing them with SEU works, but can be tedious. Is there anyway to transfer a source member to an external Windows editer, and then transfer it back (FTP?). Copy...
  16. ddiamond

    dba_ind_columns - how to determine if column asc or desc

    The system table dba_ind_columns doesn't specify whether an index column is ascending or descending. Is there any way to determine this using database queries?
  17. ddiamond

    How to determine the user that called a stored proc

    My platform is AS400 V5R4 DB2. Is it possible for a sql stored procedure or stored function to determine what userid executed it? For example in oracle you could use the following select: select user from dual ; Is there anything equivalent for DB2?
  18. ddiamond

    aggregate function to calculate the median

    Does anyone know how I can simulate an aggregate function to calculate the median of a group of values? My query would look something like the following:select field1, sum(field2), avg(field2), median(field2) from myTable group by field1As far as I can tell, access does not have an aggregate...
  19. ddiamond

    Tuning Init.ora file

    Version 8.0.5.0 Operating System: Windows 2003 Server. We just moved our oracle database to a new server that has significantly more resources - much faster CPU, more ram, much faster hard drives, much faster network. And as expected, oracle does run a little faster on the new server, but we...
  20. ddiamond

    Access 97 drop down list

    I have created a drop down list in excel 97 to restrict entry to a fixed set of values. This restriction works fine as long as the user either uses the mouse to select a value from the drop down, or the user manually types in a value. The problem is that the user can use copy and paste to put...

Part and Inventory Search

Back
Top