What is your destination database like SQL Server...oracle..db2???

To copy...

Jake Shelton (2/3/2012)

---

Hi all, errors out as follows when attempting import:

"Test connection failed because of an error in initializing provider. Cannot start your application. The workgroup information file is...

Koen Verbeeck (2/2/2012)

---

AluburaJ (2/2/2012)

---

Out of curiosity, were you able to connect to that oracle database using those SQL Client tools...

Yes.

Out of curiosity, were you able to connect to that oracle database using those SQL Client tools such as SQL...

Hello,

Seeing your error, I feel you are using Visual Studio 2008 R2. Instead of doing all the steps you mentioned above, can you please see if you could load data...

Do you have oracle clients on your machine to connect to oracle database like SQL PLUS or any other?

Hello Van,

Here is the one way to solve your problem.

In the script below, it works if the data is exactly like you posted.

Customer : 111111 Agent : ABC1 Date/Time :...

What all I suggest to you is...first google/bing it at the least if you don't know....and there are sometimes where you don't find results in google... then comes this forum...

I also faced a requirement today similar to what you had... and I was successful in implementing all the ideas I told and the url on how to use FOR...

Can you please see if this link below helps for using ForEachLoop

http://www.codeproject.com/KB/database/foreachadossis.aspx

and follow the steps of creating the sql in a variable.

After you run setup of sqlserver 2008 R2, you select "installation" and select the first option "new sqlserver or add features" and then in the while going through the wizard,...

Sapen (12/28/2011)

---

I am attaching the document with the flow of screenshots and the error I am facing when entering multiple variable values. Hope this will clear you what I am...

I would do like this.

using FOR EACH LOOP

now create a variable to hold the sql

design the sql in the expression of the variable using all the variables being passed from...