Post reply

Creating Flat File from SQL Server 2k5 data

  • May 20, 2008 at 10:51 am

    #122156

    Hi. I haven't been using 2005 very long. I am wanting to use SSIS to create a package that can pull data out of SQL Server 2005 (I've created two views and one multi-table UDF to obtain the needed data) and create a flat file. I need to take the the data from each column of my SQL tables/views and write it to a line in a flat file. I'm sure this is pretty simple with SSIS, but I'm a bit overwhelmed about where to start? Can anyone help me out a little bit?

    In particular, can the package allow for interaction from users to indicate where to place the newly created file? Do I need to use 'Execute SQL Task' to process through my tables\views?

    Can I access\run an SSIS job from inside an ASP file??

    Thanks!

    ~mj

  • May 21, 2008 at 2:37 pm

    #818872

    One way that you can control the output location of the file is by exposing the connection manager behind your output flat file as a value in a configuration file. This can be done under the SSIS>Package Configurations... menu entry. Then the config file can be edited directly, or overridden with a command line argument in a console window or batch file.

    Depending on how your UDFs are set up, you might need Execute SQL tasks to pass the parameters or results back and forth, but simple data flows should suffice to handle your views.

    I've not tried using SSIS through an ASP app, so I can't help much there.

  • May 21, 2008 at 2:48 pm

    #818875

    Hello!

    Thank you for your input. I didn't think about using a configuration file to manage the file output.

    I did come up with an ASP solution to do what I needed to do but I am still wanting to try it via SSIS so any help is valued.

    Thanks again!

    mlj

    ~mj

  • May 23, 2008 at 4:57 am

    #819588

    Hey,

    Maybe consider placing your connections into a SQL server database.

    That way you can have your users access these connections through your ASP page, and this will pass to SSIS seamlessly as package configurations.

    To export everything to a flatfile is relatively simple enough....

    ~PD

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

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