SQL Kiwi (1/31/2012)

---

The optimizer has to choose one row source...

SQL Kiwi (1/31/2012)

---

A second option:

SELECT

c.CategoryId,

c.NameCategory,

Top1.NameDetail

FROM dbo.Category AS c

CROSS APPLY

(

SELECT TOP (1) *

...

That is a good way to...

johnitech.itech (1/31/2012)

---

:hehe:

To eliminate column title row that you see before the data, use NoHeader option:

http://msdn2.microsoft.com/en-us/library/ms155365.aspx

You can use it with URL access (add &rc:NoHeader=true to report url), or, for RS 2005,...

Go for package configurations, definately. Data sources are a Visual Studio thing and are not deployed to the server! (at least not in SSIS. It does work for SSAS and...

Implementing Logging in Packages

How to: Enable Logging in a Package

A log provider specifies the type of log (sql server table, flat file, windows event log, ...) and the connection manager...

Please do not crosspost. It wastes people's time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1243795-147-1.aspx

What happens if you change the SuccesValue property of the Execute Process Task to 2 instead of 0?

It's there, just not where you'd expect it 😀

You need to create an event handler on the task you want to monitor. In the event handler, there is a system...

You can take "Embedded in Task" quite literaly.

The DTS task is embedded in the task, in other words, it is embedded in the .dtsx file (which is just XML).

If you...

Regarding the time format: you'll have to add the zero's yourself in the expression. You can do this by converting the number to string and use the following formula:

RIGHT('00' +...

That is indeed the way to go.

Creating an Asynchronous Transformation with the Script Component

There is a problem with your expression. This is an expression for a connection manager, but you put it on the name property, which won't accept the \.

+1 for SSIS

I'm not sure what you're getting at.

The number of rows are not important for a join. (at least not if they are even or not)

And there isn't such a thing...