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 strongm 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: *

  1. plevey

    Running IIS causes client browser on same machine to keep hitting google-analytics

    I have recently installed IIS on my home machine ( Windows XP SP3) and built a simple web site to allow family members to browse 'photos etc stored on an external hard drive from their own devices via WLAN. What I have found is that when IIS is running and I try to browse the internet from the...
  2. plevey

    Cognos 8.4. report schedule issue

    Try scheduling the report to run in little later. BTW Cognos 10 renews the credentials each time a scheduled report/job is run so the problem of renewing cedentials goes away. If fishing was easy it would be called catching
  3. plevey

    need help parsing a csv file using ssis

    Have a look that the SQL REPLACE function. You could replace the double quotes with a space. If fishing was easy it would be called catching
  4. plevey

    Extracting File Name Data into a Table

    Have a look at the SQL Position function. For example, find the position of the 'dot' delimiter of the file name and then the position of the first 'space' before the filename and so on. If fishing was easy it would be called catching
  5. plevey

    SSIS Solution doesn't work with SQL SERVER Agent Job Scheduler

    Have a look at Package Protection again. It's likely that the password is not being saved. Set it to Encrypt sensitive with password and set the password. Then edit the step in SQL Server Agent job and apply the same password If fishing was easy it would be called catching
  6. plevey

    Cannot Schedule SSIS Package

    Have a look at Package Protection again. It's likely that the password is not being saved. Set it to Encrypt sensitive with password and set the password. Then edit the step in SQL Server Agent job and apply the same password If fishing was easy it would be called catching
  7. plevey

    Atomic between DB2 and sqlServer

    Search IBM site for RUNRMTCMD If fishing was easy it would be called catching
  8. plevey

    How to focus default item in listbox prompt

    thread401-1392169 Cognos 8.4 Report Studio Using a listbox to prompt for Fiscal Year. Current fiscal year should be highlighted (selected) by default, but still allow user to select another year. In other words I'd like an example script which focuses the list item based on some sort of...
  9. plevey

    Loading Excel into SQL

    Try using a named range in the 'SQL Upload' worksheet If fishing was easy it would be called catching
  10. plevey

    Extracting data from a Progress SQL database truncates varchar columns

    Extracting data from a Progress SQL database truncates varchar columns. Environment : Windows 2000 SP 4 MS SQL Server 2000 Microsoft SQL Server 2000 - 8.00.760 Standard Edition (Build 2195: Service Pack 4) ODBC Driver is DATADIRECT 4.10 32-BIT Progress SQL92 v9.1E 99% of the time all is...
  11. plevey

    Help with SQL join issue (not sure how to describe it)

    I can't see a way to get it all together in a single select. What about using a stored procedure then use coalesce to get all the Addresses into a variable separated by commas? Something like: SELECT @AddessList = COALESCE(@AddressList + ', ', '') + CITY FROM Address If fishing was easy it...
  12. plevey

    Help with SQL join issue (not sure how to describe it)

    Interesting! Let me get this staight... Entity 001 has Names 001 - 01 Jim 001 - 02 Jimmy 001 - 03 James and Addresses 001 - 01 Chicao 001 - 02 New York 001 - 03 Los Angles How do you determine that Jim is associated with Chicago, James with New York and Jimmy with Los Angeles unless...
  13. plevey

    DTS Question

    Open Excel, click Fle > New > New Workbook. Then Tools > Options and on the General tab set 'Sheets in new workbook' to 1. If fishing was easy it would be called catching
  14. plevey

    SQL0332N error problem

    Have a look here http://www.cs.toronto.edu/db/courses/343/Summer2003_L5201/DB2/msgs_2.pdf If fishing was easy it would be called catching
  15. plevey

    ERROR ON ALTER COLUMN

    Might be permissions or could be you need to apply fix pack. Try searching http://www.ibm.com/support/us/ for SQL0443N ALTOBJ If fishing was easy it would be called catching
  16. plevey

    IIS gives File Not Found Error

    Have you checked that all the Virtual Directories in IIS are pointing to the correct path and have correct permissions? If fishing was easy it would be called catching
  17. plevey

    cognos 8 installation

    Navigate to ..\Cognos\c8\bin and open Logview.exe then Load ..\Cognos\c8\logs\cogserver.log. This might give you some clues If fishing was easy it would be called catching
  18. plevey

    Time Dimension Off Data Table

    I'm assumimg you do not want days/weeks as it's a financial calendar. In which case don't use the date wizard - just add a Date dimension snd add FIN_YEAR as first level and then FIN_MONTH as next level down If fishing was easy it would be called catching
  19. plevey

    Time Dimension Off Data Table

    Which product are you using ? If fishing was easy it would be called catching
  20. plevey

    Importing Functions in ReportNet

    What CognosProfessional says is true, but your can also import User Defined Functions. You have to include the appropriate collection (libray in i-series speak) in the data source. If fishing was easy it would be called catching

Part and Inventory Search

Back
Top