See the SQL Profiler EVENTS I chose.

Is this going to be sufficient to capture TIMEOUTS...

See attachment...

I did.

I started two traces yesterday.

But apparently one of them caused disk space issues on C: drive on production server. (Oops!)

Actually it is interesting.

When you run a trace for 15...

I think I need to see the screenshots with the error.

Because their Application log

is very primitive.

I personally understand that it is most likely the client that

timeouts. Now the...

You mean in their .NET code?

Like CommandProperty.Timeout ?

First when I saw Jack's article I used it in my packages.

It was about 5 months ago.

But later I switched to a different solution.

Let's say I have a Data Conversion...

Hi Matt,

It's a pretty simple task so I wouldn't split my data flow

to implement this.

Derived column is good enough.

I also found out that you can do it in Data Flow...

Solution:

Derived Column: COL02

Expression:

If COL01 == "1" ? "4" : "whatever"

Looks like you need a derived column.

You can not replace the existing column values using Derived Column Expression.

I followed the suggestion from:

http://www.sqlbi.eu/Forum/tabid/72/forumid/12/threadid/7/scope/posts/language/en-US/Default.aspx

and it helped.

I removed OLE DB Command. Instead I inserted the results into

Global Temp Table ##CUSTOMER_DIM_ACT_CD in my data flow

and in Control Flow...

Guess what Bruce?

Boss said we don't have time to troubleshoot this.

They decided to remove headers from all five files

and it worked. We're in a hurry. We might not meet the...

So Bruce,

Does it mean if the header is a different format

then you can't use Bulk Insert (WITH FIRSTROW=2) ?

It won't parse the file correctly?

SSIS is the only solution in...

I don't really understand where these

Param_0

Param_1

Param_2

in OLE DB Command are coming from.

Is it whenever you have "?" in your command it creates a new Param?

OK. But then I would need...

Apparently there is a very simple solution.

I just named that header dummy column as

"A_NEW"

"A_CLOSE"

"A_UPDATE"

and inside "Union All" sorted list by column name.

I get my header at the top now.

Cos if you have 40 columns you don't want to scroll down

to verify the stream. You want to see the stream at the top

as a header.

Show it as first column inside "Union All Input 1", "Union All Input 2", etc.

In SSIS Logging in Details Tab

you have to select only the events you really need.

In my case for example i checked "OnError" and "OnInformation".

That's it.

This reduces the output considerably.

I actually...