That might be the issue.

Check if there are any validation warnings when running the package.

Are there any configurations in the package?

er.lokeshsharma08 (5/25/2014)

---

Very clearly laid out. Thanks. My query is that I have sql server 2012 edition with sql server data tools (2010 edition). I have managed to make a ssis...

Is this for a production server?

BWFC (5/23/2014)

---

Ed Wagner (5/23/2014)

---

Koen Verbeeck (5/23/2014)

---

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? ...

robleh741 (5/23/2014)

---

Just the answer I was hoping not to get. This means I'll have to buy something. I downloaded VS 2012, but it didn't seemed to be written to allow...

Personally I would group on customer, PO and email and concatenate the order IDs. This will get you one email to send at a customer with all of the orderIDs.

Concatenating...

BWFC (5/23/2014)

---

Does anybody else feel a bit frustrated when there is no response from the OP after you post an answer to a question? I know that this is...

If you want to develop SSIS in Visual Studio 2010, you need to install SSDTBI from the SQL Server setup.

Be aware that SSIS doesn't work in SQL Server express (meaning...

Nice question, thanks!

It seems if fails at validating the source.

What if you set DelayValidation to True on the package?

nonghead-webspam (5/22/2014)

---

Koen Verbeeck (5/22/2014)

---

nonghead-webspam (5/21/2014)

---

Ok, I went back to the ACE provider and things are working.

Turns out the problem was that the "Latest_File" variable needs an initial "feeder" value that...

+1 😀

Great question, thanks.

Honny (5/22/2014)

---

The sample data is only one column data or total one row and my suggestion is try to use LTRIM and RTRIM when populating data to...