.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSIS throws error when it doesn't find file

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :Sql Server
Hello All, I am facing one issue that i dont know in advance if there is file on FTP or not. I scheduled a job which runs every hour which in turn calling SSIS package. Now, when there is file on FTP, it works fine. But, when there is no file on FTP then itthrows error which i want to handle. Is it possible to check for any files present on FTP? Cheers, Pranav

View Complete Post

More Related Resource Links

Error: Do you want to save this file, or find a program online to open it?



I am relatively new to MVC , i am getting the following error when i try to browse to a page in which i have used usercontrol and within the usercontrol i have a simple grid.

Error: Do you want to save this file, or find a program online to open it?

I am returning the data from the controller like this

 var jsonData = new
                    total = 1,
                    page = 1,
                    records = myRequests.Count,
                    rows = new[]{myRequests.ToArray()                 

Error: 0x80070002 The system cannot find the file specified

From Windows Server 2003 Std Ed SP, 32 bit VMWare Virtual Server .Net Framework v1.1.4322 When attempting to run a hello world aspx page it fails to load returning the message "Server Application Unavailable".  The application even viewer logged the following: Event Type: ErrorEvent Source: ASP.NET 1.1.4322.0Event Category: NoneEvent ID: 1088Description:Failed to execute request because the App-Domain could not be created. Error: 0x80070002 The system cannot find the file specified. I tried to run aspnet_regiis.exe -i, rebooted but this did not work. I tried to uninstall, reboot, reinstall .net from the Windows component section of Add/Remove Programs. Does anybody have any ideas? thanks, MP

SSIS 2K5 - Deploy SSIS Package with C# - Error File cannot be found



I made a installer program in C# that deploy ssis package on a SQL server 2005. I have like 50 package that contain only dataflow to update a datawarehouse and create fact tables.

I made also one package that call all the other packages. When I try to deploy the packages on the SQL server with the command SaveToDtsServer, I receive an error BUT only on the package calling all the other SSIS package ?? All the other SSIS packages are deployed but the package that call other packages failed to deploy. Whats strange is that when I use the domain controler to deploy the package (I use Impersonation in my C# code) its all working fine, but if I use another user (like the computer admin account), I got the error only on the package calling other packages ???

Can anyone help me on that ? I really don't know whats happening ?

The error that i have is : The file can't be found. But like I said, when using the domain controler user for impersonation, its working ???



    imp = new Impersonation(session["DBMASTER"], session["DBMASTER_PWD"]);


SSIS: Error in the package when the data in the flat file source is modified


Hi All,

I have a package which loads data from a flat file source to an OLEDB destination, which is executed successfully and data is loaded perfectly.

But later when the data in the flat file source is modified i.e. if an extra column gets added to the text file, the package is throwing an error because it is unable to detect the extra added column.

How can i avoid this error??? I need my package to execute successfully ignoring the changes(added columns) happened in the flat file source.

Please provide me wth your suggestions and solutions....

Thanks in Advance!!

System.EnterpriseServices.dll' because of system error: The system cannot find the file specified.




Can anyone help in resloving this problem I get during the .Net 2.0 Frameworks distribution ?

Thanks in advance!

MSI (s) (7C:A4) [09:33:28:295]: Executing op: ActionStart(Name=CA_InstallAssemblyRB.3643236F_FC70_11D3_A536_0090278A1BB8,,)
11/24/06 09:33:28 DDSet_Exit: InstallAssembly ended with return value 0
MSI (s) (7C:A4) [09:33:28:310]: Executing op: CustomActionSchedule(Action=CA_InstallAssemblyRB.3643236F_FC70_11D3_A536_0090278A1BB8,ActionType=1281,Source=BinaryData,Target=UninstallAssembly,CustomActionData=System.EnterpriseServices,Version=,PublicKeyToken=b03f5f7f11d50a3a,Culture=neutral,ProcessorArchitecture=x86;258048)
MSI (s) (7C:A4) [09:33:28:310]: Executing op: ActionStart(Name=CA_InstallAssemblyDef.3643236F_FC70_11D3_A536_0090278A1BB8,,)
MSI (s) (7C:A4) [09:33:28:310]: Executing op: CustomActionSchedule(Action=CA_InstallAssemblyDef.3643236F_FC70_11D3_A536_0090278A1BB8,ActionType=1025,Source=BinaryData,Target=InstallAssembly,CustomActionData=c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\System.EnterpriseServices.dll;258048)
MSI (s) (7C:80) [09:33:28:310]: Invoking remote custom action. DLL: C:\WINDOWS\Installer\MSI1D.tmp, Entrypoint: InstallAssembly
11/24/06 09:33:28 DDSet_Status: LANGID: 1033
11/24/06 09:33:28 DDSet_Entry: InstallAssembly started
11/24/06 09:33:28 DDSet_Status: CustomActionData: c

File System Task Error in SSIS


Hi All,


I am trying to move some .txt files with in same location different folder.


Destination Filename=C:\Error Files\Specific Client


Source Filename=C:\Error Files


I used for each container in that I took file system task.

In file system task Destination variable= Destination Filename, sourcevariable= Source Filename, operation=move, issourcepathvarible=true, overwriterdestination=true


Get latest file name using SSIS script task: Error while execution


Hi  , I am trying to get the latest file name to process files in SSIS using vb.net code . I did set the varible in the For each loop container and assigned the variable in my file connection. I have been receiving this error msg.: Please help me out.

Error: 0x2 at Get File Name: The script threw an exception: The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there.

Task failed: Get File Name

Warning: 0x80019002 at Foreach Loop Container: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.

SSIS package "testpackage.dtsx" finished: Failure.


Error Running SSIS Package as SQL Agent Job loading a file from network drive, works fine in bids an

Having problems reading an excel file from a networked drive while running a package as a SQL Agent job step as a type "SQL Server Integration Services Package". I have agent running as an AD account, and I can use the execute package utility logged in as this account and it works. When I log into the server as this account, I can see the network drive, read/write/create to folders on the drive but when I try to run the agent job it cant find the file. I tried using the unc path in the config file rather than a mapped drive, still no luck. If I use a local drive (c) in the config file, the job works fine so it has to do with the network drive. Running windows server 2003 standard R2, SQL Server 2005 standard sp3. Any ideas out there?

SSIS - Script Task Error - Could not load file or assembly


I have script task that has references added to it but still giving me above error? How should i resolve this situation?


Compiler Error Message : CS0006: Metadata file 'System.EnterpriseServices.dll' could not be found


I get this error when i Debug my web application....


I followed these steps.,

  • Ended the aspnet_wp.exe process in the Windows Task Manager
  • Then deleted the application`s folder in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\
  • Then started Visual Studio 2008 again

I also rebooted my system but no use....

Plz help !

Cant find vsi file for CSS Friendly Control Adapters


Hi guys

This is driving me crazy... I cant find the .vsi file for installing the CSS Friendly Control Adapters Project. Does anyone know where I can get this?

The following link: http://www.asp.net/cssadapters/ only leads to the CodePlex wiki where I can download the dll and a partial solution. Essentially, I'm looking for the source code to implement the Menu adapter.

Any help is much appreciated!

Parser Error Message: Could not load type MasterPage File



Server Error in '/' Application.

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Could not load type 'wamsilverlight.Web.Wam'.

Source Error:

Line 1:  <%@ Master Language="C#" AutoEventWireup="true" CodeBehind="Wam.master.cs" Inherits="wamsilverlight.Web.Wam" %>
Line 2:  
Line 3:  <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

Source File: /Wam.Master    Line: 1

Version Information: Microsoft .NET Framework Version:2.0.50727.4952; ASP.NET Version:2.0.50727.4927


All of the following have been tried over and over again:

1.) Delete all existing .dlls

2.) Delete MasterPage File and recreate it.

3.) Delete MasterPage perform a c

Security trimmed URL throws an error if not logged in

On a Moss 2007 site, using FBA - I have an issue with security trimmed items within Lists.   There is not a problem with direct url links to non-list items.  
For list items - here is the problem, when a user is not logged in and follows a direct url link from an email or newsletter to security trimmed items within a list - it throws an error instead of offering a redirect to login?

More info:  This is only occurring for individually security trimmed list items that have had anonymous access removed.  When a whole list or library has had anonymous removed, the links work fine (login page appears, log in, taken to original link).

Why is that and is there a way to avoid the error?

If it is of help, this is the error. Thanks in advance.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not
set to an insta

Excel file getting error


when i am trying to save a excel document in library it getting error like "The file cannot be saved because some properties are missing or invalid"

If anyone know the solution for this pls tell me.



How do I find the file path from a namespace.class name?


I'm programatically looking ito a .aspx file and getting the file class name declared in its CodeBehind. For example, when analyzing myFile.aspx I read in its Page Directive and found its CodeBehind equals "myApplication\myPage.aspx.vb". Then I use the code below:


Dim Assm As System.Reflection.Assembly = System.Reflection.Assembly.LoadFrom("myApplication\bin\myApplication.dll")
Dim ClassType As Type = Assm.GetType("myApplication\myPage.aspx.vb")
' myBaseType = "myApplication.Forms.BasePage"
Dim myBaseType As System.Type = ClassType.BaseType


Now I want to read the BaseFile (class = myApplication.Forms.BasePage). However, to read in this file, I need I need to get its full path instead of its namespace.class hiearchy. In this case, the BasePage is wrapped in a different namespace declaration thus I cannot just change the '.' to '\' in order to get the path.

How can I get the path of BasePage so I can read it? Thank you - Frank

Please find out the logical error in my coding


Hi members,

              Please find out the logical error in my coding..

             I have grid view which was filled with checkbox ,empid, empname

             At present i filled 3 rows in gridview...

            And also i have one button outside the gridview

I need,

           When i click on the button...The empname which is corresponding  the particular row (which was selected in checkbox)...Should get displayed..

         My coding is..


    ArrayList arrayCheckbox = new ArrayList();
  protected void ButtonName_Click(object sender, EventArgs e)
        for (int i = 0; i < GridViewTest.Rows.Count; i++)
            CheckBox cb = (CheckBox)GridViewTest.Rows[i].Cells[0].FindControl("checkboxItems");
            if (cb.Checked==true)
                arrayCheckbox[i] = (String)GridViewTest.Rows[i].Cells[2].Text;

        for (int i = 0; i < arrayCheckbox.Count; i++)
            Response.Write("<br> Name is" + arrayChe

File open error in grid



I am using gridview control which has the option to open the file like jpg,pdf etc. The grid is under UpdatePanel template.When i try to open the file in seperate window by using the below code

If (e.CommandName = "Open") Then 

Dim path = e.CommandArgument  

Dim strNewURL As String = "<Script Language = 'JavaScript'>window.open('www.google.com')</Script>"



i am getting following error:

"Microsoft JScript runtime error: Sys.WebForms.PageRequestManagerParserErrorException: The message received from the server could not be parsed. Common causes for this error are when the response is modified by

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend