Hi,

Below is the code I think you are looking for. I also recommend coding in the affirmative rather than the negative.

(ISNULL(COL1_FK) ? (ISNULL(COL2_FK) ? COL3_FK : COL2_FK) : COL1_FK)

You...

John Rowan (11/10/2009)

---

Well, I always say I learn something new every day and today is no exception.

The expression builder is not available from the flat-file destination properties window when working...

You can probably get away with just two Data Flow Tasks to generate the file. The first Data Flow Task would generate your Header and Detail records for the...

I don't know how this is done in DTS exactly. But I see that you have posted in SQL Server 2005, so I will make the assumption you are...

No one has provided an answer to my post, but I was able to get my package to run and insert the data in to my table. I don't...

Another way to do it is using a function like InStr called CHARINDEX in SQL Server as follows:

SELECT CASE

...

I find this issue to be very challenging and time consuming when trying to complete my development work. I'm sure we would all love to be able to have...

If you are trying to use the SQL Server Agent to run the job, I believe it doesn't run under your account. The job runs under the account that...

I maybe missing something here, but if you have the objects in VSS (Visual Source Safe) already then you should just be checking out the file version from VSS then...

Jeff Moden (2/3/2009)

---

Heh... had to stick with the "No RBAR" theme, somehow and still do the Star Wars...

If they use oil, I'm all for replacing with user massages.

Hi Michael,

I was attempting find a solution for you but after I ran a query against the system tables for a possible solution I realized it was probably a simplification...

That is an excellent point Lynn. I have battled with that such difference several times myself in the past.

I believe you would want to use -3 to get the prior 3 months boundary.

You could also use the Conditional Split object in the Data Flow. You would check for null on the column that can not be null and place those down...