jeanyvesR (2/20/2012)

---

Sorry :crying:, but I going to run the job and I got following error message :

Message

Executed as user: Domain\PROXY_USER. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0...

yeah..that's enough then....:satisfied:

jeanyvesR (2/20/2012)

---

Thanks Charmer,

Regarding SQL server , I need to clarify permissions :

1) Create login (CREATE LOGIN Domain\PROXY_USER FROM WINDOWS;)

2) Create User (USE PROD_DB;CREATE USER Domain\PROXY_USER FOR LOGIN Domain\PROXY_USER ;...

jeanyvesR (2/19/2012)

---

Hi all,

I made SSIS package on development server using 2 connections:

- Flat File Source : Read/write access on a shared network drive

- ADO.NET Source : INSERT/DELETE access to a...

yeah..better give us some samples to work on it...so that we may help...

Jeff Moden (2/19/2012)

---

Charmer (1/24/2012)

---

herladygeekedness (1/24/2012)

---

Sounds like someone gave you lousy requirements!

In my opinion, if there is no column in which to check the criteria, you cannot use that criteria.

That said,...

Thanks Friend...

when i try to execute the Config file along with DTEXECUI , it says TITLE:...

Thank you Friend

Koen Verbeeck (2/7/2012)

---

Charmer (2/7/2012)

---

Koen Verbeeck (2/7/2012)

---

Because an object variable is a .NET object. It is like a ADO.NET rowset.

A configuration file is an XML file, it contains strings.

object variable <>...

so how can...

Koen Verbeeck (2/5/2012)

---

Charmer (2/3/2012)

---

Koen Verbeeck (2/3/2012)

---

Charmer (2/3/2012)

---

Koen Verbeeck (2/3/2012)

---

You can't use the object variable in a conditional split, as the component expects scalar values.

In the For Each Loop, you need...

Koen Verbeeck (2/3/2012)

---

Charmer (2/3/2012)

---

Koen Verbeeck (2/3/2012)

---

You can't use the object variable in a conditional split, as the component expects scalar values.

In the For Each Loop, you need to map the...

Koen Verbeeck (2/3/2012)

---

You can't use the object variable in a conditional split, as the component expects scalar values.

In the For Each Loop, you need to map the current value of...

Koen Verbeeck (2/3/2012)

---

Charmer (2/3/2012)

---

Koen Verbeeck (2/3/2012)

---

What do you mean with "now i need to pass four values to the table which needs to loop the package."

Do you need to insert...

Koen Verbeeck (2/3/2012)

---

What do you mean with "now i need to pass four values to the table which needs to loop the package."

Do you need to insert data into the...