Recent content by jelf

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

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

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

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

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

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

Can you post the schema for the tables?

Do you have any triggers on your table?

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

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

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?

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

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

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

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