What is the proper procedure when deleting stuff? What do I check for to make sure I don't take out too much or too little?

And, is there some better...

It's been a while since I've looked at the execution plan. I'm just getting back into it.

I did look at the tally table, but it seems to be one...

Steve Jones - SSC Editor (2/19/2014)

---

Need to see some sample data here. It's not quite clear. Are you saying that if you join the base and linked tables on the...

Got it working. It only finally started working when I set DelayValidation at the topmost level. I also set it at intermediate levels. Topmost makes the most...

I might be making process. I set DelayValidation to True on the whole package, and that gave me a bit more result.

Thanks for the insight.

I just tried it, and same problem. Didn't know that was there.

Further, I have one DTSX package calling another. The one that is called works if I run it on it's own. The outer one blows up, and now...

That connection is in the dtsx package, but it's possible another connection was used in the log feature. I don't know how to check what connection the log is...

I went and tried to run the batch file manually, noticed that it just blasted by on the screen in way under 1 second, and figured the batch file was...

IGNORE THIS FOR NOW. It's a scope issue. Forum won't let me delete the message.

Excellent. Thank you. I found something similar, but they said just to put the file name in the connection string, which, does not work.

I was also running into...

So, if I want to do extensive variable and data manipulation in the process, is it better to use an external compiled module? I've done that in the past,...

This is the code within Main, with much of it commented out:

Public Sub Main()

' Add your code here

'

...

Ah, I had to go to the Property Pages for the project.

InteractiveMode = True.

It doesn't seem to give me me that option.

All I see are:

Windows

Start Debugging

Start without Debugging

Attach to Process

Step Over

Toggle Breakpoints

Delete Breakpoints

Disable Breakpoints