1. Right-click on the For Each Loop container and select Properties.

2....

No, it is not....

Jason (5/26/2009)

---

Using the SQL Agent proxy is how I managed to impersonate 1 account, but of course, not the other. I managed to write my own connection manager. ...

Jason,

I'm thinking about the following idea:

1. Setup the database connection manager with RetainSameConnection property set to true.

2. Do the impersonation process and AcquireConnection from the connection manager.

At this point you...

Jason (5/22/2009)

---

Thanks again for the response... I was afraid of that. I do see those other options. Limiting the package with MaxConcurrentExecutables=1 does seem to work, but at...

I don't think you will be able to solve the problem with the impersonation. Check this article.

Having said that there are 2 solutions I could think of:

1. Limit the package...

Jason,

Why not use database logon and avoid dealing with user impersonations?

I don't think you will be able to use OLE DB connection from script. The method you are calling GetConnectionForSchema is most probably setting up a new OleDbConnection object. The...

tunchinho (5/20/2009)

---

hello

i have a package that contains 3 execute sql tasks for transaction operation, folowed by a data flow task and a script task.

my purpose is to get the values...

OceanDeep (5/20/2009)

---

Your command got the same error....... but guess what..... your new command again showed me something different... For the last argument, you remove the last '\' from the...

Try this:

dtexec /F "C:\DTSPackage\MySolution.dtsx" /SET "\Package.Variables[EmployeeID].Value;162" /SET "\Package.Variables[OfficeCode].Value;10" /SET "\Package.Variables[sFilePath].Value;N:\exportfile"

OceanDeep (5/20/2009)

---

thank for the reply. The thread that you pointed me to actually help me to solve it although it is not pretty. The thread mentioned about opening...

dasari_stupid (5/19/2009)

---

Hi

We are having 20 dimension tables and each table will be having around 20 million records.

These tables would be loaded on a daily frequency with 5 files, each of...

OceanDeep (5/19/2009)

---

Thanks for the reply. Actually I did try that before I posted my question, it returned an syntax error. Your command is almost exactly like mine except...

vana (5/18/2009)

---

I have a table containing the email address of customer along with message i have to send email to every week. I use For Each loop with

email task to...