Chio, you could compare the installation logs from the different instances to track down the difference. I'll try out your component on a vanilla system and let you know the...

Hard to say without further knowledge, normally I would consider this a good and normal practice.

😎

Eric M Russell (5/2/2014)

---

I can confirm that 3 dimensional joins work quite well; it's the 12 or 20 dimensional...

Felt I could not leave this one hanging......:cool:

Use the output to insert the records into a table and export to excel/csv from there....

You can use the output clause with the delete

😎

DECLARE @TTABLE TABLE

(

TT_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT NULL

,TT_VAL INT NOT NULL

);

INSERT INTO @TTABLE(TT_VAL)

VALUES...

I would recommend a dynamic package or in other words, programmatically generated packages. This is fairly straightforward from a script task in a master package.

😎

Lowell (5/1/2014)

---

i've tried sys.fn_cdc_hexstrtobin to convert the string to varbinary, but it truncates a large portion of the value.

maybe someone else can take the ball and run with it form...

Lowell (5/1/2014)

---

i've tried sys.fn_cdc_hexstrtobin to convert the string to varbinary, but it truncates a large portion of the value. maybe someone else can take the ball and run with it...

A simple solution

😎

with p as

(

select 'asdf1234' as Delivery_Site union all

select 'asdf 1234' union all

select ' asdf asdf ' union all

select ''

)

,TXT_INFO AS

(

SELECT

...

Why not try Jeff Moden's splitter, pass space as delimiter?

😎

cvkk2010 (4/30/2014)

---

Hi All,

I need help to execute a taxk.

I have text file which has SQL Statements something like

Select top 10 * from Table 1

Select top 10 * from Table 2

Select...

On a mediocre laptop, 10000000 rows returned in 145 ms and 100000 inserts in 75 ms, I think version 1 is promising.

😎

Few weeks back, before upgrading the 2012 system I´m working on to 2014, I ran into a similar behavior when forgetting the filter/limit...

That means I might be missing something:-P

Thanks!