hey Maddy,

One environment variable will do which will explain where the configurations reside (in the xml file or on the SQL server)

My preference is SQL server, because anything that is...

hey Ilmar,

lookups sound about right.

What you would need to do is redirect the rows not found, which would move into an "error stream", where you could use a column derivation...

Hey,

The only time I queried SAP is through Datastage Parallel Extender which pretty much wrote the ABAP for me.

However, there is an interesting article that may assist you

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2368202&SiteID=1

If you do...

I used a combination of scripting and precedence constraints.

In my case I had to maintain a boolean variable with if a particular run balances, which I did in the script...

There is a way to disable package validation, just dont know how.

If you manage to figure that one out, please post.

But if you use SSIS configurations, the variable will be...

I didnt realise that you could set some properties directly from a variable.

I thought that you had to tie the expression to a variable, with the expression containing the properties.

Another...

Uhmmmm, something is not kosher on your side.

I had an outstanding task which pretty much involved using package configurations for the SMTP server connection string, the from address as well...

SSIS packages are created in BIDS, so the permissions you should be considering is one of the following:

a) Your user will be loading data to tables, so in the development...

Why dont you break it into smaller tasks?

Doing 360 things in the same go is a little over the top. What happens if one of the tables has a problem?...

I have a for each ADO enumerator running without much hassles.

Lets say your variable name is varProductName

a) What I did is to have an execute SQL task...

I would suggest you try with the remove duplicates sample, as described in BOL.

There is a dll in there, which you have to make part of your GAC (by running...

Really curious.

Are you trying to export 360 tables at the same time, in the same session?

~PD

version 8.x is SQL2000.

Not sure if that article would be applicable

~PD

Are you going to be moving these jobs to SSIS anytime soon?

If you are, I would be interested in the workings thereof, as I havent really seen anything on this...

Hey,

The more I read up on your specific problem, the more the hair on my neck stands on end...

I have honestly never heard of Lotus Notes DB before. And then...