Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > Other .NET > Biztalk
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Biztalk General discussion about Biztalk server.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Biztalk section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
View Poll Results: Is this possible thru the combination of a Tbl Looping and Tbl extractor functoid?
Yes 0 0%
No 0 0%
Voters: 0. You may not vote on this poll

Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 17th, 2010, 06:45 AM
Registered User
 
Join Date: Aug 2010
Location: Mumbai
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Passing a hardcoded value and manipulating data before passing it to Database table

Guys, this is not a scenario from the BizTalk book, but one that I am in the process of integrating.

I have a scenario in which i get a pipe delimited flat file which I have to send to SQL. I have three columns viz. Description, Amount and Code in SQL. I have three important queries :

1. I have a few columns in the SQL table in which i need to pass on a hardcoded value and these columns have no corresponding fields in the flat file.Eg: If description of a column in the file is NET Sales, then Code is 40004.

2. I have a few columns in which i have to pass a specific value and these fields have got corresponding values in the flat file.Eg: If Net 2 Sales Quarter is the description in the file, then i need to pass it as Net Sales.

3. I need to add the Amount for certain values in the File and pass on the whole set of values in the file to a single row in SQL with the specific values:Eg: I have the flat file values as the values below and I need to add the two amounts and pass a specific description and the code a specific value as usual to the database table:

Description Amount

Net Sales $500

ManagerSalary $30000

The SQL table data for the above data would be:

Description Amount Code
Total Sales $30500 98098



Looking forward to your help at the earliest.
__________________
A true warrior is not one who never loses, but one who never quits!

Last edited by Abhishek Iyer; August 18th, 2010 at 05:12 AM.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
passing data annumol J2EE 1 June 25th, 2009 06:03 AM
Passing table name as parameter in a DTS Package nimma SQL Server DTS 2 January 7th, 2005 01:24 AM
passing data texasraven HTML Code Clinic 0 March 3rd, 2004 04:03 PM
Manipulating data in a database - page 396 problem Jams30 BOOK: Beginning PHP4/PHP 5 ISBN: 978-0-7645-4364-7; v5 ISBN: 978-0-7645-5783-5 1 October 17th, 2003 03:13 PM
passing table as a parameter to stored procedure pankaj_daga SQL Server 2000 7 September 30th, 2003 05:11 AM



All times are GMT -4. The time now is 09:46 PM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.