Check the permissions on the path and validate that the path is correct (file names included). Also make sure the files have been copied to the same path location...

JAZZ Master (1/3/2013)

---

SGT_squeequal (1/2/2013)

---

crookj (1/2/2013)

---

In...

Tbmabry, did this post by dwain help you?

dwain.c (1/2/2013)

---

Instead of write-only code, I've always found it immensely helpful to split up complex string manipulations for readability into individual parts using...

In that case I would most likely replicate those two tables.

But since you insist on using SSIS, you can create an agent job and then put a trigger on those...

jon.spain (1/2/2013)

---

At a previous employer, we played "donuts". If you walked away from your station and didn't lock it, then whoever noticed this would pop up a new email and...

Thanks for the question.

From what you describe I would say SSIS is the wrong technology to use for your needs.

It appears that you need replication or logshipping and not SSIS.

Can you clarify your...

Steve Jones - SSC Editor (1/2/2013)

---

There isn't a way to do this. While SSIS is a separate part of SQL Server and can be deployed without the database engine, you...

I have used several VPN clients and have had no issues. What VPN software are you using? Have you checked with your IT team to determine if they...

So of the 9 parameters you listed, which 6 are possible? ...

Other than Case 6, do you expect to have the ability to have multiple conditions in the where clause?

It looks like you have some data that does not meet the requirements (an invalid email address or the @ symbol is present without an email address).

Can you provide sample...

You cannot deploy a 2012 package to SQL Server 2005.

However, you can use SQL Server 2005 in your connection manager. But the package must be run from SQL 2012.

Steve Jones - SSC Editor (1/2/2013)

---

If I have...

Nice discussion going on here.