First download the Script Debugger from,

http://msdn.microsoft.com/downloads/sample.asp?url=/MSDN-FILES/027/001/731/msdncompositedoc.xml&frame=true

You could also download the documentation files from,

http://msdn.microsoft.com/downloads/sample.asp?url=/MSDN-FILES/027/001/728/msdncompositedoc.xml&frame=true

Then right click on the "Data Transformation Service" folder in Enterprise Manager and select Properties. Then click the...

OK, lets say your INI file lokos like the following,

[DatabaseCleaner]

! -- TableToBeCleaned_N=<table name>,<months to hold on db>,<months to hold on hd>

! -- <N> must be a...

quote:

---

I have found that the error log will log the step name not the task name. Also, I can rename the...

We don't rename the steps or tasks in our packages. Have found it best to leave well enough alone.

As for logging messages, we have seperate tables where "english" messages are...

If the section header will remain the same, you can create a VBScript that will open a FileSystemObject on the INI file. Then scroll through the file till it finds...

Good article. It's a pity Microsoft didn't think through the real-life development cycle for DTS packages.

FWIW, here's what I do with my packages. I pass the Server, database, userid, password,...

quote:

---

Try importing all rows into a staging table, do your validation on the data base table, then only import the rows that...

Where are you running PerfMon, on the Server or remotely from another machine? I've encountered problems previously running PerfMon on the server itself. Although I was running to a log...

Check out the redist.txt file on the SQL CD-ROM.

It'll show what files need to be copied and which files must be registered.

Thanks

Phill Carter

To have a number with leading zeros you'll need to define the field as char or varchar.

Are the leading zeros required for a genuine business need, or just display purposes?...

Rather than just Stand-by Servers, a forum more focused on all High Availabilty aspects of SQL Server would be more beneficial.

Thanks

Phill Carter

Have you specified the correct username and password for the package logging parameters?

Thanks

Phill Carter

Do you have any prompts or parameters that need to be entered? The package could be awaiting input.

What about the login used to execute the sp_OA procedures. Does it...

Does the package run successfully if you run it via other methods? ie: EM or DTSRUNUI?

Thanks

Phill Carter

Check out

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074

It gives some explanation about the security issues when running pacakges.

Thanks

Phill Carter