Hello, I have a SQL job in 2000 server which has VB script on that to create Folders.It is running Fine. Now I am trying to create same SQL Job in 2008 Server. The same VB script is Failing here. Error is: Error Source= Microsoft VBScript runtime error Error Description: File already exists Error on Line 27. The step failed. IN the VB script I am checking like this : If Not objFSO.FolderExists(sFilePath1) Then objFSO.CreateFolder(sFilePath1) End If Can Anyone Please help ME on this? Why its running fine on 2000 Server and Failing on 2008 server ? Thank you for your Help....
vasini
Posts
-
Job in SQL Server 2008 -
SSIS Package - Urgent need HelpI have created an SSIS package that works if Windows authentication is selected, but fails upon using SQL Server Authentication. Basically its not saving the paddword for SQL Server Authentication. Can anyone please help me on this ? Thank you.
-
SSIS Package - Urgent need HelpI have created an SSIS package that works if Windows authentication is selected, but fails upon using SQL Server Authentication. Basically, Its not saving the password for SQLServer Authentication. Can anyone please help me on this ?
-
SQL SERVERThank you for your answer. I am looking at the same Excel File with different sheets. Please let me know.
-
SQL SERVERHi, I am trying to Export Data From SqlServer Table Into Multiple Excel Worksheets. I have more than 65000 records which can not fit into one Excel worksheet. I am using BCP command in a stored procedure to export. I have searched in google and could not get solution to export to mulitple sheets from stored procedure. Please let me know if anyone can help me on this. Thanks for helping.
-
Generating Excel Reports in ASP .NET 2.0Hi, Can you give little more information? Are you sending the data which is in grid to excel file? If so, I have code which exports to .CSV file from a gridview... If your question is the same, I can share the code for you. Thanks...
-
Display in GridViewThanks for the reply. I have binded to the gridview. Its displaying the first value. I would like to display all the 3 or 4 ( how many I pass) in the grid. Thanks again....
-
Display in GridViewHi, I am trying this for couple of days. But could not solve it. I am calling a stored procedure (it has 3 I/P parameters) with command object and binding to a gridview. One parameter takes multiple values (ex: 10,20,30) When I debug the application, all the values, its passing correctly. (When I run the stored procedure in the back end, its giving all the rows) But after binding to gridview, its displaying only the first value. For example, If I pass company as 120 and fund as 10,20,30 and date as 3/31/2008, the stored procedure is taking all the values. But when it displays in the grid it showing only the data of fund 10. Please help me. how can I get the values in the grid. Thank for all your help. Vasini
-
DotNet ApplicationI am new to ASP.Net. I worked very little with ASP.Net1.1. Now I am learning 2.0. I have created simple 3 pages application and stored in my local drive. The files aspx and aspx.cs are there in my local. Now I would like to open my application to develop more. How can I do that? Like in asp.net1.1, I used to have a .sln file. If I click the file it used to load the entire application in VS 2003.. Please do tell me how can I open my existing application and work more? Thank you. Vasini
-
top 10 valuesHi, I need to generate a report for top 10 share holders. its not that the first top 10 values. Its the top 10 share holders ( values). I am writing the query in sql server. Please help me to get top 10 share holder values. Thank you. Vasini
-
top rowsHi, I need to generate a report for top 10 share holders. its not that the first top 10 values. Its the top 10 share holders ( values). I am writing the query in sql server. Please help me to get top 10 share holder values. Thank you. Vasini Vasini
-
File UploadI have a text file(which is in different server) to be uploaded to database table. When we browse the file, and click upload button, it should redirect to other aspx page and from where the path of the file will be sent to a procedure to insert the values in the text file to a table. But when I select a file and click the upload button its giving "Page cannot be Displayed" error. My code is like this: Try Dim inputFile As New FileInfo(txtfilePath.PostedFile.FileName) Try If (inputFile.Length > 1) Then lblStatus.Text = "File is empty" Else Response.Redirect("Form2.aspx?file=" & HttpUtility.UrlPathEncode(txtfilePath.PostedFile.FileName)) End If Catch ex As Exception lblStatus.Text = ex.Message End Try Catch ex As Exception lblStatus.Text = "File doesn't exist or is inaccessible" End Try When I click upload button its saying page cannot be displayed. Please if anyone can help me for fixing this, I'll be thankful. Thank you. Vasini
-
C#How do you generate documentation from the C# file commented properly with a command-line compiler? Thank you. Vasini
-
AssemblyExplain what it means to “pre-jit” an assembly and how you would do it? Ramana
-
Garbage CollectorHow many generations does the Garbage Collector have and what are they? Vasini
-
AssemblyHow can the contents of an assembly be viewed? Thanks... Vasini
-
Assembly in GACHow would you make an assembly in the GAC show up in the add references dialog box of the VS.NET IDE? Vasini
-
.NETHow many application domains can exist in a single operating system process? Vasini
-
GridViewHi, I made a GirdView and fill it with data from database. In this GirdView I have five columns. First column is Name of item that is represented in this grid. I want to make items in this column url addresses so when I click on item name it opens another page to edit the item on which I clicked. Can this be done? And if can, how? Thanks! Vasini
-
GridviewI made a GirdView and fill it with data from database. In this GirdView i have five columns. First column is Name of item that is represented in this grid. I want to make items in this column url addresses so when i click on item name it opens another page to edit the item on which I clicked. Can this be done? And if can, how? Thanks! Vasini