Can yoi post the file? If not comfortable posting on the Forum send me a personal message (PM link on posts) and I'll send you my personal email address.

Both. Under duress especially. Even when systems are mostly idle you'll see jobs that...

SSMS leverages SMO for that, which is installed with the client tools. I do these types of tasks with PowerShell referencing SMO. To my knowledge there is no command-line access...

Try after launching SSMS using "Run as Administrator".

You'll need to install the Microsoft SQL Server 2005 Backward Compatibility Components (SQLServer2005_BC.msi, SQLServer2005_BC_x64.msi or SQLServer2005_BC_ia64.msi). Then you can use DTSRun.exe to execute a SQL 2000 DTS package from the...

PGV (4/12/2012)

---

Hi,

I am writing an SSIS package that imports data from a text file into SQL Server.

I have a data flow for that with a flat file source and an...

I tried your code against a few of my servers (Server 2008R2 w/ SQL 2008 instances and Server 2003R2 w/ SQL 2005) and it worked fine (mostly, see below), although...

It sounds like you were using the Table Designer in SQL Server Management Studio to add your column. I sometimes use the Table Designer for viewing existing tables but we...

If it's HTML, then it's XML...have you tried parsing it in SSIS using an XML Data Source?

Check the "Remote Registry Service" on those machines you are not able to access, see if it was turned off / disabled.

tt-615680 (4/12/2012)

---

Brandie Tarvin (4/12/2012)

---

Why does the replacement user need similar privledges? You're just shooting yourself in the foot.

Remember, least permissions needed to do the job (figuratively and literally) should be...

It's the case with a lot of schedulers, not just SQL Agent.

One word of caution, make sure you delete your job history for this particular job quite often as it...

Brandie Tarvin (4/12/2012)

---

What Gail said on the above. Except, if I recall correctly, does the job run under the credentials of the person running it (if it's run manually?), or...

MissyDaisy (4/12/2012)

---

Your suggestion will work optimally. Unfortunately, I can't implement it as the service account does not have write permissions on Database2 tempdb and never will.

So I...

For the client operating system follow this article.

For the server, since you've posted in the...