June 8, 2007 at 12:49 pm
I am new to SSIS or for that matter even to DTS. I've a BCP'ed out file in native format, which I want to import into multiple tables depending upon the value of a particular column. So I cannot use bulk import task, I am looking into flat file connection but it does not seem to support native format files.
Any suggestions/pointers would be appreciated.
June 10, 2007 at 9:35 pm
why not just use BCP to import the data?
---------------------------------------
elsasoft.org
June 11, 2007 at 7:25 am
Thanks for the response.
As I said in my original post, I want to load the data into multiple tables (each with different schema) based on the value of a particular column in the input. I can always use a staging table to BCP into and then do what I want from that table, but the problem this is not a one time thing and I've to process lot of such files each day and do it as fast as possible, so I want to do this in the best possible way to save on processing time.
June 11, 2007 at 9:45 am
I would think that loading into a staging table with bcp is the way to go, even if this is not a one-off.
it will be much more maintainable to write code that selects from a staging table as appropriate, rather than code that parses a native bcp file for certain values.
---------------------------------------
elsasoft.org
June 13, 2007 at 1:53 am
BCP native format is just that - native.
SSIS flat file source would not understand the file as it is binary and not necessarily clear text.
As said, you have to bcp it into a temporary table (not a #table!) and the use SSIS to do what you want with it.
You can use the Execute Process Task in SSIS to handle the bcp.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
June 13, 2007 at 8:18 am
Thanks Crispin and Jezzamine.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply