October 3, 2011 at 7:53 am
i want to create one ssis package which takes values from flat file and insert it into database table depending upon there companyname
for example:
i have table fileds :
Date SecurityId SecurityType EntryPrice Price CompanyName
2011-08-31 5033048 Bond 1.05 NULL ABC Corp
now i want to insert Price into this table but i need to match with CompanyName and in that also in file CompanyName is like ABC so how can i checked that and insert only particular data .. like this i have 20 records in my file with different company names
October 3, 2011 at 8:05 am
Your description doesn't make it entirely clear what you want to do, but it sounds like you may want to use a "Conditional Split" task to evaluate the data in the CompanyName column and reject rows that do not belong to the CompanyName that you want.
October 3, 2011 at 8:11 am
hi..
i want to insert 'price' into price column of my table 'mytemptable' and that price i'm taking from flate file..
in flat file i have company and price like this...
company price
abc cop 87
zz inc 123
now i have one table called mytemptable like this
id company price
1 abc cop null
2 zz inc null
i need to insert price = 87 for company abc cop
and price = 123 for company zz inc into mytemptable...
how do i do this plz help
October 3, 2011 at 8:22 am
Ok. Well, there's a few ways to do this, but a couple of options would be:
Use a lookup task to find the ID of the record in myTempTable where it matches the company name, output the ID and price to another temporary table, then run an Execute SQL Task to update myTempTable by joining to the other temporary table on the ID.
Just output the flat file contents to a temporary table as-is, then run an Execute SQL Task to join on the companyName and update the price.
October 3, 2011 at 8:24 am
can you provide me example link i'm newbie plz help
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply