Post reply

Extract from a SQL .mdf file

  • July 2, 2008 at 9:09 am

    #122379

    Hello all,

    Wondering if this can be done. I'm developing an VB.NET app and it is using a SQL .mdf file (in it's data directory) as its database. I want to do some testing on some of the data in the tables. Before I begin that testing I just want to extract a few of the tables into flat files.

    Seems simple enough. But unfortunately I'm not sure which source dataflow object I need to use since the ole source only lets me connect to a full blown SQL Server and not an SQL .mdb file. Is there a way to connect to and extract data from a SQL .mdf file in SSIS?

    Thanks,

    Strick

  • July 2, 2008 at 9:30 am

    #837306

    The MDF specification isn't available. This is meant to be read by the SQL Server service only. To extract tables, you'd connect to the SQL Server service and select them out.

  • July 2, 2008 at 9:39 am

    #837310

    Thanks, I figured as much... kinda sucks.

    So out of curiosity, if this were an ASP.NET app with the .mdf in its data directory and I wanted to have SSIS handle the data flow and transformation side since its easier for it to do that than write code for it, I coudn't do it?

    Strick

  • July 2, 2008 at 9:43 am

    #837313

    And to add... That is really bad that SSIS won't let you connect to a SQL database file but you can connect to access dbs and flat files.

    Strick

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

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