I think I have worked it out.

Created a table in my datawarehouse called 'table2', with columns -

id - int

date - datetime

time - time(7)

The in my SSIS Data Flow Task...

Thank you all for your replys. I've now moved away from "heaping" my data and at least placed a CLUSTERED KEY on the id - which has now sorted it.

Thanks guys. It was more a reason I was after which you have both supplied. I won't concern myself with it, but will play about with some indexes in development.

Thanks...

Thank you so so much.

I really appreciate the time you have taken to reply to me.

This is EXACTLY what I'm after.

But now I'm thinking about it, this won't be...

sdevanny (7/10/2013)

---

Forgive me if I have oversimplified or misunderstood the issue, but this is how I understand it:

From 10,000 feet as I understand it, your existing package(s) restores the backup...

Just worked it out - - I don't need to call the filename in my destination - just the path.

FAIL!

Thanks all for your comments.

I am only restoring the database. I was only creating the database whilst I was trying to get to the bottom of why the restore...

I was restoring it when the .BAK was still on the SFTP. I would then move it via a batch file to the SQL Server.

As this will be a daily...

OK guys. Thanks for your help it must be the.BAK file.

Which is odd as it has been working fine all day....could it become corrupt by just moving it...as I move...

OK, This is what I have done now.

I have dropped the database again as the database went into a (Restoring......) state. So I have a brand new empty database called...

That didn't work either.

What I have now done is drop the database and deleted the mdf and log file.

I have now recreated an empty database with the same database name...

I prefer to go the SSIS route really.

What would I need - just the actual driver installed on the SQL server of the Progress DB?

Ahhhh. That's me not reading the step by step guide properly.

Thanks

Hi there,

Yes I used the same TSQL on all the DBs.

Sorry guys. Thanks for your help but I just don't understand enough about TSQL to appreciate what you are suggesting.

SELECT SALES.Reference AS 'SalesOrder Referance'

,SERV2.Reference AS 'ServiceOrder Reference'

,SALESTAT.NAME AS 'Sales Order...