Post reply

Automate ' Flat File Connection Manager Editor' to assign column's data type

  • June 29, 2015 at 7:09 am

    #398665

    Hello,

    I am creating a package in SSIS 2008 by using Flat File Connection Manager to import data in tables from CSV Files.

    For each time I am assigning column names and their data type in 'Flat File Connection Manger Editor' under 'Advanced' tab manually. I have to do same process with a big database having more than 80 tables having big list of columns. Assigning column names and their corresponding datatypes manually in 'Connection Manager Editor' is big job.

    Is there is any other way to automate it by using tables in database or by using any csv file having format of each table 'column name - data type'.

    To make this task much simpler.

    Thanks

  • June 29, 2015 at 9:42 am

    #1808811

    Did you try Suggest Types under the Advanced in the Flat File Connection Manager Editor?

    Gerald Britton, Pluralsight courses

  • June 29, 2015 at 11:40 pm

    #1808972

    Yes, I already used that 'Suggest type'.

    But I need some way by which I can add column names and their data types from any CSV or tables from database rather than typing them manually each time in editor.

    is it possible?

  • June 29, 2015 at 11:45 pm

    #1808973

    The only thing that comes to mind that might allow that is BIML.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • June 30, 2015 at 12:00 am

    #1808974

    I am not aware of BIML.

    Could you please provide me more information or some links to understand BIML so that I can move further on the same.

    Thanks

  • June 30, 2015 at 12:08 am

    #1808976

    There is a Stairway devoted to it here[/url].

    I'm not saying that it will be easy, by the way. But you may find something useful in there in terms of being able to automate the coding of packages ... even if you automate only the coding of the connection managers, it sounds like it could help.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

  • June 30, 2015 at 12:15 am

    #1808978

    Please check this.

    http://www.sqlservercentral.com/stairway/100550/

    http://www.mssqltips.com/sqlservertip/3094/introduction-to-business-intelligence-markup-language-biml-for-ssis/

    [font="Calibri"]Raj[/font]

  • June 30, 2015 at 12:34 am

    #1808980

    dfine (6/30/2015)

    Please check this.

    http://www.sqlservercentral.com/stairway/100550/

    http://www.mssqltips.com/sqlservertip/3094/introduction-to-business-intelligence-markup-language-biml-for-ssis/

    For someone with so many SSC points, I'm surprised that you don't know how to insert links.

    The first link was the same as mine, and

    here[/url] is a clickable version of the second.

    The absence of evidence is not evidence of absence.
    Martin Rees

    You can lead a horse to water, but a pencil must be lead.
    Stan Laurel

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply