I can understand your point of view. Some article do take some wading through before you get the gist of what is going on.

Bill. I think your comments are rather harsh.

It read quite well to me and was completely understandable and well presented even if the grammer was slightly lacking.

Remember, the people...

The main problem is always re-running warehouse population when using the check last day inserts/updates/deletes etc. With that logic you can end up inserting duplicate rows if you need to...

Take a look at osql.

Basically, you can write a query that will send the output directly to a text file with a few parameters thrown in for formatting.

Take a look...

If this is going to be a popular re-runnable query, a quicker response will be gained by using another idea.

Create a linked table from the source table which includes patientID...

To query this information going forward is not recommended. Basically, you are going to have to find the last c/f figures by groups and do the same for new and...

I'm pretty sure that if the date does not exist then dts will not run it.

If you can afford to wait for a week, try scheduling something to run on...

DTS is not a dynamic tool in terms of mapping source and destination columns.

In you case, I suggest you use osql to output directly to a text file using dynamic...

Interested to see for what purpose you want this format.

Anytime I want to display the data in a different format, I use the application that the data will ultimately be...

If he is only reading data out of the table then give him db reader on the database.

If he wants to insert as well give him db datawriter additionally.

That should...

The only other way is to pick the values up from an ini file.

You can put nt file restrictions on the ini file to sort of hide the text.

Use the...

It's not so much dts authentication, rather it's at database level.

As long as the account has authority to the objects in the package (eg database connections, stored procs etc), then...

Never really looked into it. I have found good articles on this sire before. Maybe it will help you out.

http://www.databasejournal.com/features/mssql/article.php/3327681

Come back to the forum with an answer if you get...

If you have a back up of msdb you can get it back from there.

However, do not install it over your current msdb as it will probably cause you big...

Nice workaround. Workgroups must be the worst type of security EVER on any database and caused me major headaches when I used to administer a pool of access databases back...