or better yet - setup a powershell that executes all required queries and writes the output of each onto a csv file (one per query) - and set it so...

have a look in the manual for substring and convert, and potentially "stuff" - with the you will be able to do what you need.

and if after you read the...

you need to add " (double quote) as the text delimiter on the definition above - once you do that you will be able to open the file correctly in...

That's nice points you said. I was trying to automate this process using SQL Server agent job and selecting SSIS, once I have my export package saved. I tried...

what indexes exist on the parent table?

most likely there is one already covering all the columns on that where clause - and if so the effective date should most likely...

you don't need to measure everything - if someone asked you to do that they don't know what they are talking about.

and comparing a proc over all others on a...

could be due to login not valid.

How are you setting up your connection string to DB2?

and is it using username/password or other method?

A simple google gives this

changing to read only does not prevent access to it.

changing security may prevent those that need access to it to do what they need.

So if it needs to be online...

either switch it off or rename it (in case data is volatile and someone needs to look at the old content).

Either will prevent unwilling access to it as Anthony mentioned.

you have not understood anything that was transmitted to you.

you setup a job - that job restores a particular database from a particular location - if name and location is...

I would also query the MAXDOP and (CTFP) settings - you seem to have a server with 64 HT (2 numa nodes) and you seem to either have a MAXDOP...

and sometimes being (or not) unicode also gives the same error - many times this happens because someone edited or created a file manually for testing and didn't set it...

your'e welcome.

try the following.

adjust number of columns as required - and if they vary hugely you can change that part of the code to be dynamic and based on the max...