Sitemap

Amicuk Programming Answers

How do I get SQL Agent to perform an FTP connection through a SSIS package?

2015-10-11   Views:0

Advertisement

I have created a number of SSIS packages that I am running through SQL Agent in various jobs.  I have set up a Credential / Proxy for the job steps and for the most part everything runs no problem.  The issue I have is with the step where I make a co

I have created a number of SSIS packages that I am running through SQL Agent in various jobs.  I have set up a Credential / Proxy for the job steps and for the most part everything runs no problem.  The issue I have is with the step where I make
a connection to a FTP server and download files.  In BIDS the step works fine but in SQL Agent the step times out.  I presume that it has to do with the account that it is being run under but that is what I thought the Credential / Proxy was supposed
to handle (as it does for all the other steps).  I am running on SQL Server 2008 R2.  I have created a test job that has only one step which is to connect to the FTP server and download some text files.  I have tried utilizing package configuration
files and have tried various ProtectionLevels to no avail.
Anyone have any thoughts or direction for me to take?  Will continue to research and will post if I resolve this.
Thanks, Andrew

The replay answer
Advertisement
On the dev environment the ProtectionLevel is set to EncryptSensitiveWithUserKey and that is what I tried first on the prod server.  Subsequently I also tried utilizing a package config file (with ProtectionLevel then of DontSaveSensitive) and have
also tried working with the ServerStorage.
For deployment I copied the relevant dtsx files to a solution on the prod server.  I verified that the packages all had tested connections in the Connection Manager.  I have run all the packages in the BIDS on the prod server and they all worked. 
I have created a test package from scratch on the prod server to test the ftp connection.  This test package runs from BIDS fine.  I have set the SQL Agent file to access through the file system (no luck) and have saved the package to the SSIS Packages
and had the job step access from there (no luck either).

Go to See the other 13 answers

How do I get SQL Agent to perform an FTP connection through a SSIS package?

Category:DefaultRelease time:2015-10-11Views:130

I have created a number of SSIS packages that I am running through SQL Agent in various jobs.  I have set up a Credential / Proxy for the job steps and for the most part everything runs no problem.  The issue I have is with the step where I make a co[More]

Sql server agent job failing to connect excel connection manager of SSIS package by 32-bit mode run time

Category:DefaultRelease time:2015-10-11Views:130

I am unable to succeed with sql agent job, I am trying to execute the SSIS package through sql agent job by ticking 32 bit runtime check box in 64 bit machine , even it does not worked.. could any one helpme on this?  Source: Excel Load Connection ma[More]

Conn problem SQl Server 64 Bit to Oracle 32 bit using SSIS packages

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I am facing the problem with connection SQL(64 bit) to Oracle(32 bit). Please give me the solution/guide in right direction. Environment is S1-----> DBServer : 64 bit Windows Server 2003 Enterprise Edition, 64 Bit SQl Server EE, 64 Bit Oracle 10g[More]

Pass value from SQL agent job step

Category:DefaultRelease time:2015-10-11Views:130

Hi  I have created one SSIS package and I am scheduling the same using SQL Agent job. Now I want to pass one value from SQL job agent and want to use that value in SSIS package and then run that package.  Can someone point to the solution. Aniruddha[More]

SQL Server Agent running SSIS package fails Unable to determine if the owner of job has server access

Category:DefaultRelease time:2015-10-11Views:130

I have a web application developed through VS 2012 which has a button on a form that when operated starts a SQL Server agent job on the server that runs an SSIS package.  The website and the instance of SQL Server with the agent and SSIS package are[More]

SQL Server 2005 agent job runs a SSIS package ( Analysis Services Processing Task) fails

Category:DefaultRelease time:2015-10-11Views:130

 Hi, SQL Server 2005 standard edition.  I have a SSIS package which has a  Analysis Services Processing Task. I have tested the package in BIDS and it runs ok. But when I created a agent job and run it from the job it reports error: Code: 0xC0012024[More]

7-zip SSIS task run with SQL agent gives "This operation requires an interactive window station" error.

Category:DefaultRelease time:-0001-11-30Views:130

I have set up the 7-zip parameters to not require a response, and the process task object to have a "hidden" window.  This is also running with a proxy on the SQL agent.  Is there some other proxy setting, or package or job setting that needs to[More]

Error executing SSIS packages from Agent

Category:DefaultRelease time:2015-10-11Views:130

Hi All,      I designed SSIS package that loads data from Oracle table to SQl server table along with loading data into Diension and fact tables using SSIS packages only. First I created all SSIS packages that loads data into Staging tables from Orac[More]

SQL 2005 SP2 - Cannot open Data Flow Task in SSIS

Category:DefaultRelease time:-0001-11-30Views:130

I have just installed Service Pack 2 on my SQL 2005 Standard Edition. However, now all my SSIS packages will not allow me to open my Data FLow Tasks.  I get the following error: TITLE: Microsoft Visual Studio Cannot show the editor for this task. ADD[More]

Run the SSIS Package using sql server Agent--Memory utilization Problem

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have Created one SSIS Package it was working fine in BIDS but in SQL Server Agent it takes all the server memory and server gets very slow now. in that ssis package i am using merge join,sorting tasks.Can you please suggest me how to handle in[More]

[SQLSTATE 42000][Error 4834] - SQL Agent Job failing

Category:DefaultRelease time:-0001-11-30Views:130

Hello,  I have started getting the below error message on a bulk insert job that has been running over several months.  Error is: Executed as user: domain\svc_sql. You do not have permission to use the bulk load statement. [SQLSTATE 42000] (Error 483[More]

Hot
Dear friends, I m new in the field of SAP ABAP. And right now i m trying to transfer the data in a tableview control in transaction ME21n. I've recorded the sequence of mandatory fields in transaction ME21n but, when i try to transfer the data using [More]
ssince updating my IPad to IOS8 Safari does not work properly ie Marriott website it tells me no server is available yet Google works and other web search have the same problem when is Apple going to get fixes out soon I hope.Also why can't we contac [More]
Hi Guys, I am installing Oracle 11gR2 on Solaris 10 Server, but on 79%, I am getting below error : Error in invoking target 'mkldflags ntcontab.o nnfgt.o' of makefile '/u4/ORA11/app/ora11/product/11.2.0/dbhome_1/network/lib/ins_net_client.mk'. checke [More]
I upgraded to iOS x mavericks on my iMac now i cannot access my iPhoto i get this messageThis update is not available for this Apple ID either because it was bought by a different user or the item was refunded or cancelled. I have not changed anythin [More]
My kids are using 4 different ipods with the same itunes/apple account, Is there something I can for them to use facetime/imessages withouth seeing eachothers messages?  I mean set up different accounts for messages?- Create a NEW account using these [More]
Hi, We have the following issues on a wireless network running PEAP, authenticating on Active Directory through ISE 1.1.2: Windows 7 laptops: (using native MS wifi drivers) Inconsistent connection attempts. Issue appears to be with certificate on ISE [More]
 hi, Our application is still in UAT env. and NOT deployed in the prod. farm.  But my customer's IT team has created few webapplns on the already provisioned prod.farm. Currenty there is no SP2013 SP1 installed on the prod.farm. Now in my dev and UAT [More]
I don't have a photo library album or a photostream album (just camera roll) but my ipod says photo library and photostream are using data on my ipod (0.6kb and 4kb). How do I remove that 4.6kb?Try going to Settings>iCloud and turn PhotoStream off. I [More]
Hi colleagues, During testing I have encountered weird problem.. The measuring data, which I fill while TECO for work order stopped being consistent with measurement document list and maintenance plan counter reading in particular.. So, when i enter [More]
Hi, I was trying this link.  I have doubt in the step 9, where do we get this script from /_static/_common/scripts/RibbonActions.js Kindly share your thoughts, Regards, Rekha.J Regards, Rekha.JHi Rekha, If you are using MS CRM on premise version you [More]