Welsh Corgi (12/13/2011)

---

Why would you want to import the data from a CSV, then match on the SSN and/or DOB and turn around and export back to a...

Just as long as you wear the Cowboy hat

remedy

ciao

Elliott Whitlow (12/13/2011)

---

However, may I ask a dumb question. You are importing from a CSV and then eventually exporting a CSV file. How are they different, why is...

Evil Kraig F (12/13/2011)

---

Revenant (12/13/2011)

---

GSquared (12/13/2011)

---

And the only cure is beingectomy - in other words, you have...

Add a new data flow. In that flow, pull in the data from the database you just created and then connect that to a flat file destination.

Threadizen = Zombie

Thanks for the question.

It sounds very good.

jcrawf02 (12/13/2011)

---

Favorite email exchange of the day (after the other party read the recursive CTE date article in the newsletter, and I pointed them to Jeff's comment/article in the discussion):

From:...

Not all tables have extended properties. The way you constructed the query to rely on major version and minor version requires extended properties to be declared prior to the...

bitbucket-25253 (12/12/2011)

---

LutzM (12/12/2011)

---

Evil Kraig F (12/12/2011)

---

...

Nah, he used the front portion of the crown. It's about the hardest portion of your body, he's fine. I've done that a...

Try this:

SELECT t.name As Tablename,

c.name AS ColumnName,

ty.name AS TypeName,

c.is_nullable As Is_Nullable,

c.is_identity As Is_Identity,

ep.Value As TableDescription

FROM sys.tables AS t

LEFT OUTER JOIN sys.extended_properties AS ep ON t.object_id = ep.major_id

LEFT OUTER JOIN sys.columns...

Oh, and the link provided by Bru is what I would have recommended. Empty the files to other files in the group and then drop the file - you...