m_swetz (3/10/2015)

---

OK, got a strange problem for which resolution has been eluding me.

I have an SSIS package that loads multiple electronic data interchange files via a ForEach Loop. There...

Using RegEx might be the quickest way to identify and remove these...

I recently did this but I don't have the details in from of me.

If I remember correctly, in the Execute Package task expressions, look for Package Name. Set that to...

Eric M Russell (3/9/2015)

---

I wish that Microsoft would put a bit more development into the SSMS Database Diagrammer tool. It's OK, for basic modeling, but it's limitations quickly become apparent...

Andrew..Peterson (3/9/2015)

---

Alvin Ramard (2/19/2015)

---

This editorial came on an interesting day.

A few hours ago I decided I need to get my hand on a cheaper option to Erwin or DB Artisan....

ericwenger1 (3/5/2015)

---

I need to be able to see if the incoming csv file had a head row different than the previous files header row. That will tell me that I...

Licensing cost is the first reason I see that might explain why a manager...

Since reprocessing seems to fix your problem, the first thing I would check for is steps that are sometimes are not getting executed during your update process.

Jeff Moden (3/3/2015)

---

Matt Miller (#4) (3/3/2015)

---

By the way - there are several examples already documented. This one's a fairly solid example (describing a similar process)

http://www.mssqltips.com/sqlservertip/1761/how-to-use-the-unpivot-data-flow-transform-in-sql-server-integration-services-ssis/%5B/url%5D

That said - you're...

Would this help?

http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/

Have you looked at the possibility that some of the data might contain unprintable characters, like CR, LF, TAB, etc.

These can make the data look identical to the human eye,...

I would use a variable to hold the name of the directory you want to copy the files to.

I would use a script task to set the correct value of...

Steve Jones - SSC Editor (2/19/2015)

---

Alvin Ramard (2/19/2015)

---

This editorial came on an interesting day.

A few hours ago I decided I need to get my hand on a cheaper option to...

WRONG!

SISS can do a lot more than just ETL!

Select @@Servername shows the instance you are connected to, not the default instance.