it worked for me now, weird I just change connection provider from sql native client to Microsoft oledb provider for Sql server and everything is fine now.

thanks for your...

ya i explore a lot, and on the below site it have mentioned about adding script component to add a dummy row on the last record using .net code, but...

Bru Medishetty

ya I apply your method also, but didnt work

but where do i need to raise ignore error option, i went flatfile soruce and edit and went to error ouput option and set all columns to ignore failure...

thanks for your response guys, I have attached my file here, the thing is i get this file every day on ftp server so its hectic for me to change...

I am still waiting for input from anyone, please this one is kiling me.

Here I have my new table script, so now we need jobstep as our parameterr? could u please send me the script for store proc with step on it.

thanks

USE [JobsMonitor]...

now i got it, I need to figure out the end time of first job step so after executing the store proc on next step will insert the record on...

Its working, now i got one issue, I am running a job step1 after step1 is success it goes to step2 where this store proc is executed and it is...

my table script is below

USE [JobsMonitor]

GO

/****** Object: Table [dbo].[Job_Audit] Script Date: 10/30/2009 15:31:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[Job_Audit](

[ServerName] [varchar](20) NULL,

[JobName] [varchar](50) NULL,

[StartDateTime]...

here i am trying to create a store proc, I am getting an error, please let me know where i am wrong.

I need to pass @p_ijob_name parameter as job...

thank you very much sir, I need lil bit diffrent, let me explain you my senario, I have created a table with 4 field, i.e servername, jobname,...

Great I would appriciate if you could provide me the script till tommorow at 5pm

It would be great if you provide me a script. thanks

thanks for those links but I need to write a store proc to put those job info on my sql table.