Pratyus,

You can protect each DTS with different password for this purpose.

Regards

Utsab Chattopadhyay

It's resolved after removal and a reinstallation of SQL Server Express Edition from his laptop. The main goal for which we deployed this tool is to version control / change...

Issue resolved. But I am wondering if DBGHOST is so un popular?

Any idea from veterans what is a better tool for same purpose?

Regards

Utsab Chattopadhyay

Hi

I got the solution..Thank you all.

Also Tons of thanks to Dan Evans  for his continuous helps to get me...

Many thanks in advance for continuously helping me out. J I sent you a mail requesting you the file. 

Stacey

I would consider to go for using scripts to automate most of the stuffs then. Most of the important job done by a monitoring tool can be moniored by script...

Gleen,

You can happily increase the file from 9GB. SQL Server can manages TB of data. To manage your space on discs, you may consider to split your data into multiple...

Hi Dan,

Thanks for the advise. But still I am struggling L

When I am changing the XLS connection manager property à Expression à XLS File Path ==...

Try to use password protection on the packages. Then the packages can not be altered/dropped by any one except owner or sa/db admin.

Regards

Utsab Chattopadhyay

Thanks a lot Dan for the help. But I am still struggling with the step 4 and 5. Could you kindly help me on how to implement suggestions...

Hi,

Could any one help plz? Otherwise any pointer where can I go? [Also I escalated to the vendor ]

Regards

Utsab Chattopadhyay

Hi Daniel

Sorry for the elayed response.. I got it using the Derived Column Data Flow. Actually I am pretty new in SSIS / 2K5 environment.

Thanks for the help

Regards

Utsab Chattopadhyay

Henry,

One entry level doubt!!! If my box is running with SP4 [2040 Build].. what should I do?

Thanks in advance.

Regards

Utsab Chattopadhyay

Mike,

There are two main methods:

1. Use MAPI --> For this install a MAPI client [eg. MS Outlook]. It does not require any one to be logged in to the box...

John,

Have you added \PAE switch in boot.ini? If it is not there, please add that switch and then reboot the server once.

Regards

Utsab Chattopadhyay