Post reply

SSIS importing multiple DBASE IV files.

  • August 1, 2007 at 11:37 pm

    #118022

    Hi guys

    I have created a SSIS package that can import a single DBASE IV file using the jet connection.

    Has anyone had any success importing multiple files using the ForEach container and dbf? It doesn't seem to accept the variable and throws up an error.

  • August 2, 2007 at 2:16 am

    #724094

    How about sharing the error?

    If you use SQL in a variable and supply that to the source, it should work.

    Post the error and we may be able to help/

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

  • August 2, 2007 at 4:34 pm

    #724346

    Hi Crispin

    I am using a defined variable in the Foreach container called FileName, which is grabbing the file name from a directory. It contains a dataflow task, with the source using the Jet 4.0 driver DBASE IV specified. Data access mode is Table name or view name variable with variable name FileName as specified in the Foreach container.

    I have used this method with the Foxpro driver with no worries, however it does not import dbf iv files correctly. I have an OLE DB destination connected which seems to be working fine (picks up the table for matching fields).

    This is the error I am getting.

    Package Validation error -

    Error at dataflow task[source[48]]: A destination table name has not been provided.

    Error at data flow task[DTS.Pipeline]:"component "Source" (48) failed validation and returned validation status "VS_ISBROKEN".

    Error at data flow task[DTS.Pipeline]: One or more component failed validation.

    Error at Data Flow task:There were errors during task validation.

    (Microsoft.DataTransformationServices.VsIntegration)

    Brett

  • August 2, 2007 at 7:39 pm

    #724369

    Found the problem and now have it working perfectly.

    The variable FileName in this instance must have an initial value (first file in the directory without extension),it appears when using the Jet 4.0 driver.

    Also use name only and not fully qualified in the ForEach container.

    Brett

  • August 3, 2007 at 12:09 am

    #724391

    Try setting Delay Validation to true for the connection manager. That way you don't need to worry about the initial value.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Viewing 5 posts - 1 through 4 (of 4 total)

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