Hi,

There is checkpoints in SSIS, which can restart failed packages from the point of failure. http://msdn.microsoft.com/en-us/library/ms140226.aspx.

I haven't tried this though..just a suggestion.

VG

Sorry, I mean to say also Transfer SQl server objects...anyway, Looks like you found a solution ..

VG

There is Transfer database objects tasks...in SSIS

VG

Yes - Import - export wizard is easiest one. Database- right click select tasks - export data..follow the wizard...sometimes you may have edit the mapping (delete the rows in destination...

File system task can do this. Select either, delete file, delete directory, delete directory files according to your needs. I am not sure about the keeping only current files though...

Are...

What we we do is, archive the files with datestamp to a different folder a first step and then copy the file to desired folder and ovewrite it. For both...

Identity or ROWID may be helpful..

VG

HI Loner,

what I understood is data is copied to different tables.

Here you can test:

1. In import- export wizard, in one of the step wizard you can select destination (try...

I am not sure how you are viewing the package...My suggestion would be to , go to BIDS and create a new package, this will create a new solution file...

You can try discovering more on Conditional split transformation for different file formats and then use union all transfomations.

VG

Hi,

I am able to rename task using FileSyetem task by creating two more variables for this.

I achieved truncation of file by copying blank template file after archiving, so it...

Hi,

It should be like this : EXEC dbo.myprocedure ?

I had a same situation, I didn't wanted to create one more ADO.NET conections. So, I used like this and it...

Here is the solutin provided by one of sql server central member

http://www.sqlservercentral.com/Forums/Topic459991-148-1.aspx?Highlight=rename

VG

For that you need data flow task, and define your source and destination connections and map the columns between source and destination.

VG

You can use execute sql task, which executes sql statements inside the task.

VG