It worked well....Thank you

--VG

My workflow like this : Oledb Source - Script task (read only 10 characters from a column) - data conversion task - flat file destination.

Nope, I added those set statements before create stored proc statement ,but still getting the same error...

Thanks Lynn. Let me try this.

-VG

You mean, I should use these SET statements in the stored proc, where the table references are made.

SET ARITHABORT ON

GO

SET CONCAT_NULL_YIELDS_NULL ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

SET ANSI_PADDING ON

GO

SET ANSI_WARNINGS ON

GO

SET...

Insert in done through a stored procedure. Stored procedure does use this view, it just references the table.

But, the table is referenced in a view, which has a indexed on...

Are sure you have added logging to the SSIS package. By deafult there is no logging, you have to define it , with connection string to msdb, or some ohter...

Thanks Noel !!! I figured it too...

Sorry, I didn't get it...Where to set the errorlevel ?

Thanks Steve!!

Hi Steve,

We have a nightly job which brings the snapshots to the replicated databases and what I see in replicated databases,(at the subscriber) the indexes are overwritten. I tested...

Hi Noel,

So, we should have a re-index job on subscriber databases as well ? We have reports running on these subsciber databases.

restoring databases I mean is, restoring the production backups...

Thanks Matt..

Is there any other options like using command line utilities...

Thanks again..

-VG

Hi,

Where is the file \\testserver\Exportfolder\coitem.csv located ?

Like if it is in D drive, then I would give UNC path like this:

\\testserver\D$\Exportfolder\coitem.csv

VG

Hi,

I believe your source is flat file, then sequence goes like this:

faltfile source

data conversion task

Script task

Destination.

Is that what you wanted to know?

-VG

Hi,

One more suggestion, In metadata, defalut is "fail component on failure : and change it to Ingnore falire and then save tha package re-deploy it. While deploying you can...