In BIDS in the connections manager window right click and from the contect menu select "New Flat File Connection"

In the connection Manager Click on the general tab click the "Browse"...

Do you need to restor to a point in time or would daily backups and changing the recovery mode to simple be suufficient. This would then get round Ever increasing...

I would like to add to one of Rick's comments. I find it easier to add this sort of logic with T-SQL. I also believe that if I wa;lked out...

Pretty much what Ramesh said.

Open up BIDs then File and new and new Integration services package. At the bottom in the centre there is the connection manager tab. Here...

Thanks Grant,

The 'Out' package has been running without indexes for months and the processing time is getting longer. We added indexes recently and I think I will need to do...

where possible in the past I have always stored the calculations inthe the database rather than cube. It is a lot faster then in the cube. In SQL there are...

We are having a few problems that I am investigating. Now I would like to believe this is not just the new indexes that I put on?

We run a series...

I have avoided posting the create statement as the number of columns is excessive. There are 176 columns of which there is one uniqure identifier and several columns of interest...

If you moved the rankgroup into the table that supplies the dimension then it would be a lot easier to do.

Sorry this does not answer the question but it is...

Hi,

in the real world there are always compromises from the ideal. The most recent warehouse that I built is laid out with fact and dimensional tables. The naming convention is...

Jack,

tahnks for the question. There where two possibilities with SSIS on the data warehouse server and the relational source database on another server.

1. the SSIS packages connects to both...

Many thanks will look into the timeout. I have a feeling that part of the issue may reside here.

I am struggling to get the tuning of the wuery. My stored...

Manu,

thanks. I have looked through the posts and will try them later. I must mneed to do more work with SQL as I could not see how either post updated...

Many Thanks.

I am keeping an eye on the size of the logs and knoe I understand my options I will be looking at what we should do.

Thanks,

Mark.

Many Thanks,

I have read Gails post and very informative it is. I will look at the other blog. I have a feeling that there are no trasaction log backups being...