Hi, I need to convert a mdb to a txt file. From a colegue I understood that this can be done wit SSIS (Sequel Server Integration Services). The mdb is the incidents.mdb from Forefront. This conversion needs to be performed on a regular basis so a GUI driven solution won't do, it has to be done by a script that will be scheduled. How can I accomplish this? Kind Regards, Jan Schouls

Hi Jan, This is easily achieved in SSIS. You won't be able to use the wizard as it will only allow writing to a single txt file at a time. However you could use the wizard to generate a template for one table-->file data flow, then replicated that data flow and create new flat file connections for the other tables. It could then be easily scheduled to run with SQL Agent.my blog http://karlberan.wordpress.com/

check the following blog, use flat file destination rather than SQL server table. http://quest4gen.blogspot.com/2009/12/load-ms-access-data-to-sql-server.html Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Hi Karl, Wow... you're fast :-), thanks! I first have to install SSIS (I think). The mdb file which needs to be converted is the incidents.mdb which is created on a Exchange Server with ForeFront on it. I coud not detect any SQL installation on this box, not even MSDE, so I'm a little confused how this mdb is created and where to install SSIS (on a remote SQL box)? I never used SSIS before (I'm not a SQL guy). So what do I need to do in order to get SSIS to work? Wihtin ForeFront it's possible to created a text file in the GUI, but that's not what I want offcourse. Perhaps there is a way to script this exporft, but than I'm probably in the wrong forum. Regards, Jan Schouls

As this forum is dedicated to solve SSIS problems... That's why we suggested you to use SSIS. If you are comfortable with .NET then you have to write your own code. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Hi ETL vs ELTL and Karl, No further assistance is needed. I just found out that the db, is a access db and not a sql db, so SSIS probably won't do the trick. I want to thank you for your help and advice!

SSIS will definitely do the trick. I've just done the same thing. It can read from an access database and write to a txt file.my blog http://karlberan.wordpress.com/

Have a look here for SSIS connectivity options: http://msdn.microsoft.com/en-us/library/bb332055(SQL.90).aspx http://s3.amazonaws.com/jef.mindtouch.com/1007230/37/0?AWSAccessKeyId=1TDEJCXAPFCDHW56MSG2&Signature=xwsdNSCUbob2%2bXLksttlE1zIDQo%3d&Expires=1288274706my blog http://karlberan.wordpress.com/