none
Need some details RRS feed

  • Question

  • Hi,
    Can I have the full steps/details for one project, which is one step inside?
    1. in Upd_status, do an insert by also capturing the current path and filename of the input Flat file, into StatusTab table in Upd_status and mark the status column of the current column as 'Received'. Here is the SP
    CREATE PROCEDURE [dbo].[Upd_status]
    AS
    declare @para_id int;
    BEGIN
        select @para_id=max(para_id)
        from Transtab;
        
        if (@para_id is null)
        begin
            set @para_id=1
        end
        else
        begin
            set @para_id=@para_id+1
        end
        
        begin tran
            insert into statustab (para_id,status) values (@para_id,'Received');
        commit tran
          return @para_id
    END

    Many Thanks & Best Regards, Hua Min



    • Edited by Jackson_1990 Wednesday, November 28, 2012 2:21 AM
    Wednesday, November 21, 2012 4:09 AM

All replies

  • Hi,

    You can generate schema for this procedure by using add generated item wizard, the generated schema only have one root node, you can create an empty message in orchestration by using mapping or user code,  then send it to database.

    For the detailed information about construct messages, you can refer to:

    Constructing Messages

    http://msdn.microsoft.com/en-us/library/aa547985.aspx


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Thursday, November 22, 2012 9:53 AM
    Moderator
  • Hi,

    You can generate schema for this procedure by using add generated item wizard, ...


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Do you mean to choose these?

    Add Generated items > Generated Schema


    Many Thanks & Best Regards, Hua Min

    Thursday, November 22, 2012 10:07 AM
  • Hi,

    Yes, you are right.

    Add Generated items>Generated Schema Files>Consume Adapter Service


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Friday, November 23, 2012 9:09 AM
    Moderator
  • Thanks.

    1) Can I also have the details to be selected for Receive port in Orchestration?

    2) Leo, do you remember the tutorial I did last time to load the Flat file in Header-detail format? Now do I need to import 'FlatfiletoSql.Typedprocedure_dbo'?


    Many Thanks & Best Regards, Hua Min


    Monday, November 26, 2012 4:28 AM
  • Hi,

    I am prepar for a tutorial, will send it to you via email, there would be some delay. Thanks.


    Leo Tang [MSFT]
    MSDN Community Support | Feedback to us
    Get or Request Code Sample from Microsoft
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, November 27, 2012 1:47 AM
    Moderator
  • Thanks a lot. Please update me once you're ready with it.

    Many Thanks & Best Regards, Hua Min

    Tuesday, November 27, 2012 3:42 AM
  • Dear Leo,

    Please note that I really need to save the current flat file name and its path into a filename column of the table. Here is what the whole project is doing:

    1. in Upd_status, do an insert by also capturing the current path and filename of the input Flat file, into StatusTab table in Upd_status and mark the status column of the current column as 'Received'


    Many Thanks & Best Regards, Hua Min


    Tuesday, November 27, 2012 8:28 AM