Add the headers associated with, and particular fileds.

Question

Add the headers associated with, and particular fileds.

preensheen

Ten Centuries

Points: 1362
More actions
October 18, 2010 at 8:22 am

#143188

I have a similar senerio to that as in this link
http://bi-polar23.blogspot.com/2008/02/dynamic-flat-file-destinations.html
Here we don't have and ID associated with the Departmnet. But in my case I have the ID'S associated with that department and I want the id to be the header of the CSV AND department name to be at the file name extension.
Please help me how I can get along this situation.
Thanks,
Preensheen

Viewing 12 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 1

I think you'll get much better responses to your questions if you post all the information required to answer your question. I'm not going to go read that blog to see what you're talking about.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

preensheen Ten Centuries Points: 1362 More actions · Answer 2

Alvin Ramard (10/18/2010)
I think you'll get much better responses to your questions if you post all the information required to answer your question. I'm not going to go read that blog to see what you're talking about.

OK, I having a data coming from different tables for different departments. I have to load the data to the csv and...should have different files for different departments. The department will have the deptname and dept id.

I should have the departname as the header in the csv and the deptid should go to the file name as an extention.

I am able to use the dept id and put it into a for each loop and am able to get different csv's. But not I am not able to map the header to that. Could anyone help me

hope this explains...

Thanks,

preensheen

GSquared SSC Guru Points: 260824 More actions · Answer 3

I'm not sure what you mean by wanting to have the department name in the header. Do you mean as a row in the file?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Phil Parkin SSC Guru Points: 246960 More actions · Answer 4

Please provide some sample data, showing what your source looks like and what you would like to see in your destination. Your explanation is confusing.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

preensheen Ten Centuries Points: 1362 More actions · Answer 5

Phil Parkin (10/18/2010)
Please provide some sample data, showing what your source looks like and what you would like to see in your destination. Your explanation is confusing.

My source looks this way

And Now My output should be two CSV'S..one should have sales information and other should have IT information. And also the CSV SHOULD HAVE A HEADER and the header should be the departname. And the csv file extention at the destination should have deptid..

Hope this is more clear..

Thanks,

PREENSHEEN

Phil Parkin SSC Guru Points: 246960 More actions · Answer 6

Your data is nowhere to be seen ...

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

preensheen Ten Centuries Points: 1362 More actions · Answer 7

preensheen (10/18/2010)
Phil Parkin (10/18/2010)
Please provide some sample data, showing what your source looks like and what you would like to see in your destination. Your explanation is confusing.
My source looks this way
And Now My output should be two CSV'S..one should have sales information and other should have IT information. And also the CSV SHOULD HAVE A HEADER and the header should be the departname. And the csv file extention at the destination should have deptid..
Hope this is more clear..
Thanks,
PREENSHEEN

Phil Parkin SSC Guru Points: 246960 More actions · Answer 8

Anyone else following this?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

GSquared SSC Guru Points: 260824 More actions · Answer 9

By "IT SHOULD HAVE A HEADER", do you mean a row at the top that just says, "IT" (or whatever)? Does it also get column headers?

There are easy ways to do that, but they involve writing to the file directly, usually using a .NET assembly or something similar. Are you comfortable with writing to text files?

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 10

GSquared (10/18/2010)
By "IT SHOULD HAVE A HEADER", do you mean a row at the top that just says, "IT" (or whatever)? Does it also get column headers?
There are easy ways to do that, but they involve writing to the file directly, usually using a .NET assembly or something similar. Are you comfortable with writing to text files?

I'm on the same page.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

preensheen Ten Centuries Points: 1362 More actions · Answer 11

Hi All, Thanks a lot for the effort and help you provided.

I have resolved the issue. I have added a excute sql task inside the for each loop. The result of the for each was the parameter input to the excute sql task and the it gave me the deptname and which I stored in the variable and then added that variable to the header.

Thanks Again,

Preensheen