You're very welcome!

You can change the behavior on truncation. Look under "configure error handling" in the SSIS data flow task (each of the various stages should have a config error handling)....

Lynn Pettis (3/18/2008)

---

Just to be sure we are on the same page. When you say you delete the data in the destination table, are you doing a DELETE or...

Chris Morris (3/18/2008)

---

It comes down to using a tool you feel comfortable with to do the job really doesn't it?

Jeff, you like playing with macros in Excel - I...

Mh (3/18/2008)

---

After changing the recovery to Full, I take...

don't sweat it - it took me a long...

Also - a method without the CASE would look like...:

...

WHERE

((Monthid-1)/3 +1)=@quarter

...

Of course - the first method would allow for more efficient...

Happy to give you something new to look at...:)

You're not off as far as you think. It's just that CASE is use to conditionally return a value, so not an IN statement.

Try it this way:

SELECT *

FROM tblData

WHERE...

...Since Model is used to create the new databases, if you set up a user to have datareader access in Model, by default that user will have datareader in every...

Jeff Moden (3/18/2008)

---

Just my 2 cents... I'm always pretty much amazed at such requests... I do one of two things in most cases where someone "has to have it" in...

jfletcher (3/18/2008)

---

Well, yeah. A year or so ago nobody would believe I could learn to program in C# - which I have. The problem with having been a...

Recommendation would be to add another parameter, and make it an OUTPUT parameter.

Books online has a decent example (Look for Use Output Parameters once on the page):

http://msdn2.microsoft.com/en-us/library/aa258259(SQL.80).aspx

Your mocked up code...

Happy to help. Thanks for the feedback...

hmm... I'm only exposing person_pay one time. Sounds like you have something else exposing it.

that being said - you can always just change the alias if you so wish.

SELECT...