Copy List Item to SQL

[gnosis13]

I have a "bucket brigade" of lists. Items entered in the first list are later moved to the second list via workflow. After 30 days the 2nd list data gets dumped to a SQL table as archive. For now I am making the dump to SQL using MS Access which works ok but makes me part of the process. I would like to use a workflow to pause new list items for 30 days then move them to SQL automatically so I can go to the beach and such.

I am currently using SharePoint Designer for workflows. I can't figure out how to get it to use the SQL table. Suggestions?

I would like to avoid using a lot of coding because I will have to involve our programmers and they are very busy and grumpy.

 

[FourFlaggs01]

I found this solution when I ran into the permissions issue for my current project.

The SharePoint list source and destination adapter created by CodePlex works well in my production download (I pull data from 20 SharePoint lists into 1 SQL table).

http://sqlsrvintegrationsrv.codeplex.com/Release/ProjectReleases.aspx?ReleaseId=17652

Just install on the SQL server. Viola!