ajv849 (4/14/2014)

---

Thank you .

I do not have the accessiblity permission to the native sql proc.. So the only way left for me is to write a .net app to...

ajv849 (4/10/2014)

---

Hi - I am new to SSIS .

Please correct me if I have misstated anything below:

1) The SSIS package will be connecting to the report server DB.

2)...

mirsam (3/21/2014)

---

Hi

I am very new to the sql and creating SSIS package. I am trying to import data with sftp from vendor's website. The settings works fine with other sftp...

lv42daze100 (3/13/2014)

---

Great article and content thank you. I've been scripting this behavior for so long.

However, I am unable to install the SSIS extensions. During installation, I am prompted that the...

lv42daze100 (3/13/2014)

---

Great article and content thank you. I've been scripting this behavior for so long.

However, I am unable to install the SSIS extensions. During installation, I am prompted that the...

I have just written an article on an SFTP open source custom task component that works much more reliably than this method:

"SFTP, encrypt or compress data files in SSIS using...

jbuchan (3/13/2014)

---

I have just completed a project on this myself but I hadn't used those components as I didn't know about them at the time.

I used WinSCP automation

http://winscp.net/eng/docs/library_install

and...

I have found a pretty reliable way to install assemblies to the GAC.

First, get your hands on a copy of Version 3.5.30729.1 of gacutil.exe.

Next, copy gacutil.exe into the same...

christine.collins 55481 (3/12/2014)

---

I am having a little trouble getting this to work.

I keep getting the error:

Error: 0x1 at Script Task: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an...

Great article. Thanks for writing it.

kathypdx gave a resolution last week:

My colleague and I had the same error message ("Could not load file or assembly")....

I figured out how to do this and found it useful so I thought I would share what I had learned in case other people might find it useful.

I didn't...

This article has some troubleshooting ideas for this error:

http://stackoverflow.com/questions/1540887/system-io-filenotfoundexception-could-not-load-file-or-assembly-when-the-asse

Is EPPlus showing up under references as shown in this screen shot?

Looking at that page again, there may be enough information for me to get it to work. I will try it this weekend.