To be able to use FileInfo, you have to import library reference Microsoft.SqlServer.SmoExtended if you are using SQL2008 or SQL2008R2 and then use it in your Script Main window by...

imz (6/13/2013)

---

RonKyle (6/13/2013)

---

You can actually simplify it even more if you like, by using a File System Task, instead of a Script Task to move your processed files once done....

Christian Buettner-167247 (3/1/2013)

---

demonfox (2/28/2013)

---

tom.kane (2/28/2013)

---

I got tricked with this one. I said No, because the code will cause a syntax error as you can't mix creating tables and procs...

Christian Buettner-167247 (3/1/2013)

---

demonfox (2/28/2013)

---

tom.kane (2/28/2013)

---

I got tricked with this one. I said No, because the code will cause a syntax error as you can't mix creating tables and procs...

That is correct, nothing in FTP is encrypted unless vendor/provider encrypts the file before dumping it in FTP site. I don't think any file transfer utility/software automatically encrypts the...

My brain almost exploded..lol!! Pretty hard question. I actually have to open my book and read more about MERGE statement. I was under impression that this MERGE functionality came...

Muthukkumaran Kaliyamoorthy, please refer to this post for your answer. I happen to post it in different window instead of replying to your post 😀

True there is no such...

Good article. I knew that Truncate is minimal logged operation but didn't knew that it logs deallocation of data pages.

I have one question though. I know Delete is...

I have never used Incremental backup but I kind of remember reading somewhere about it as a new addition to SQL 2005 when it first came out. I never...

I misread the question too...when I got my answer incorrect, I went back and re-read and I was like "Stupid me". Anyway, after all, good question.