Hi Steve,

Legacy issues really, although complacency plays a part in leaving those issues in.  All the monetary data is stored in numeric (generally 10,4s sometimes 8,2s) data types...

Perfect. Thanks Sue. I did have a look through the cast documentation yesterday but completely overlooked that section.

I thought that may be the case. Cheers

Always listening Jeff 😛 moved on from that business 6 years ago though 🙂

jumping in late on this one and sorry if this has been covered already. I read recently about free space in heaps (tables without a clustered index). Apparently...

Thanks for the reply Grant and may i also take the opportunity to say thank you for all your excellent work in the SQL field, your work has been a...

If you do a manual backup does it work without issue to the same folder location?

The multiple data flow tasks has worked 😀

For anyone that happens upon this thread with the same issue, setup one data flow with a flat file output for your header,...

That also sounds a good plan! I'll see how it goes today and feed back. Just about too head into work now

OK cheers. One theory I do have is setting 3 data flow tasks all output to different files which have the same output path, hence windows seeing them as the...

Header is fixed. Footer is fixed in terms of column numbers but data is dynamic.

Sure, I meant that but wasn't clear in my response. 🙂

John

Cheers Gail. I did that check and there were only 4 in the whole DB (user tables only) and i can see all the data in those.

Thanks

John

Hi,

Yes a default instance is fine for everything you will want to do. You only need named instances when you need more than one instance as you can...

Have you got a named instance called MSSQLSERVER? If not and your just trying to connect to the default instance then drop the /MSSQLSERVER from the end of your...