What if stepping outside my comfort zone means forcing other people outside of theirs? Nobody, and I mean nobody, wants me to engage in any sort of public musical...

Jeff: Her complaint that SSIS takes too many steps to deploy, and her statements about how to open SSIS packages for editing (both of which are just plain wrong), make...

You're welcome.

The interface for building SSIS packages is extremely complex and difficult, assuming you aren't familiar with such arcane concepts as drag-and-drop, right-click, or flow charts. The deployment process does...

You're selecting @vEffectiveBegin, but you're not assigning a value to that. It's...

Lynn Pettis (12/9/2009)

---

Thank you, Gus. There are times I can't post certain code snippets from work, and this was one of them. Can't include d r o p...

File associations are controlled through the registry. Check there. Might be a problem.

The rumor mill is seriously overclocked at this point. I think it's running at...

I just checked the guy's...

You'll have to test for numeric values first, then do the update.

Because of how SQL Server works, the easiest way to do this (often the only way) is to insert...

To be specific, you'd need to change this:

exec sp_test_Called

@vEffectiveBegin=@vEffectiveBegin_1,

@vEffectiveEnd=@vEffectiveEnd_1,

@vDate1=@vOur_Date_1,

@vDate2=@vOur_Date_2

to this:

exec sp_test_Called

@vEffectiveBegin=@vEffectiveBegin_1 output,

@vEffectiveEnd=@vEffectiveEnd_1 output,

@vDate1=@vOur_Date_1,

@vDate2=@vOur_Date_2

crookj (12/9/2009)

---

Thanks for the info Steve.

Now that is a KNIFE!

But I agree, it is not worth...

No, I was hoping there was something in there that was confusing it.

Check what's in the Windows registry. Might be a double-entry or messed up entry there.

Well ... first you go...

In Management Studio, go to Tools, Options, and check what's in the Text Editor tab. There's a section on File Extensions. Anything set in there?