You wrote:

"I'm getting a DLL error when I connect to Integration Services instance from SSMS. This is another seperate issue I'm troubleshooting also."

What is the error?

"Cannot find SSPI context"?

If...

(1)

Is it possible for you to run the package in debug mode using Visual Studio locally on that server?

Would it run successfully?

I assume that when you were developing and testing...

I'm totally on board with the notion that in a crisis situation I need to be there for my workplace.

I also think I am a fairly ambitious and driven individual,...

I have done some ASP.NET development in the past....

Sometimes, cutting a finger is what it takes...

davidsalazar01 (2/13/2008)

---

Hello,

The error I'm getting is that it can't create or access the "filename".csv file on the local drive. I have all the SQL Services running under the doman...

RDP as the domain acct to the machine on which the SSIS package is running.

Can you access the drive, using the same path as the one specified in the package?

In my experience, employees just starting out in the IT industry are more likely to be victimized into working an insane no. of hrs.

I started out a few years back...

Matt Miller (2/14/2008)

I'm however averse to making SQL Server the automation tool to run other things, like - file maintenance, Active directory security, etc.... There are good reasons that...

In my workplace we have recently started replacing xp_cmdshell calls with specialized calls to database objects (sprocs/UDFs) that perform file system manipulation tasks, eg. file deletion, directory listing, detection of...

Thanks Todd! This is great!

I will not be able to try the download as yet, but I'm taking a note of it so I can try it when I'm back...

kirk (2/10/2008)

---

I have been trying to figure out how my tempDB ballooned to over 18G. I think I know why but I want to get expert opinion on my...

Ziljan4 (2/12/2008)

---

What are some of the ways to know that Blocking has indeed occur in your database, and what would you do resolve it? is killing the spid only option?

&

What...

exec sp_blocker_pss80;

"sp_blocker_pss80" gives blocking-specific output.

Look it up and download from the web. Install in master db.

Transient blocking is a normal occurrence and a consequence of database concurrency. It becomes an...

tempdb data files should be in their own drive, preferably separate spindle.

Log can be placed in the same drive as the other log files.

create as many tempdb data files as...