yingchai (9/3/2014)

---

I had executed twin.devil code and it works on my side. I am using SQL Server 2012.

Apart from that, I am interested to know how to populate few records...

Nice Question Steve. Thanks for sharing

i have just added the error message generation in your code. try to execute it and check what error its generate

DECLARE @objExcel INT,@hr INT,@command VARCHAR(255),@strErrorMessage VARCHAR(255),@objErrorObject INT,@objConnection INT,@bucket INT,

@DDL VARCHAR(2000),@DataSource...

ChrisM@Work (9/2/2014)

---

Twin-devil: I think the OP wants to apply a row-level condition using values from table X, in which case dynamic sql won't work.

The most common choice would be...

Indu-649576 (9/2/2014)

---

twin.devil (9/2/2014)

---

Indu-649576 (9/2/2014)

---

IS there any way I can use the below

Select X.* From TABLE X

INNER JOIN

(case when (condition) then TABLE A else TABLE B end) AS Y

ON...

Indu-649576 (9/2/2014)

---

IS there any way I can use the below

Select X.* From TABLE X

INNER JOIN

(case when (condition) then TABLE A else TABLE B end) AS Y

ON X.Col1 =...

I have had a look at these and nothing really solved the issues in SSIS, I think I need to build this into SSIS, just not sure exactly what to...

i would recommend to check you Users table 1st. i feel there are duplicates and that might be give you the clue

Following is the example have been made to illustrate...

Shiva, It is me or it is just repeated question shared on "Choose only two correct answers? " on 21 Aug 2014

with different correct answers 😛

cbernardes (8/25/2014)

---

Eirikur Eiriksson (8/25/2014)

---

cbernardes (8/25/2014)

---

I am using the DTS wizard and having problems importing excel into an existing table.

Problem is that various column in excel are defined as double in...

Eirikur Eiriksson (8/26/2014)

---

simon_s (8/26/2014)

---

Looking at a trace table and trying to remove all the "erroneous" bits in a string e.g the declares etc so I can purely get to...

Very nice question as well as the explanation. Thanks for sharing

VBA functions related queries are not accessible in SSIS because driver do not allow it.

if you use the custom assembly you will have to deploy these settings every time whenever...

like that : Select CleanseData() . CleanseData is the name of the method in my access module and

it does some DML things and returns. It does not need to return...

CTE will not server the purpose, you will be getting MaxRecursion error because there is no particular hierarchy is available in your table.

following query is written with respect for your...