niladri.primalink (1/8/2016)

---

Thanks for your reply.

I have seen it.But my requirement is to run the remote .exe file from my local machine from ssis package. I have also tried with...

asghar786 (1/8/2016)

---

I have an MDX query, which I want to access from RUBY ON RAILS... so that By creating LINKED-SERVER objected I can access MDX query and can get all...

PsExec might help you.

I hope that that 'initiator' comment was deliberately tongue-in-cheek! (As implied...

Please provide DDL, sample data and desired results as per the link in my signature in order for people to be able to help you with this.

dramon14 (1/7/2016)

---

actually i need is to implement a SSIS to perform the massive upload files to an Oracle database. are 104 files in total and according to its contents must...

Have a look at this:

with MostRecent as

(SELECT pk_Contract, rn = ROW_NUMBER() over (partition by AccountName order by ContractEndDate desc) FROM @Customer_Contract)

update cc

set isLatestContract = 1

from @Customer_Contract cc

join MostRecent on cc.pk_Contract...

j-1064772 (1/7/2016)

---

Thank you, half-way there. The main table still has to be * updated * with the result set, i.e. it is needed to identify, for each customer, which is...

dramon14 (1/7/2016)

---

create the ODBC as recommended you , and when I came out successful connection test . for that reason it implements code in the application to perform validation of...

Or, if the copy really is 'almost' the same, perhaps you could consider generating an exact copy and then applying the changes to that.

Perhaps you would be so good as to re-read my question & try again.

ElNevera (1/7/2016)

---

Thanks...

ElNevera (1/7/2016)

---

Whilst initially setting up the packages we were using Windows Authentication but when I deployed the packages to SQL...

dramon14 (1/7/2016)

---

Friends , I need to read files * .db and * .px ( paradox ) through a process of SSIS ( dtsx ) , so far I could not...

ElNevera (1/7/2016)

---

Hello

I work in a newly created BI team. We have experience using Business Objects for ETL and some development experience using Visual Studio 2013 and TFS. We are using...