Why a CTE, specifically? Is that a requirement of your assignment? It's fine if it this is for homework, we...

That post shows no proof, i.e. no code to reproduce...

I do not condone it, but in some cases it can be useful. I only know it's possible because it came up recently and I did a quick POC for...

Tonci Korsano (5/11/2012)

---

hi there,

here is the answer --> https://www.google.com/#hl=en&sa=X&psj=1&ei=70OtT53nCYKy8ASUwrWXDQ&ved=0CBgQvwUoAQ&q=(sqlbulkcopy+OR+bcp)+(%22no+logging%22+OR+%22does+not+log%22)&spell=1&bav=on.2,or.r_gc.r_pw.r_cp.r_qf.,cf.osb&fp=356e729b7a15c7f0&biw=1280&bih=891

or just put in google.com

(sqlbulkcopy OR bcp) ("no logging" OR "does not log")

this is really a web search... even though it...

For a one-time need? Nah. How about something like this?

bcp "SELECT definition + NCHAR(13) + NCHAR(10) + 'GO' + NCHAR(13) + NCHAR(10) FROM sys.sql_modules sm JOIN sys.procedures p ON sm.object_id...

Your Foreach loop maps file names into a variable. A precedence constraint after your Foreach loop connecting it to a Send Email Task could check to see whether that variable...

Tonci Korsano (5/11/2012)

---

hi there,

your suggestions are all fine.

bulk copy is always fast because it doesn't log (it is like saying it doesn't use the transaction log). so, if the issue...

In general SSIS metadata is meant to be static once it is built. Changing that on the fly is an advance topic, at least. Good luck! Dynamically Map Column Data...

riya_dave, your vagueness is limitless! I am astounded at your defiance towards the notion of helping us help you. What a waste of time...

marttali (5/11/2012)

---

Well Thank you for your help, luckily creating this simple script i'm more than capable of 🙂

But still it's rather bizarre FTP task is not capable of doing this...

curtis2325 (5/11/2012)

---

Thanks for shearing nice post are rally useful thanks

<span id="_ctl5_ctlTopic_ctlPanelBar_ctlTopicsRepeater__ctl22_lblPostSignature"><b><a href="http://www.textmessagespysoftware.com" target="_blank" class="SmlLinks">text message spy software</a></b>

<b><a href="http://www.textmessagespysoftware.com/spy-software/spy-girlfriends-phone-spy-software/" target="_blank" class="SmlLinks">spy on girlfriends phone</a></b>

<b><a href="http://www.textmessagespysoftware.com/cell-phone-spy-2/spy-text-messages-installing-software/" target="_blank" class="SmlLinks">spy on text messages without...

marttali (5/11/2012)

---

Wouldn't your example accomplish to download all the files from the FTP ? I...

BOL is the place to start. Here is a visual aid as well:

Looping Through and Loading Files with SSIS

Any particular reason why not? Let me guess...political reasons in your organization?

RegEx is one of the primary use-cases...

Transfer Multiple Files from or to FTP remote path to local path - SSIS