Viewing 15 posts - 6,091 through 6,105 (of 8,761 total)
Importing a spreadsheet like this in SSIS would neither be considered trivial nor complex, more in the category of multi document files, on the scale of 1-100 it could be...
March 1, 2015 at 4:00 am
TomThomson (3/1/2015)
Nakul Vachhrajani (2/27/2015)
What's interesting is that 32767 is the upper limit for SMALLINT (2-byte/16-bit integers). Yet, the database identifier has a data-type of INT, not SMALLINT. I...
March 1, 2015 at 3:21 am
SwePeso (3/1/2015)
That's why why...
March 1, 2015 at 3:10 am
siggemannen (2/28/2015)
Hi,Could you explain it a bit more? 🙂 Not sure i follow it exactly
Have a look at this article by Paul White
😎
February 28, 2015 at 11:21 am
Jeff Moden (2/28/2015)
Eirikur Eiriksson (2/28/2015)
Jeff Moden (2/27/2015)
Lynn Pettis (2/27/2015)
ZERO DAY! Leaving Afghanistan!Going Dark!
Zero bottles of beer on the wall.
Zero bottles of beer!
For those that roam,
Just come on...
February 28, 2015 at 10:27 am
Quick question, is this on a cluster? Can you tell us how you have done it?
😎
February 28, 2015 at 8:41 am
Double checked it doesn't exist on either of the nodes?
😎
February 28, 2015 at 8:37 am
Carlo Romagnano (2/27/2015)
Now, I want to try!😀
How is it going? Done yet?:-D
😎
February 28, 2015 at 5:08 am
Jeff Moden (2/27/2015)
Lynn Pettis (2/27/2015)
ZERO DAY! Leaving Afghanistan!Going Dark!
Zero bottles of beer on the wall.
Zero bottles of beer!
For those that roam,
Just come on home,
To one hundred bottles...
February 28, 2015 at 5:05 am
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.
😎
February 28, 2015 at 4:59 am
Just a hunch, suspect cached temp table might cause this.
😎
February 28, 2015 at 4:32 am
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;
February 28, 2015 at 2:36 am
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...
February 28, 2015 at 2:25 am
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...
February 28, 2015 at 1:32 am
petemill66 (2/27/2015)
February 28, 2015 at 12:12 am
Viewing 15 posts - 6,091 through 6,105 (of 8,761 total)