Guys,

Please see the attached EXCEL file.

It's an extract from my SQL Profiler output.

Question.

Why sometimes CPU / Reads / Writes / Duration are NULL ?

Thanks,

Robert

Guys,

One more SQL Profiler question.

"Duration" in the results table.

Is it the duration of SQL executed in milliseconds?

I think I'll have to become a SQL Profiler knowlegable user in the next...

Thank you guys.

I will turn on SQL Profiler tomorrow morning.

It's a Production database. But it's a small

company. I think they might have 15-20 simaltenius connections. Not more.

It's not gonna cause...

Thank you all guys?

Michael / Mat / SGuarder.

I just started investigation.

They have a VB application that generates EXCEL reports

from this database.

I will find out soon "what most common selects are...

Lucky,

I did change stored procedure so that it returns only one dataset now.

But I don't like this approach because

it means I'll have to create another copy of that

pcdcs_ReadAcctAddress procedure.

I'm...

Guys,

I just realized it's all a bit overkill.

The core of the porcess is BCP command.

Why I'm struggling to execute it from DTS?

Command Line works fine.

And if I still...

Hi Adrian,

I created an "Execute SQL" Step in DTS.

It does the following:

CREATE TABLE ##export

(

[BENEFICIARY-NUMBER]  char(9),

[ADDRESS-ID-NUMBER]    char(1),

[RESIDENCE-CODE]       char(3),

[STREET-LINE1]         char(30),

[STREET-LINE2]      char(30),

[DOMICILE-TYPE]      char(1),

[UNIT-NUMBER]      char(5),

[CITY]       char(28),

[PROVINCE-STATE]     char(3),

[POSTAL-CODE-ZIP]     char(10),

[FOREIGN-ADDRESS-TEXT] char(30),

[FILLER]   char(59)

)

INSERT INTO ##export

SELECT...

Hi Adrian,

So I created step 3 in DTS

that executes a batch file "exec_bcp_from_##export.bat"

Here is the content of this file:

EXEC xp_cmdshell bcp "##export" out "D:\gh\2files\test\adrian.txt" -c -SCSSAN\TNV00PCDSQL -t""...

Adrian Nichols,

Since "Format all in SQL" method is on hold now

can I ask you a question?

I'm referring to your comment:

Step 3 - Create Data

 ...

Ed,

Just forgot to mention to you this.

I created a SQL Server view and then in DTS package I do a transformation

from that view into fixed-length file.

This is how I...

Hi Ed,

I just produced a file

and then wondered how I can check if

Column Positions were set correctly.

So I created a Text File Data Source in DTS,

pointed it to...

Makes sense.

Ed,

I didn't catch it last time.

What's the purpose of Literal # in your example?

Thanks,

Robert

Ed,

Just a quick question.

Why do I need to use SELECT LEFT(Field1+' ',3)

Not just SELECT Field1?

Is this what determines POS 1-3 for the output?

Thanks,

Robert

Well Veteran,

It's some really interesting advaned approach.

Let me absorb it.

HEADER and FOOOTER specs are known. Look

at my previous message.

I actually liked Ed's approach

to have everything in one SELECT...

They just gave me the specs.

HEADER

NAME                       POS       LENGTH

-------------------------------------------

DATE                       1-4        4

PRODUCTION DATE   5-10      6

SYSTEM TIME           10-16     6

DATA SET NAME        17-21     5

FILLER                    22-212

So now it's all clear.

They...