You cannot load directly to a TSQL variable in SSIS (two different tools).

You can perhaps load the XML file as one giant string into a temp table and then use...

maharaj.narayanan (5/25/2014)

---

Hi,

I'm trying to write the table name and their count of an oracle database. so i hard coded all the select statement with union, when i use the query...

I believe in SSIS 2005 it is called Datareader.

http://msdn.microsoft.com/en-us/library/ms137897(v=sql.90).aspx

Nice and easy question, thanks.

KoldCoffee (7/17/2014)

---

...besides, I gave a whirl and the package failed on the execute process task, whereas when I use nvarchar the remainder of the tasks complete...and error with :

"Warning: The...

marg 14154 (7/16/2014)

---

Thank you so much. You have helped a lot!

Just one more thing, there is some cases in which there are some values that should be on the same...

I would put foreign keys to table A-D into the customer table.

Join all tables together and then a giant case statement that calculates the custome type.

Or are the business rules...

Here's a starting point:

Masking Personal Identifiable SQL Server Data[/url]

Sean Lange (7/16/2014)

---

Lynn Pettis (7/16/2014)

---

Anybody? Can anybody please step in again and try helping me with WC? Frustrated, can't seem to get him to realize I just don't...

Raghavendra Mudugal (7/16/2014)

---

You...

Well, a primary key (constraint) can be considered an object at the logical level, while an index exists purely at the physical...

Take a look at the STUFF function.

Ever used google before?

http://stackoverflow.com/questions/190776/how-to-have-dynamic-sql-in-mysql-stored-procedure

When there are multiple candidate...

Put a breakpoint on the for each loop and before it starts iterating check if all the values of the variables and the expressions are what you expect.