Search results for query: *

the dataset is used to display information on a user form. I am able to preview the information and everything looks ok. Can you provide the way you should declare a crystal report with a ms access dataset? thanks

Both the setdatasource and report source rptEmployee.SetDataSoure = dsEmployee1 .crvReport.ReportSource = rptEmployee

Does anyone know how to create a crystal report using an existing dataset? The dataset is currently been filled with an access db. I am trying to use the dataset to fill the information that I want to display. Everytime I call the routine I received an error "object reference not set to an...

I am using the URL for the destination of the files. I am able to run the FTP manually but when I scheduled the task it fails. In order for me to check if the security had something to do with this, I created a bat file on the server and schedule the task to run the files located on the FTP...

How do you find out the credentials on the ftp server and set it up on the server?

I am trying to download files from a ftp server using DTS. I was able to add the files and download the information manually, however when I schedule the dts to run at a schedule time I get an error: DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 0 (0) Error...

You will have to use a case statement in order to determine if the date is a weekend. i.e. CASE WHEN Weekday(date1) = 1 THEN 'do something CASE WHEN Weekday(date1) = 7 THEN 'do something CASE ELSE 'do something.

That is what I am currently doing, the problem is that I continue to add files. I have about 100 files and I was trying to read the informaiton from a table so I wouldn't have to add more lines of code to copy and rename files.

Does anyone know how I can read table values using VB Scripts and DTS? I am trying to read information store in an sql table, the information in this table is the file name, location and destination. What I need to do is check if files are avail on a source path if so, the file needs to be move...

I have also try this but I get 0 records affected UPDATE tblAIAttachments SET Div= @Div, Account = @Account WHERE Location IN(''+ @Location + '') AND Div= @Org_Div AND Account= @Org_Account @Location variable is set ='\\GLAPPS02OHCSAPPS\AI\FL8192A2.PDF'...

I did that but I am receiving an error Error converting data type varchar to bigint. I have provide my declare also. DECLARE @Div char(2),@Account bigint, @CorrespondType char(3), @MediaDate datetime, @Org_Div char(2), @Org_Account bigint, @Location varchar(500) DECLARE @SQL varchar(700) Any...

Can any one tell what is wrong with this query. I am trying to update information based on the parameters,I get an message 0 rows effected. However, if I do it manually it works. -SET @SQL=' UPDATE tblAIAttachments SET Div=' + @Div + 'SET Account =' + @Account + 'WHERE Div=' + @Org_Div + 'AND...

Yes, I ran the query and it return the information that I was looking for. I try create a sp with the same information and it work, however when I try create a function is give me errors. I think it has something to do with how I declare the variables. When I remove the variables it works.

CREATE FUNCTION dbo.fn_MonthlyUpdatesCalculation (@StartDate datetime, @EndDate datetime) RETURNS TABLE AS BEGIN DECLARE @MinAudits int, @WorkDays int SET @MinAudits = 40 SET @WorkDays = DATEDIFF("d", @StartDate, @EndDate) / 7 * 5 RETURN(SELECT dbo.fn_FiscalMonthDate (@StartDate, @EndDate)...

What I am returning is a table based on the sql statement. I have created user defined function similiar to this one however, the difference is that I did not declare or set any values. Any idea on what is causing this?

I had the same problem. If I am correct it has something to do with the owner of the file that limit what can be done using xp_cmdshell. I still have not figure this out

Can someone tell me what is wrong with this function. I am receiving an error near begin on line 200. I have display part of my code. CREATE FUNCTION dbo.fn_MonthlyUpdatesCalculation (@StartDate datetime, @EndDate datetime) RETURNS TABLE AS BEGIN DECLARE @MinAudits int, @WorkDays int SET...

Thanks it worked

Can anyone help me. I cannot get this sql statment to excute. What I am trying to do is select record from record set and delete those records in the table DELETE tblAI FROM tblAI WHERE(SELECT Div, Account, CorrespondType, COUNT (Account) AS Inquiries, MAX(MediaDate) AS MediaDate FROM...

Thanks I was able to figure it out.