It most probably has to do with security.

When run under EM, you are using the authentication context of the SQL SERVER registration under EM.

When asked to run under SQL AGENT,...

Use sp_executesql instead on EXEC. Then you can use output variables or a table variable to store the resultset.

HABIB.

Try adding "PROVIDER=MSDASQL" to the connection string.

By the way. To get your connection settings right, add a connection to the dts packages and open the disconnected edit screen. Scroll...

Yes, you have third party tools to check dependencies. Some ETL tools have impact analysis capabilities if you use them from end to end.

But the best course of action...

Create a calculated member in the Sales cube of the Foodmart 2000 DB and use the following construct :

IIF

([Time].CurrentMember.Level.Name="Month", ([Measures].[Unit Sales],...

I can think of 2 ways to do it :

1. Use a stored procedure and a "permanent" temp table, that is a table you create in advance and truncate before the transaform task using a...

What my customer needs is a full backup after transmission of the transaction log backup.

I know now (thanks to Mr. Yalçin Gülas !) that a full backup does not...

Here is another method :

Select top 1 OrderID, Customer From Orders Where OrderID<4 Order by OrderID Desc

UNION ALL

Select top 1 OrderID, Customer From Orders Where OrderID>4 Order by OrderID Asc