Jeff Moden (2/27/2015)

---

Zero bottles of beer on the wall.

Zero bottles of beer!

For those that roam,

Just come on home,

To one hundred bottles...

Quick thought, check that the DB2 ODBC drivers are installed on the server running the SSIS and that they match the architecture of the SSIS package execution.

😎

Just a hunch, suspect cached temp table might cause this.

😎

Quick point, run this query on the existing server to list the enterprise features in use

😎

SELECT

PF.feature_id

,PF.feature_name

FROM sys.dm_db_persisted_sku_features PF;

Hi and welcome to the forum!

There are several ways of achieving this, here is one example of a cross-tab type solution, should get you passed this hurdle.

😎

USE tempdb;

GO

SET NOCOUNT ON;

DECLARE...

Alternative solution which is more efficient but behaves slightly differently as it will bring back messages from both tables if they exist.

😎

SELECT

CM.message

FROM @compMessage...

petemill66 (2/27/2015)

---

I have a SQL Server 2008 R2 Cluster. I have moved a file to another drive by adding a new file on the drive, doing a...

This post[/url] could help

😎

Further on Jeff's fine solution, you may want to consider converting the column from (var)character data type to date data type. Not only does it take less storage (3 bytes),...

RIP

\\//,

😎

Jeff Moden (2/26/2015)

---

There's no question here. The third select on the original post shows the set-based replacement for the cursors. The title truly reflects what was posted... it's...

serg-52 (2/27/2015)

---

SELECT t1.*,t2.dueDate

FROM Table1 t1

LEFT JOIN Table2 t2 ON t1.ID = t2.ID

...

The same way as any other download, the client initiates the download by clicking a link/button and the source of the file is the output of the stored procedure. Alternatively...

Simply replace ' & ' with '&'

😎

MaggieW (2/26/2015)

---

Dear all:

I need to write a stored procedure or SSIS to export data to client's desktop. What is the best way to achieve it?

The requirement is to develop a...