I would create 2 named ranges:

one for row 1 and the first 2 columns, to store the name and date.

one for the data starting at row 5.

You can write to...

What if you import is as unicode?

Nice question. I vaguely remembered reading something about this in my certification prep, it's not something I encounter daily.

Revenant (2/9/2012)

---

L' Eomot Inversé (2/9/2012)

---

MysteryJimbo (2/9/2012)

---

HowardW (2/9/2012)

---

MysteryJimbo (2/9/2012)

---

Interesting fact: Historically, it used to be in the UK that people drank more beer than water as it was sterile and the...

What happens if you move the file with a script task using .NET (FileInfo.CopyTo ; FileInfo.Move ; FileInfo.Delete) instead of a file system task? You can log in a script...

jcrawf02 (2/9/2012)

---

BrainDonor (2/9/2012)

---

Roy Ernest (2/9/2012)

---

Lynn Pettis (2/7/2012)

---

Now that it is officially posted on facebook, I can start telling everyone.

Kassondra gave birth to a healthy baby boy yesterday in Germany. Grayson...

Maybe you have only read rights on the folder, not modify/write?

Off-topic again 🙂

You're not circumventing data conversion issues by pumping it in a flat file.

Most data conversion issues occur when...

Linda Robinson (2/9/2012)

---

Got it! I have to run the whole package for logging to be recorded, even though I can set up logging for just part of it. That was...

Gas Andy (2/9/2012)

---

Hmm, does SQLServerCentral sell your email address?

I've started a new contract and registered for SQLServerCentral.com, so I had a brand new "clean" email address. I had not registered...

Rachel Byford (2/9/2012)

---

I guess nobody knows the answer then - I have now officially given up!

I am instead going to use Execute SQL tasks with begin tran/commit tran and rollback...

You should be able to execute a stored procedure in a report just fine. Change the command type of the query from text to stored procedure.

Regarding your set-up:

you could use...

SQL Kiwi (2/9/2012)

---

Koen Verbeeck (2/9/2012)

---

That is a bit of the problem.

XML PATH...

That is a bit of the problem.

XML PATH and CLR have a...

Good question, had to do a bit of research, but the MSDN link doesn't really back-up the explanation as it doesn't mention salt anywhere.

edit: in this thread, an MVP does...

There isn't really a "web service destination" in SSIS, so I think you're better of coding it in .NET. (or in another language)