This is the situation I'd like to reach....

select convert(datetime,'31/12/2009',120) --WORKS

select convert(datetime,'31/12/2009') --WORKS

select convert(datetime,'2009-06-30',120) --WORKS

select convert(datetime,'2009-06-30') --WORKS

SELECT isdate('31/12/2009') -- Returns True

SELECT isdate('2009-06-30') -- Returns True

😉

That would hacve been fine, except as I mention the dates are of varying formats. If we just convert to datetime with no format then that should put it to...

Yep British English

Server A is making a backup of Database A. Server B then transfers this backup over, and restores it on there.

At the moment I have a SQL Execute task looping...

If I want the original file to remain in use can I just leave it in and the database will start to use it again? Or will it be marked...

I don't want a new filegroup I want one filegroup with multiple files. I guess I could now create a new file and filegroup - move the indexes there -...

For anyone interested I solved this.

Seems there was too much data trying to replicate (not sure why yet as there should only have been a few hundred records).

I lowered the...

I checked for locks on the subscriber and publication and there are none. Meanwhile i can kick off the other distribution agent collecting from the same publication and it flies...

Made change. The process Drops indexes. Truncates table. Populates table. Adds indexes.....THEN updates table (hence I want the indexes in) but then populates it with MORE data. Maybe I should...

Good call!

*slaps forehead*

Yes very frustrating. I feel as though the moment you want to change a setting you'd be better off creating the whole data flow from scratch rather than updating it.

Actually I would still like to know If anyone else has stuck a derived blank column on the end of their flat file to prevent cut offs? Or is it...

Aha! It seems notepad has a limitation on the amount of characters you can view per line. I viewed the same text file in Textpad and it looks perfect. Had...

Thanks for that info. Checked it and no sign of any install since the original in October last year! Therefore I will assume something like permissions on this workstation are...

VERY annoyed with SSIS. Why does it take so much effort to do something so simple through DTS or Microsoft Access?

Lets take Table A. Table A has a "Filler" field...