Post reply

dynamic export to MS Access

  • July 14, 2006 at 1:42 am

    #649154 

    just to better the format 
    _____________________________________________________
    hi guys,
    I try to build a SSIS package for dynamically exporting one big table from SQL2K5 to Access db;
     first important parameter is max file size of mdb (set as variable) and path for saving.
    When mdb exceeds max file size, package should build a next mdb files, each not bigger then max file size.
    What kind of package should I use? Execute SQL task? Conditional Split? What's better?
     rgs
    Crln
     

Viewing post 1 (of 2 total)

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