I haven't but its certainly doable

http://blogs.msdn.com/b/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx



>Hi Nicholas.
>If you use SSIS to create a Package, Can this be called rrom a c# .exe ?
>Regards,
>Gerard
>
>If you
>
>>Hi Gerard
>>
>>I understand that bcp can do this but I haven't used it much myself.
>>SSIS gives you a lot of control over your process so I find it easier to create packages in that.
>>
>>Nick
>>
>>
>>
>>>Hi Nicholas.
>>>Exporting to a Flat File Format sounds good..... I can investigate this... Can BulkCopy do this or some other command ?
>>>Regards,
>>>Gerard
>>>
>>>
>>>>Same thing but export to a flat file format ? or a monthly database.
>>>>
>>>>BTW this link says the current limit is 10 G
>>>>
>>>>http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx
>>>>
>>>>
>>>>>Hi Nicholas. Thanks for your reply.
>>>>>The table I want to copy is 1.5 to 2 gigs....and needs needs to be done at the end of every month, and say I want to keep 3 years (Which I currenly do in VFP) even with Sql Sever R2 express which I think allows for 8 Gids on a Database , I will quickly run out of space , particulalrly if I want to keep in the one Database
>>>>>
>>>>>I was looking for a way to copy a Table, but outside the database, so that I could easily import it back in again , to say a temporary databse Table, if I needed datat from it.
>>>>>
>>>>>Retards,
>>>>>Gerard
>>>>>
>>>>>
>>>>>>>Hi
>>>>>>>In my app, at month end I need to take a copy of a few Tables, which will be refrred to occasionlly subsequently. I am wondering whats the best way of doing this in SqlServer . I do need to keep a copy of these at a pint in time, but dont particulalrly want to bloat the Database with them.
>>>>>>>The tables typically could be 1.6 Gigs to 2 Gigs
>>>>>>>
>>>>>>>In VFP, I used to just take a copy of the Table (as a free Table outside the database) and append the date to it (so it would be called something like MyTable_27_02_2012). This way, its kept outside the DBC, but I can refer to it easily if i need to.
>>>>>>>
>>>>>>>I have seen a BulkCopyToXml, but am concerned that , because XML causes a lot of bloat, the XML file will end up to be very large. Are there any other options worth considering ?
>>>>>>>Tia
>>>>>>>Gerard
>>>>>>
>>>>>>
>>>>>>Why not create a database on your server and then create a data export package to take a copy of the tables into that. You could schedule that to run once a month.