scottcabral (1/8/2016)

---

Hi,

I have a process that will import a txt file each month. There will be 2 separate txt files. One is a monthly file that will be delivered to...

You may want to point the developer here.

A script task would be used to call this.

The script task would need to assign the returned path to an SSIS variable, which...

But you shouldn't. Unless...

joeshu26 (1/8/2016)

---

Is there a script that brings up a prompt that allows user to navigate/select path of flat file connection string and assign it variable to be used in Data...

dramon14 (1/8/2016)

---

Yes sir, that's my intention, to create fully dynamic process for reading files and perform the Load to be content with the corresponding tables in the database.

I thought the...

d.carpenter (1/8/2016)

---

I will be installing a new SQL Server 2014 database system, which is based on our current SQL Server 2005 database system.

The new system will be on a completely...

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...