You could always use any of the STRING manipulation functions available like substring.

What all approaches have you tried? This seems relatively easy. Help us help you. 🙂

Thanks for pointing that out. Let me have another read. 🙂

Shouldn't that be the case where every field in the file is qualified by a quote? Just curious.

You might want to see the SQL table ExecutionLog2

It's always good to decribe more about the actions and the needs of the package when seeking help. Also, some home work is also suggested.

Perhaps, see this link[/url]

Ganga,

This is an invalid CSV format specification.

Please follow the link here

And also, assign default values to dimension entities. Not displaying the 'Unknown members' will just hide the dim(s).

Perfect explanation by the Koen. Just to add my two cents...

Make an effort to assign some default values to such dimension entities.

Wonderful Steve.

One CSV file of one table OR One CSV for all tables? 🙂

jeevan619 (9/20/2011)

---

I am working as a DBA and got a task related to SSIS package. By using SSIS package I need to develop a alert notification system.

There are...

SMT is not the best approach to deliver notification emails. I would recommend you build a custom code that suits your need. That is far easier also manageable.

Try this resource

Stop sharing and asking interview questions. This will only narrow your approach towards the real stuff