I admit I've never seen such a move requested. What are you pulling out of Notes? How are you planning to transform it? You might find an...

The answer is, it depends, how will the user be running it? This make a huge difference and many of the ways make it nearly impossible to do what...

You are welcome.

CEWII

Great to hear you got it worked out.

CEWII

The easiest way to answer this is to point you at:

http://www.connectionstrings.com/

CEWII

Ok first Package not packet..

Now I think there are some misunderstandings here.

1. When a package is upgraded the wizard tries its best to make a full 2005/2008 package with no...

You are very welcome.

CEWII

What do you consider health?

There are a lot of roll your own projects of this because everybody looks at health differently.

CEWII

I assume that is the code that works, at first blush it would seem to.

I do have a question, you said "If i ignore Variable passing part from my code"

I'm...

I wuold like to echo what the other posters had to say, NO NO NO NO NO..

While testing in BIDS *maybe*, any other time, NEVER. If you need input...

I would have to recommend against...

As I read your question you want to copy data for each table from a list to a destination that has the same table name and structure. That about...

Well I can see that, but what prevents the user from entering bogus values and breaking the process?

CEWII

Yeah, you got me..

I looked at your trigger and it would seem to prevent dupes. I would write it differently though, I would check for record existence and then...

RandyO (6/29/2010)

---

The manual edits are what we are trying to minimize, was thinking there might be some way to loop thru the table.fields, but if so, is there equivalent way...