Christian Cote (7/31/2008)

---

HI, I personally use Visio diagrams to document my package. I use visio toolbox templates for SQL Serer (http://visiotoolbox.com/downloads.aspx?resourceid=1&aid=558) to create my diagrams and use them...

DBA (7/23/2008)

---

hi i am using your code in the command line

'C:\Progra~2\Micros~2\90\DTS\Binn\DTExec.exe /dts "\Application Packages\MyPackage.dtsx"'

but i keep getting this error:

The process could not be created for step 1 of...

From here: http://blogs.msdn.com/buckwoody/archive/2008/04/25/sql-server-2008-management-improvements-t-sql-debugger.aspx

SQL Server 2008 Management Improvements – T-SQL Debugger

I’m here at the SQL Connections conference in April of 2008 and I’m giving a presentation on...

I had a similar issue, and after playing around with the DefaultBufferSize and DefaultBufferMaxRows (in my case, increasing them), this has resovled the issue. I should state I am running...

Jamie Thomson (5/1/2006)

---

Carol,

Absolutely not. SSIS process data in the pipeline wthin memory buffers. The size of each buffer is determined at runtime and as many buffers as are required are...

how many rows do you expect to process? Is 8000 all the data, or is that perhaps just 1 buffer?

how long did you leave it 'running' for?

what destination are you...

GregoryAJackson (1/21/2008)

---

Don,

I dont understand your post regard the negatives to SSIS and regarding blocking....

(I think I might disagree with you but I want to make sure before I reply in...

Seems I am not the first person to comment that package configuration is what this article should have been about (or at least what I expected it to be about).

Package...

thanks for clarifying that, Crispin.

 

by the way - how's life? Where are you these days? (wanderer @ sqlservercentral = wanderer @ sqlteam )

Am I the only person who thinks this is a poor article?

To quote:

"But the problem with T-SQL is that programmers already have enough to learn, much less having to master...

3 yearly releases is more or less the norm, as I understand it. That said, from Nov 2005 to Feb 2008 is actually only 2 1/2 years.

I believe from my...

Well, I think it is horses for courses. And I get the impressions Steve does intend that as well. Some of the new things in SQL 2005, however, may mean...

Unfortunately, afaik, no, there is no 'ANSI attachment' option. Wish there was. My issue was fixed simply from the point of view that SP2 corrected the errors in the format of...

In SQL 2000, use the function ::fn_get_sql (X'sqh handle') where SQL_handle is the sql_handle column from sysprocesses.

In SQL 2005, have a look at sys.dm_exec_sql_text(sql_handle), getting sql_handle from sys.sysprocesses

HTH

Consider using virtual server's - install a virtual server, andd then on the cirtual server you *should* be able to install Katmai

anyone doing this yet? I'm waiting to get virtual...