Thank you.

ok, was able to get the watch list up. now things are working. One problem was, I only designated read/write variables, not readonly. It was blowing...

Thank you. I am setting breakpoints. How do I look at a variable value when I hit a breakpoint, besides debug.print.

The variables list is not changing.

Thank you. The only way I know to examine user variables during debugging is via Debug.Print. Is there a smarter way to do this?

Not sure why or how, but one of the techs in Scotland looked at the table, noticed 3 indexs were fragmented > 95%, reindexed them, and it started working.

Not sure...

They original process was kicked off by right clicking on the db name, selecting tasks, then "Export...

How could I tell what process was kicked off by me right clicking on the database name, selecting Tasks, then selecting Export Data. Is that Task Manager?

I assume there...

thanks. Yes, using SSMS.

That window is closed, so nothing available at bottom of screen. I'll check the processes and see if anything looks familiar.

Eirikur Eiriksson (3/27/2014)

---

Well, this is what I got when I tried that:

Error1Error loading 'Weekly_FullSnapshots - Forecasts Live - xml edit.dtsx' : The server threw an exception. (Exception from HRESULT: 0x80010105...

nonghead-webspam (3/27/2014)

---

Eirikur Eiriksson (3/27/2014)

---

The way I would do this is :copy the package file, open the package in a text editor, delete everything including the tags between any instances of...

Eirikur Eiriksson (3/27/2014)

---

The way I would do this is :copy the package file, open the package in a text editor, delete everything including the tags between any instances of <DTS:ConnectionManager>...

Point taken. ...

Koen Verbeeck (3/27/2014)

---

Delete all connection manager, create your new ones. Open up each task and component and reassign to the correct connection manager.

Run the package. If there's an error, repeat...

If I wanted to remove all existing connections and rebuild them, is there a process for doing this so I don't end up with orphans again?

Unfortunately I'm "newer" to SSIS, and dealing with other people's packages (in part), but also my own.

I guess...