Thank you, thank you, thank you!

I found what I need for the month, day and year:

RIGHT("0" + (DT_WSTR,2)DAY( GETDATE()), 2) + "-"

+ RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()), 2) + "-"

...

Thanks for the reference to the post. I think the article does the opposite of what I am trying to do, however. It looks like it is trying...

Thanks, that helps me to retrieve the proper number. However, I'm still confused on how to assign that result to a variable so that I can eventually add the...

Wow, that really worked! I've learned more about SSIS 2005 in the past month than in the previous 2 years! Thanks so much!

Good advice! I have "Professional SQL Server 2005 Integration Services" and hope to look into some VB.Net books.

What is a good way to learn about the SSIS 2005 Script Task and scripting in general?

Now that I have the DestinationFolder, perhaps there is an object in SSIS 2005 that can generate (or commit) a new .csv file based on a change in the value...

Okay, I've figured out a way to concatenate the columns into a destination folder string. The code looks like this:

SELECT

DEAL_NO,

...

I fully agree and I took a similar approach. Thank you very much!

I received an error: "Attempt to find input column vbCrLf."

One small problem: the Derived Column Transformation doesn't seem to recognize Char(10). Here is what I used:

(REPLACE(ReplacedDealName,Char(10),""))

Yup, it's a couple of carriage returns alright! So, how do I get rid of them?

The source column looks something like this:

XYZ12A01[FOUR ODD SQUARES]LP_EXL_ID

Then I use the following REPLACE function within a Derived Column transformation:

LTRIM(RTRIM(REPLACE([Column 0],"LP_EXL_ID","")))

The destination column is varchar(200). The resulting...

So, I should create an Execute SQL Task and put a BULK INSERT command within that task -- is that correct?