Thanks guys but this is not what i was looking for. I know how cross tabs and pivots work.

I actually managed to solve the problem using SQL Server Reporting Services

The...

THANK YOU SO MUCH CHRIS, it works now, really appreciate it!!!

Thanks man, it works!!!!

Yes you can, i have used the lookup before to check for existing records when updating dimension tables, however, whenever the package is run again, if the record exists the...

I am not sure if I understand you. When you create lets say a flat file destination and you define a connection manager using an expression the file wouldn't be...

Thanks!

Oracle is stable and thats it, apart from that its not worth the hype!!!!

BTW - I think that Microsoft have hit the jack pot with there strategy of making their...

DONE IT!

here is the syntax:-

"SELECT * FROM schema_name.table_name

PARTITION (name_rest01" + right((DT_WSTR,20)month(dateadd("mm",-1,getdate())),2) +

right((DT_WSTR,50)Year(dateadd("mm",-1,getdate())),2) +")"

and here is the result:-

SELECT * FROM schema_name.table_name

PARTITION ( name_rest011207)

Thanks for the quick response!

There is a problem with the result since it will evaluate to

SELECT * FROM schema_name.table_name

PARTITION name_rest011207

Now this query is meant to work with an...

Hi again,

I managed to modify peter's expression to cater for the case when data for a given month is not available till the begining of the next month as follows:-

"select...

THANKS ALOT PETER! The expression works great!!! Appreciate it!

Expression="SELECT " +

RIGHT("0" + (DT_WSTR, 2)MONTH(GETDATE()), 2) +

RIGHT((DT_WSTR, 4)(YEAR(GETDATE())), 2)

(Replace)

I receive an error on the expression shown above. The Right function takes two parameters. One is the character...

sp_rename only works with SQL Server and my source is an oracle databse and I need to build an expression with the source to change table name everytime so I...

This is very weired, however, without me doing anything other than switching from SQL query view to table view and back and then clicking on the mappings tab and it...

DONE IT!

Here's the solution for anyone interested!

Basically add a user variable at the package level and then use the expression editor of the message source in the send mail task....

Your comments are highly valued! I have actually done the following:-

(1) I am extracting data from an accounting system using SSIS and loading it into a SQL Server 2005 mini-datawarehouse

(2)...