All in here: "SSIS Nugget: Select Top N in a data-flow"

http://blogs.conchango.com/jamiethomson/archive/2005/07/27/1877.aspx

-Jamie

Use an Execute SQL task to take those values and store them in variables.

Then use expressions on the appropriate properties of the connection manager in order to set them to...

We deploy our packages (it is irrelevant where to) and keep all our work done in teh development stage in SourceSafe. We make changes in the development environment and then...

This is a huge area and I recommend you do some reading around the subject. This is a good book: http://www.amazon.co.uk/exec/obidos/ASIN/0471200247/qid%3D1144139298/202-0025042-2605436

basically a dimension is an entity that can influence your business. E.g....

You can't Visual Studio for Applications (for that is what it is) only supports VB.Net.

-Jamie

I'd recommend that you don't use the SSIS job subsystem though. Read here: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

-Jamie

Mark,

That's great news, I'm delighted to see you wavering

I think this kinda reiterates the point that there is a definate learning curve with...

The debug window in BIDS? That's very strange. Are you sure you have an Integration Services project open? You need to add the package to a project in order to...

Mark,

I finally got around to trying this. I apologise that it took me so long. Everytime I booted up to try it something ended up interrupting me y'know. Emails to...

What sort of object?

You're on the wrong forum by the way.

-Jamie

In expressions "=" is an assignment operator. "==" is used for testing equivalence.

-Jamie

Andrew is correct. Fuzzy logic features are only available in SSIS. If you want similar functionality in T-SQL then request it at the feedback center: http://lab.msdn.microsoft.com/productfeedback/default.aspx

-Jamie

No, I didn't sorry. I promise I still will. Just been very busy y'know!!

-Jamie

Try the Analysis Services forum

-Jamie

OK, that's easily fixed:

"C:\\Local\\DataIn\\SEG_IDEM_"  + (DT_WSTR,4)DatePart("yyyy", GetDate()) + RIGHT("0" + (DT_WSTR,2)DatePart("mm", GetDate()), 2) + RIGHT("0" + (DT_WSTR,2)DatePart("dd", GetDate()), 2) + ".txt"

-Jamie