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!

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

Recent content by jelf

  1. jelf

    SSIS ODBC Datareader Error

    am trying to import data from an ODBC source using the Datareader but have come accross a problem, can anyone help? Whenever I try to do a 'SELECT * FROM sometable' I get the following error: Error at Data Flow Task [DTS.Pipeline]: The output column "notes" (521) has a length that is not...
  2. jelf

    Concatenating Rows...

    Sorry but this uses a dreaded cursor to get your results, I'm sure someone will be able to do it without cursors. DECLARE @ID AS int DECLARE ID_C CURSOR FOR SELECT DISTINCT ID FROM Table2 OPEN ID_C FETCH NEXT FROM ID_C INTO @ID WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @employeelist...
  3. jelf

    Concatenating Rows...

    This may get you started DECLARE @employeelist varchar(100) SELECT @employeelist = '' SELECT @employeelist = @employeelist + ',' + Cast(name as varchar(10)) FROM Table2 WHERE ID = 1 SELECT @employeelist = REPLACE(SUBSTRING(@employeelist, 2, 100), ' ', '') print @employeelist This produces...
  4. jelf

    VBScript Run error running scheduled DTS package

    Wholsea Search for "Package Scheduling and Security Issues" in BOL. This gives a very good guide to permissions for DTS packages.
  5. jelf

    Point DTS pkg to renamed database?

    If this a once only task why not just run it and then rename your test database.
  6. jelf

    VB script hanging

    We have a very large DTS package which runs without any problems most days but recently the package is hanging on the very first step(see script). Nothing is logged and the system appears to be running normally but the only way to get this step to complete is to reboot. Does anyone have any...
  7. jelf

    String or binary data would be truncated Error message

    Can you post the schema for the tables?
  8. jelf

    String or binary data would be truncated Error message

    Do you have any triggers on your table?
  9. jelf

    Divide by Zero error

    If you are using Query Analyzer you can use: set arithabort off set ansi_warnings off In EM goto Tools -> SQL Configuration -> Connection Properties.
  10. jelf

    Divide by Zero error

    If you turn off ARITHABORT and ANSI_WARNINGS then divide by zero returns a NULL. Is this what you want?
  11. jelf

    "LSN . . . is invalid"

    Ralph This is yet another link which may be of use: http://sqlservercentral.com/scripts/contributions/190.asp I haven't tried this myself so if it works could you let me know?
  12. jelf

    "LSN . . . is invalid"

    Ralph It looks as if you have a log file error, have a look here: http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
  13. jelf

    SQL 2000 Cluster installation on Windows 2000

    Try this: http://support.microsoft.com/default.aspx?scid=kb;en-us;302491 Also try turning off all your virus software during the install. I have a strange cluster install that will only work if I use the 'B' node as my start point. I don't know why, the two nodes are identical as far I as I...
  14. jelf

    Logging successful or failed access attempts on tables

    You can use SQL trace (BOL sp_trace_create and sp_trace_setevent) to audit login/logout/fails.
  15. jelf

    BO on Microsoft Cluster

    Hi Has anybody installed Business Objects onto a Win2k MS Cluster? If so is there any documentation available on the web. Cheers
See more

Part and Inventory Search

Back
Top