What do you mean you couldn't create the Data Flow Task? Did you not create 2 Data Flow Tasks as described in the earlier steps?

Sean Lange (11/12/2014)

---

John Dempsey (11/12/2014)

---

Some opinions are the stored procedure code for an application should reside with the application database even if the stored procedure doesn't refer to any objects...

Agreed Sean. I prefer to keep stuff in the same database to avoid cross database joins, but only when the data is related to each other. Unfortunately, in...

nishi.modgil (1/28/2013)

---

Has anybody achieved the short cut to add 'HEADER' or 'FOOTER' to a flat file . Using rowcount i got the number of records written to file , and...

Your welcome.

rs80 (1/10/2013)

---

Thanks John. In the process of trying it out. I haven't done step #5 before. Can I follow the steps from this article: http://www.ssistalk.com/2007/04/04/ssis-using-a-script-component-as-a-source/?%5B/quote%5D

I...

rs80 (1/10/2013)

---

This post has been active for more then 3 years 🙂

How would I go about adding a record count in the footer? The record count would capture...

I would recommend trying to create a separate Script Task to display the variable to see if it stays changed outside the assigning task.

Sharon,

For you variable you are using for the Header, do you have it set to evaluate as expression? You are at the point where it is hard for me...

sharon.poirier (11/29/2012)

---

Hi John,

Thanks for keeping with me on this. I did as instructed and I am getting my header record in my file, however, two things are not correct:

1....

sharon.poirier (11/28/2012)

---

Thanks John,

Yes it helped tremendously and have successfully appended my footer to end of my detail file. I have another question with the header.

In item #3...

sharon.poirier (11/27/2012)

---

5. Open up the second data flow and create a source for your footer, I used a script component as an input data source, mapping the source row to...

Grant Fritchey (4/5/2012)

---

Any time you want to see the warts & all presentation, come watch mine. I don't hold back. We have a ton of advantages over Visual Studio. They...

GSquared (4/5/2012)

---

I always keep a DDL store of some sort or another, to be able to deploy a copy of a database. I also keep DML statements for creating...

Grant Fritchey (4/5/2012)

---

steve.hansen (4/5/2012)

---

This is an excellent (and timely) topic. We're pondering this same question right now, but we have a challenge that we haven't quite figured out how to...