Joe,

If you are using statically defined time periods, you can create a Conditional Split task and branch out to a text output for each time period. However, this could...

Have you installed service pack 1 on Visual Studio? I ran into that same error consistently, and upgrading to VS2005 SP1 fixed it for me.

You can check the service...

Mike,

Maybe I'm trying to read too much into this, but you've got a column named NoOfHours (number of hours?) as type of Money. Is that intentional?

Mike, can you add a little more information here - for example, the transform you are using, the data types, etc.

The book Professional SQL Server Integration Services book by Brian Knight has a chapter on creating a custom component. I haven't worked through the example, but if it's like...

Well, lesson learned - I shouldn't try to dispense advice when my mind is on getting out the door on Friday afternoon... You're right, the code is correct as...

Brandie Tarvin (5/16/2008)

---

I didn't look at my code before I submitted the post. The forum screwed it up. Let me try again.

ISNULL(RetroDate) == FALSE && (RetroDate...

Brandie Tarvin (5/16/2008)

---

This is driving me nuts. I've re-written this particular split condition 3 times and it still won't pick up the date.

Date is 01/11/5200. I'm using smalldatetime...

Now, I admit most of the time, I don't consciously remember everything from my college course, but every so often I will be working on something and remember a tidbit...

If you're dealing with a small number of discrete values for the qualifier (the left column on your input), then I would recommend using the Conditional Split transformation. See...

Jeez, this is the fourth QOD in a row that I've answered incorrectly.....

James Summerlin (4/18/2008)

---

Hello Everyone,

We have two softwares, one uses Access 2000 and has a table named Patient. The other uses MSDE and has a table name Patient.

I have already...

Thanks Paul - I took the case sensitivity thing at face value and just created some workarounds. It's good to know that I can use the cache settings to...

Judging from the number of calls I get from recruiters (at least 1-2 a week) I would say the DBA market here in the Dallas area is at least as...

Sounds like a job for a script component. If you've done some VBA programming, you may be able to do this fairly quickly. You can read in your...