You could probably do it using a custom script, but I never have done this as I would always go for the staging table option.

Why do you not want...

That should work,

if you are looking at pivoting the data then you may find it useful to implement a calender table

http://codeinet.blogspot.com/2006/08/auxiliary-calendar-table-for-sql.html

The easiest and most efficent way to do this would be to load all your data into a staging table on your SQL server, and then split our the...

What specifically do you want returned, the more specifc you can be the easier it is for people to help..

do you want one row for each date in the...

It seems that your formatting has gone a little astray in the post.

Is the text column subTitle ?

Bru Medishetty (12/8/2009)

---

Even we do implement a single dedicated SSIS Server that takes care of all data movement from multiple server inside our organization. In that way we would take...

What sort of replication are you running, push or pull?

are you running a remote ditributor and if so can this access the folder?

you can use the dateadd function combined with datename

http://msdn.microsoft.com/en-us/library/ms186819.aspx

SELECT DATENAME(m,(DATEADD(m,-1,GETDATE())))

We run a seperate SSIS box mainly for security purposes as it needs to talk to a lot different servers to obtain the data it is more secure to allow...

Can you see the files being created in the snapshot folder?

On the folder that you selected to put the snapshots check the permissions, The account that the Agent is running should have permission to the folder.

Also if you check...

This could be an issue with the snapshot folder, does the agent have the correct permissions to use this folder?

If there are no relationship then how do you want to combine them?

Post some sample data if you want some more specific help

You will need to add a Witness server to get automatic failover, or you can end up in the situation where you are unable to access the Primary server...

It looks like you want to do an JOIN between the two queries, or Join the underlying tables and query them both.

To do this you need to provide the...