If you're just looking for an SQL script with all data in a database scripted out as DML commands (similar to what mysqldump can do) you can get that from...

Try this:

http://www.sqlservercentral.com/Xml/Rss/articles

Thanks, nice tip 😉

Check out RedGate's SQL Data Compare tool @ http://www.red-gate.com

Is this what you meant?

SELECT B,

C,

D,

...

Opening an SSIS package in a text editor and changing the server name does work, I have done it that way to do changes en masse.

I do not know...

Just FYI using NOLOCK in an UPDATE or DELETE statement has been marked as deprecated in SQL 11 (Denali).

Try this:

SELECT b.value('(offerId)[1]', 'Int') AS [offer_id],

fr.value('(internetPrice)[1]', 'decimal') AS [internet_price],

fr.value('(newStandPrice)[1]', 'decimal') AS [news_stand_price],

...

If your SSIS package are stored in SQL Server you can query the contents of them using LIKE with wildcards the same way you can query sys.sql_modules for references in...

Please post the DDL and DML.

Related post from same OP: http://www.sqlservercentral.com/Forums/Topic1072204-148-1.aspx

My fault, I missed the distinction you made. SSIS does not handle embedded column delimiters or embedded text qualifiers as robustly as I would like. SSIS will however handle embedded...

Some thoughts:

1. Don't use Hungarian naming for your procs, i.e. don't prefix with sp.

Try this code:

ALTER PROCEDURE dbo.compare_orders

AS

BEGIN

SET NOCOUNT ON ;

DECLARE...

Again? The answer is no 😎

http://www.sqlservercentral.com/Forums/Topic1072170-148-1.aspx#bm1072206

Erland has been around the SQL block a few times and he makes some pretty good points as to why not to use INSERT-EXEC as a general development technique:

http://www.sommarskog.se/share_data.html#INSERTEXEC