SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SFTP, encrypt or compress data files in SSIS using custom components


SFTP, encrypt or compress data files in SSIS using custom components

Author
Message
artvandelay
artvandelay
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 437
Are there any best practices for storing a private key passphrase?
jbuchan
jbuchan
SSC-Enthusiastic
SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)SSC-Enthusiastic (166 reputation)

Group: General Forum Members
Points: 166 Visits: 298
artvandelay (3/13/2014)
Are there any best practices for storing a private key passphrase?


Encrypt it!


We store our private key file on a secure location which we can limit by the process of the SQL Agent account. You could store the pass phrase config securely with it also.
lv42daze100
lv42daze100
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 97
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 application requires SSIS 2008 R2 and forces exit. My Integration Services version is 10.50.4000.

I recycled all SQL services and rebooted several times to no avail. Any advice on how to resolve this would be greatly appreciated as I could really uses these Tasks.

Thanks.
Stan Kulp-439977
Stan Kulp-439977
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1358 Visits: 1131
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 application requires SSIS 2008 R2 and forced exite. My Integration Services version is 10.50.400.

I recycled all SQL services and rebooted several times to no avail. Any advice on how to resolve this would be greatly appreciated as I could really uses this Tasks.

Thanks.

When I open SQL Server Management Studio and click "Help-About" I see this:



When I do the same in Visual Studio I see this:



Do you see anything substantially different?
Stan Kulp-439977
Stan Kulp-439977
Ten Centuries
Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)Ten Centuries (1.4K reputation)

Group: General Forum Members
Points: 1358 Visits: 1131
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 application requires SSIS 2008 R2 and forced exite. My Integration Services version is 10.50.400.

I recycled all SQL services and rebooted several times to no avail. Any advice on how to resolve this would be greatly appreciated as I could really uses this Tasks.

Thanks.

If you can't get this one to work, try this other codeplex custom task component:

SSIS SFTP Task Control Flow Component
lv42daze100
lv42daze100
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 97
Thanks for the reply. My SQL and VS2008 version information.





Maybe you could suppress the version check during install or something?

Thanks
Paul Horstink
Paul Horstink
Forum Newbie
Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)Forum Newbie (8 reputation)

Group: General Forum Members
Points: 8 Visits: 83
Same error was discussed on the codeplex-page at http://ssisextensions.codeplex.com/discussions/434570, see the reply from mcpunjabi on Thu at 4:22 PM.
I downloaded that link, and it installed without issues, even Toolbox was updated automagically!
lv42daze100
lv42daze100
Grasshopper
Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)Grasshopper (13 reputation)

Group: General Forum Members
Points: 13 Visits: 97
That resolved the issue for me, thanks.
eyespi20
eyespi20
SSC-Enthusiastic
SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)SSC-Enthusiastic (103 reputation)

Group: General Forum Members
Points: 103 Visits: 231
When attempting to install the task for SSIS 2010, I encountered a problem in that it said I need to have SSIS 2010 on my system (I did). In researching the solution, the link quoted in the article referred me to the following download https://ssisextensions.codeplex.com/downloads/get/807818 for this tool.

Installing that download and re-launching SSIS 2010 had the task already in the toolbox ready for use without having to add it.

Thanks!
mirsam
mirsam
Forum Newbie
Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)Forum Newbie (9 reputation)

Group: General Forum Members
Points: 9 Visits: 54
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 software but when I try to execute the package, it comes with the following error. I have inserted all the following parameters but it is not working! help!

TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at SFTP Task: Missing: Host Name, Port Number, User Name, Password, Local File, Remote File.
Error at SFTP Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------
BUTTONS:

OK
------------------------------
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search