Can't use BCP. it is for a selective subset of the table

Also this is for a remote deployment application that will be inside a db project in VS 2012

I am not a fan of cursors either, SqlExecute would be better than that, but I am not a fan of that either.

Yes they do. This requirement is for a Content deployment service of sorts

Here is the output form the process that is needed:

INSERT [dbo].[Address] ([ID], [Address1], [Address2], [City], [State], [ZipCode], [AddressTypeID], [IsPrimary], [CountryId], [Address_no_old]) VALUES (4, N'52123 Go Street', N'', N'Othertown', N'CA', N'92610',...

In the end I need to be able to access the data in the table using the object_ID of the table and the columnID of the data column along with...

I saw that, but it does not work for my application.

I need to create a adaptive insert statements transferring data in one table to a table on a different server....