I am sorry, but your question was confusing... are you trying to retrieve data from an XML format and shred it into relational format?

This is a very bad rookie solution that i am recommending but, if u dont want to waste anymore time - just dump everything into a Temp table with an...

i bet you could always do a custom scheduler check (implement custom queuing with a table to log the execution status and started and finished and check on every run...

On what connection are you trying this on? I mean are the source and destinations on the same m\c or on a network (comp network? T1?).

Using the fast load actually...

I bet these questioins help only land u in job, but day 1 u will see new posts from all these ppl

🙂

good intentions to help. But ppl; practice scenarios.....its...

But dont u think if u have multiple processes running at the same time, u will face resource contention - locking\blocking.

I would suggest u leave it as is or use...

are you locking the table ? or checking constraints on the data flow destination?

In your ReadOnlyVariables do u have it as @[User::Path] or User::Path

The latter is the correct one.

U may have to mess with system tables here if u want for ex: on success to run something. I havent done anything particularly like this, but it may also...

Did u input the variable name "Path" in the ReadOnlyVariables property of the script task? If not you need to do this. Otherwise, instead of the Dts.Varaibles use the Dts.VariableDispenser

Hope...

Anyone....?

try

Dts.Variables("Path").Value

Did u try using merge transformations?

If your only concern is the monotonous creation of the 100 users, try scripting the users (automate it)

http://www.microsoft.com/technet/scriptcenter/resources/qanda/apr06/hey0413.mspx

Bingo !!

🙂