udaya_1222 (3/10/2010)

---

Thanks Devyanth , Sort transformation was helpful but now i have a question how should i build my data flow to capture duplicate records in a file and what...

Why did you post this?

I would do it the way you suggest - but as part of the package. Step 1 - Script Task to validate spreadsheet format.

Trial and error strikes again! I'm afraid I can't help you any more, but well done on getting there in the end.

gprasad.nit (3/4/2010)

---

You can not debug or run this project, because the required version of the Microsoft Office application is not installed error come in ms SQL integration services

when i want...

What is the datatype of the destination field on SQL Server?

Can you confirm that Excel is the problem by adding a data reader after the data source?

A derived column using...

Can you clarify what you mean by 'correct order'?

If possible, some sample data would probably help ... just enough to illuminate your ordering problem.

Yeah - I reckon you'll get more than just the table name by doing that. If you try 'object', does the error go away?

You might need a bit of script...

So it sounds like you want to be able to repeatedly (at defined periods) process an Access database. (Is there only one? Will it always have the same name?).

Every time...

What do you mean by "type of table"?

--Edit

are all of the physical tables already set up in SQL Server, or are you hoping to do some sort of create-then-import...

This works - just tested it:

RIGHT("0" + (DT_STR,4,1252)DATEPART("dd",GETDATE()),2)

I'll have to guess at your question, as you have not stated one ...

Use something like

Right('0' + [month as Varchar], 2)

That is a fairly horrendous requirement 🙂

Unless you can put logic into the front-end application to track Field Last Modified, you just won't have that info. Same with 'Record Last...

You have a single table containing all that stuff? Sounds like it might be in need of some normalisation ...

Do you want to track the change dates separately for each...

isnull([likes_fish]) ? FALSE : [likes_fish]

should work.