SQL Server 2008 - Script Data as Insert Statements from SSIS Package?

Use my Export2SqlCE command line utility, which scripts both data and schema in SQL Compact compatible script exportsqlce.codeplex.com SMO does not support SQL Compact syntax and data type conversion.

Use my Export2SqlCE command line utility, which scripts both data and schema in SQL Compact compatible script - exportsqlce.codeplex.com - SMO does not support SQL Compact syntax and data type conversion.

I just tried out the Export2SqlCE utility from a command line and it works great. I had already written code to convert SQL Server schema to SQLCE schema. I wish I had known about this utility before I started rolling my own.

– Brandon King May 11 '10 at 20:38.

It is possible to automate the scripting of all a table's data as Insert statements by using SMO's Scripter. EnumScript method. Here is the code that I came up with... Using conn As New SqlConnection(SqlServerConnectionString) Dim smoConn As New ServerConnection(conn) Dim smoServer As New Server(smoConn) Dim smoDatabase As Database = smoServer.

Databases(smoConn. DatabaseName) Dim smoTables As SqlSmoObject() = New SqlSmoObject(2) {smoDatabase. Tables("Employee"), _ smoDatabase.

Tables("Company"), _ smoDatabase. Tables("Job")} Dim smoScripter As New Scripter(smoServer) With smoScripter. Options .

ScriptData = True . ScriptSchema = False . IncludeDatabaseContext = False .

EnforceScriptingOptions = True . SchemaQualify = False End With Dim outputScript As New StringBuilder() For Each script As String In smoScripter. EnumScript(smoTables) outputScript.

Append(script) Next Return outputScript.ToString() End Using A little too late to help me, I also found some other people who discussed the same challenge at http://social.msdn.microsoft.com/Forums/en-US/sqlsmoanddmo/thread/f456a535-f7c1-49f7-90f4-6a8bf251fd3b.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.