* edit: accidently posted something. Post removed. *

W00t! Steve approved my QotD on SSIS 2012. It will be published around 18th of April.

Hardy21 (4/3/2012)

---

Thanks for your response.

I would like to know - Is SSIS Send mail use Database Mail feature only (means internally) ?

What is pros & cons to use SSIS Send...

PATINDEX (Transact-SQL)

Nothing that nobody would expect...

When you use the tabular models, you can still build your data warehouse using the Kimball method. Since the star schema's are relatively simple, it will be pretty straight forward...

In your explanation you never said anything about an OLE DB Destination.

I think you coupled your no match output to your updates and your match output to your inserts. It...

So you mean that there aren't any rows updated?

If you run the package, you can see how many rows were sent to the OLE DB Command.

The Kimball books are about design and architecture of a data warehouse.

They are technology independant, so it should be your first read if you really want to go into data...

emptem is the table right?

You're doing an update statement in the OLE DB command, so...

All seems OK.

But there must be some sort of...

Right-click on an arrow in the dataflow, choose dataviewers and select metadata.

That's spam. I reported it 🙂

abhish_216 (4/3/2012)

---

Are both the source and destination SQL Server? -- yes on same sql server

What datatype is used in SSIS? ...

Are both the source and destination SQL Server?

What datatype is used in SSIS?

What collation do you use in the source and destination?