none
SSIS how to do Data Mapping at run time RRS feed

  • Question

  • Hi ,

    I am using Export from SQL to Excel using SSIS, and my source Query run time which get pass from C#, same destination as Excel which also get pass from C#.

    but i am using data Conversion for mapping , i have no idea how to mapp from C#, any idea how to do?

    Thanks

    A-


    Ashok

    Monday, April 22, 2013 8:39 PM

Answers

  • This post is very similar to your other post here. The standard Data Flow Task doesn't support dynamic metadata at runtime. There are no tricks or easy workarounds for this. You have to either start implementing code to generate SSIS packages at runtime or consider the other option you already know about.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Wednesday, April 24, 2013 1:41 AM

All replies

  • Hi Ashok,

    I suggest you can use Script Component, please refer to: http://wikiprogrammer.wordpress.com/2011/04/08/dynamic-column-mapping-in-ssis-part-1/

    Thanks,
    Eileen

    If you have any feedback on our support, please click here

    Eileen Zhao
    TechNet Community Support

    Tuesday, April 23, 2013 6:39 AM
  • Thanks for reply,

    your example does know number of columns , so you binding columns at design time, but my case my query ll change,

    actually i want to do export at run time query ll come from C# code so every time different query.

    Thanks

    A- 


    Ashok

    Tuesday, April 23, 2013 1:47 PM
  • This post is very similar to your other post here. The standard Data Flow Task doesn't support dynamic metadata at runtime. There are no tricks or easy workarounds for this. You have to either start implementing code to generate SSIS packages at runtime or consider the other option you already know about.

    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

    Wednesday, April 24, 2013 1:41 AM