flat file

Question

flat file

shah.simmy

SSC-Addicted

Points: 476
More actions
February 15, 2012 at 1:33 pm

#268437

hi
i need to take multiple flat file using ssis,what component and configuration do i need to make it possible?

Viewing 6 posts - 1 through 5 (of 5 total)

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

herladygeekedness SSCertifiable Points: 5878 More actions · Answer 1

shah.simmy (2/15/2012)
hi
i need to take multiple flat file using ssis,what component and configuration do i need to make it possible?

Configuration, I don't know, that would be custom to your environment.

For flat file input, use the flat file source component.

Phil Parkin SSC Guru Points: 246991 More actions · Answer 2

herladygeekedness (2/15/2012)
shah.simmy (2/15/2012)
hi
i need to take multiple flat file using ssis,what component and configuration do i need to make it possible?
Configuration, I don't know, that would be custom to your environment.
For flat file input, use the flat file source component.

A little terse, and does not address the multiple-file requirement. Having said that, the question is so broad as to be close to worthless - a detailed answer would occupy a small book. My answer would be along the lines of: Use a Foreeach container with a dataflow to iterate around the files and load them.

But if the OP can build the actual solution given that response, a round of applause is due.

A question for the OP: I'd like to build a car using some bits of metal, some wood and some electrical components. Which tools do I need?

See the problem?

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Koen Verbeeck SSC Guru Points: 259125 More actions · Answer 3

Phil Parkin (2/15/2012)
A question for the OP: I'd like to build a car using some bits of metal, some wood and some electrical components. Which tools do I need?
See the problem?

You have wood in your car? 😛

(pun intended! :hehe:)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

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

Koen Verbeeck (2/16/2012)
Phil Parkin (2/15/2012)
A question for the OP: I'd like to build a car using some bits of metal, some wood and some electrical components. Which tools do I need?
See the problem?
You have wood in your car? 😛
(pun intended! :hehe:)

I have no car (in London, they're not that useful), but was imagining a classy grained fascia in the Aston Martin-like car I would like to build, from my melange of components.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel

Jeff Moden SSC Guru Points: 1004434 More actions · Answer 5

Koen Verbeeck (2/16/2012)
Phil Parkin (2/15/2012)
A question for the OP: I'd like to build a car using some bits of metal, some wood and some electrical components. Which tools do I need?
See the problem?
You have wood in your car? 😛
(pun intended! :hehe:)

Wooden ya know it? 😛

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)