Post reply

dynamic export to MS Access

  • July 14, 2006 at 12:57 am

    #115772 

    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? rgsCrln

  • 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 2 posts - 1 through 2 (of 2 total)

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