Post reply

How to import dbf files with SSIS in a directory

  • December 9, 2011 at 1:58 am

    #149767

    Hello!

    I want to import dbf files with SSIS package in a directory.

    I created SSIS package with this link[/url]

    But, how to more dbf files import to a table of SQL Server with SSIS package?

    Thanks!

  • December 9, 2011 at 7:18 am

    #1419344

    What is your question exactly? Do you encounter any errors?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 10, 2011 at 4:19 am

    #1419702

    Hello!

    Thanks your replay.

    Please see this link: http://salliven.site11.com/dbf_load/

  • December 12, 2011 at 1:00 am

    #1419879

    salliven (12/10/2011)

    Hello!

    Thanks your replay.

    Please see this link: http://salliven.site11.com/dbf_load/%5B/quote%5D

    I'm sorry, but for some reason, your site is blocked by my company's firewall.

    Can you post the details here? You can post pictures by adding them in the attachment of your reply.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 12, 2011 at 1:16 am

    #1419885

    Hello!

    Thanks your replay!

    Those pictures are here:

    1.)

    2.)

    3.)

    4.)

    5.)

    6.)

    7.)

    8.)

    9.)

    10.)

    11.)

    12.)

    13.)

    14.)

    15.)

    16.)

    17.)

    18.)

  • December 12, 2011 at 1:24 am

    #1419887

    Well, since you are linking to the pics on your site, I still can't see them.

    You need to add them in the attachment of your reply.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 12, 2011 at 1:35 am

    #1419889

    Those pictures are here.

  • December 12, 2011 at 2:03 am

    #1419893

    If I understand it correctly, you point your connection manager to a dbf file, but also your source table (through a variable). Why is that?

    The variable that you populate contains the filepath to the dbf file, not to a certain table.

    Furthermore, be aware that SSIS doesn't like changing metadata. You cannot loop over tables and use the same dataflow, if the metadata of each table is different.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 12, 2011 at 2:15 am

    #1419897

    Thanks your replay!

    I want to load all DBF file from a directory (and import a table of SQL server database every Monday).

    Is it possible with SSIS?

  • December 12, 2011 at 2:23 am

    #1419900

    OK, disregard my question about the connection manager. It is not pointed at a dbf file, but at the folder that has those dbf files.

    Regarding the error:

    you probably get that error because the variable doesn't have a value, hence it cannot find a table.

    But as I said before, if the metadata changes for each dbf file, you cannot use one single dataflow with SSIS out-of-the-box. You need to create a dataflow for each dbf file.

    CozyRoc has a commercial component, dataflow+ if I'm not mistaken, that can handle changing metadata. If using 3rd party components is not an option, then you'll need to script it out using .NET.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • December 12, 2011 at 4:34 am

    #1419945

    Thanks your replay!

    The name of dbf files always change (tavszall + YYYY-MM-DD + .dbf; Example: tavszall2011-12-11.dbf).

    If I understand you, then I cannot use simple datafollow task this exercise.

    Thanks your answer!

  • December 12, 2011 at 4:35 am

    #1419946

    Deleted.

Viewing 12 posts - 1 through 11 (of 11 total)

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