I've just posted another VBScript that sets the DTS Package Logging properties for groups of DTS Packages. It's titled "Set logging properties for group of DTS packages". It should be...

quote:

---

All I need now, for life to be perfect, is for someone to tell me how I get commas in the thousands...

Have a read through "Transaction Log Architecture" in Books Online. You should find the answer to your question there.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface...

Is it possible to get the "Logout | Register | Active Threads ..." menu left-aligned on the page?

When there is a post that doesn't wrap the menu gets pushed way...

I agree CONVERT does have the advantage of being able to change the output format. It's also handy to bear in mind that you can use CONVERT's type parameter for...

Firstly, what are you using to view the text file output? To see the results correctly you'll need to use something that understands the control codes like MS Word.

Also,...

I'd actually like to second that suggestion about attaching a file.

Especially for things like DTS problems. It can get a little confusing explaining the workflow of a package. In this...

quote:

---

Quick brainteaser for our beginning DBA's: what's the quickest method to strip out the time from a DATETIME field (returning only...

Do you need the blank row for the formatting? Can't you apply the formatting to the title row?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click interface

We would be glad to provide you all the help you need.

How about posting the actual query you're running and the table structure.

Hope this helps

Phill Carter

--------------------

Colt 45 - the original...

Well having the staging table on SQL Server will give you a "more elegant" solution than using Access.

For reference, importing data into staging tables, then performing data transformations whilst...

Why are you using Access as the intermediate step? Can't you create a staging table in the SQL Server database?

Hope this helps

Phill Carter

--------------------

Colt 45 - the original point and click...

You have a few options,

1) define a seperate transformation for that column. DTS has a builtin datetime transformation task.

2) perform an ActiveXScript transformation for that column. This would be necessary...

If you're copying and pasting into Excel, output to text and change the results to tab-delimited.

Then you can copy and paste the whole lot straight into Excel.

Hope this helps

Phill Carter

--------------------

Colt...

AER, have a look at the script I've posted here,

http://www.sqlservercentral.com/scripts/contributions/569.asp

It does a find and replace within ActiveXScripts. Probably be able to modify it a bit to search other properties or...