flat file
-
hi
i need to take multiple flat file using ssis,what component and configuration do i need to make it possible?
-
shah.simmy (2/15/2012)
hii 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.
-
herladygeekedness (2/15/2012)
shah.simmy (2/15/2012)
hii 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?
-
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 -
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.
-
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)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply