Download the AdventureWorksDW sample database(s) from CodePlex and start learning about SSAS and Cubes etc....

MMartin1 (8/21/2014)

---

These are not the best ways likely, but a couple of ideas I have are:

1) Use SSIS and a script component with a dataflow to add text...

Thanks Perry, I knew you wouldn't be able to resist! 🙂

By the way, I came across your 3-part series of articles on clustering - very informative and reduced the...

This post should be in the Integration Services forum rather than Integration Services 2005...since it is about SQL Server 2012 SSIS. 🙂

Whether you need to track changes or not should stem from the business requirements regardless of how many rows are in a dimension table. During the dimensional modelling phase, those...

Koen...anyone..?

How were you thinking of populating your dimension tables without creating ETL packages? Whether you need to create staging tables depends on a number of things such as:

- how frequently...

Ah, yes, I didn't spot that other timestamp, apologies.

Yes, it's an old database used for testing.

So, when a database is restored/recovered, the last time that a CHECKDB was run is...

GilaMonster (8/6/2014)

---

There is not. CheckDB runs only when it is explicitly run by someone...

Did that solution work for you? If not, there are some extra steps you may need to do which are covered in this[/url] link.

Hmm, in that case, I don't know why you are seeing that behavior. I put together a quick SSIS package to do the same as you are doing in your...

You didn't answer my question. Is the DataType property for that column set to DT_STR?

What do you mean by 'masking'?

Regards

Lempster

You shouldn't need a Derived Column transformation to do this. If you click on 'Advanced' in your Flat File Connection Manager Editor, what DataType is the receiving column set to?...

Thanks All. So the View it is then. Luckily I defaulted to the 'right' choice! 🙂

Regards

Lempster