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
I have two Apple ID accounts. One that I use for making iTunes purchases (which I had way before @me.com or @icloud.com existed) and the new @icloud.com account that I use for everything iCloud related (Messages, backups, etc). Now that Family Sharin [More]
I have a problem with Adobe Premiere software, some time ago I was given a file in Adobe Premiere project contains a hard drive to my revision. but when i try to do the project on my computer I was often faced with the problem of not responding. What [More]
Anyone else having this issue? Anyone know if they need to be "enabled" somehow?Yes, the adapter does seem to go all the way up to the plastic shell. And the the adapters and displays work fine when driven by either of my MacBook Pros. And there [More]
Dear Friends, Can you please give your valuable suggestions. Issue : Customer final rebate settlement based on respective delivering plant. Let me explain: Customer has purcahsed some goods worth Rs. 200000.00 by 10 invoices. Different delivering pla [More]
Hi All, DECLARE fileID UTL_FILE.FILE_TYPE; strbuffer VARCHAR2(100); BEGIN fileID := UTL_FILE.FOPEN ('DR', 'New.txt', 'R'); UTL_FILE.GET_LINE (fileID, strbuffer); dbms_output.put_line(strbuffer); END; By this program I can read only first line of the [More]
how do I get the four items from the bottom of my screen, safari,keypad,music, and mail to return?Tap and hold any app's icon until all of the app icons start jiggling. Then tap & hold the apps' icons that you want on the Dock/Launch bar and drag the [More]
HI, id like to ask about Family Sharing and the payment method. IN the settings window where i can send an invite to my sister for example, it shows my credit card under "payment method", and right beneath it it'll say "purchases initiated [More]
I am trying to translate Swedish to English but I can't type the Swedish word.On Linux you usually have a compose key (usually the Windows key to the right of the space bar) to create accented characters easily. *http://en.wikipedia.org/wiki/Compose_ [More]
Do you guys see a problem with having multiple date keys (all date keys are referencing one date demension table) on a fact table? RESERVATION_DATE_KEY SHIP_DATE_KEY CONTRACT_DATE_KEY SHIP_DATE_KEY CANCEL_DATE_KEY APPLICANT_KEY BRANCH_KEY ENLST_CAT_K [More]
Hello, I have been working on adding a few thousand machines into our SCCM 2012 R2 environment.  Recently after attaching several of these systems there was a spike in activity in the transaction log due to the communication and inventory of these ne [More]