I have participated in a migration from Sybase to SQL Server...I was handed specific requirements to cleanse and standardize the data during the migration. I evaluated several options including SSIS...

Sure, nor did I obviously 😀

I am trying to further this example to learn how to present multi-level...

drew.allen (3/3/2011)

---

opc.three (3/3/2011)

---

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...

You're very welcome 😀

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