Sure I can:

It's not that hard...

Why would you want to take one random record of each table and put it in a flat file?

Charmer (2/7/2012)

---

so how...

Ted Zatopek (2/6/2012)

---

Cool, thanks for the idea! I can't say that I fully follow all the details on my first pass of reading that, although I do get...

Because an object variable is a .NET object. It is like a ADO.NET rowset.

A configuration file is an XML file, it contains strings.

object variable <> string

A bit back on-topic:

http://www.sqlservercentral.com/Forums/Topic1247840-364-1.aspx

Not really a worse question, but a weird one. (read all the way to the bottom)

What would justify such a business scenario?

So if I'm not mistaken, you need to take one record from each table (a random one, as no ORDER BY is specified), and you need to concatenate it to...

johnitech.itech (2/6/2012)

---

One common cause for the ACT7 service to stop is when Windows Automatic Updates attempts to install an update to SQL. The Act7 instance is protected - the...

simhadriraju (2/7/2012)

---

Before exporting i have some other data (XYZ ) from a derived columns taks which need to be concatenated . to this data mentioned in the requirement and...

I've got the link from this thread:

http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/8426a046-ff5c-4d3a-84c0-045a3c1d4138

It appears that someone is having the same issue.

Wouldn't it be easier to write a SQL query that retrieves all those values in one statement (you can use the TQSL UNION clause to link different statements together) in...

edit: not a double post

Did you set the property of the variable to EvaluateAsExpression?

What is the datatype of the Health_Plan_ID variable?

If it is an integer, you need to cast it to a string first.

ps: this is just an expression, regular expressions are...

Why this scenario? What are you going to do with hundreds of seperate variables?

Elmer Miller (8/27/2008)

---

I have an OLEDB source in a Dataflow and am trying to use parameters with a DataAdd function like this:

SELECT OrderNum

FROM Orders

Where OrderDate >= DATEADD(D,?,GETDATE())

Apparently SSIS thinks the...