rs80 (4/1/2013)

---

The value of the variable ExceptionReportPath is C:\Reports\ and the expression is set to C:\Temp\. So during runtime I'd like the excel file to get produced in...

rs80 (3/29/2013)

---

I'm using SQL Server 2008 BI. I have an oledb source outputting data into an excel destination. I want the file to be created as different instances...

chris.rogers00 (3/28/2013)

---

I'm calling a child package in a for each loop from the parent, the child loads data from a flat file then returns to the parent. Back inside the...

Eugene Elutin (3/19/2013)

---

kl25 (3/19/2013)

---

Agreed. 🙂 My query just presents the results in the format the OP...

Agreed. 🙂 My query just presents the results in the format the OP listed at the...

Here's one possibility.

Select

dw.day + ' ' +

(

Select sts.Subject + ' '

From SubjectToStudy sts

Where dw.WeekID = sts.WeekID

Order by WeekID

For XML Path ('')

) as list

From

DAYOFWEEK dw

;

I add an annotation block to the package and keep high level revision history there. The packages are source controlled but the annotation block gives me a quick record...

Here's another option.

REPLACE((DT_WSTR, 10)(DT_DBDATE)GETDATE(),"-","")

Here's another option:

SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),6,2) + SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),9,2) + SUBSTRING((DT_WSTR,10)(DT_DBDATE)GETDATE(),1,4)

latingntlman (2/27/2013)

---

Now, I need to send an email upon successful FTP task with the record count from the .TXT file, but I'm not sure if I need to do this...

Here an article by Andy Leonard that demonstrate how to put data from a result set into variables.

Object Variables, ResultsSets, and Foreach Loop Containers[/url]

If you have multiple rows in your...

I agree with Sean. Please see the link he has referenced. We'll be able to give you better help with more complete information.

In the meantime, take a look...

1. Set a string variable...

You're welcome. Glad you got the issue worked out. 🙂

Here's the general approach I use:

1. Set a variable for the path (folder). Learned early on to separate the path because paths that I thought would NEVER change...