Leland Walker (4/2/2009)

---

What I meant was when I try to start the job, by click on Start Job from the SQL Server Agent, it fails....If I schedule the job to...

Leland Walker (4/2/2009)

---

I checked a few things out on my end and it appears that the SQL Server Agent can not initiate or run scheduled jobs from the Standard Edition...

Oh, then in this case use the script below. It will use the current date/time for comparison. Ignore the InputDate variable.

Imports System.IO

...

Public Sub Main()

...

ismail casper (3/30/2009)

---

Hi, help please.

I'm writing twice to the same file in one Data Flow task and I get the error: The process cannot access the file because it...

mickielsmith (3/30/2009)

---

Forumers,

Thank you for all your very fast replies. I have found a workable solution. I can just add a comma between recipients in my toaddress string and...

Leland Walker (3/30/2009)

---

I have a SSIS package that has a Send Mail Task control. When I run the package from Visual Studio the email sends with no problem, but...

FistralAllstar (3/31/2009)

---

I am currently in the process of Migrating some existing DTS packages on SQL 2000 across to SQL 2005 and whilst some of the migrating has involved re-building the...

Check this message thread. Your listener and tnsnames have to be setup properly.

What protection level do you use for your package?

najeeb_khan_337 (3/28/2009)

---

Dear All,

I have a package that connects to oracle and dumps some data into text file. It works fine till here. Now I want to get the same data...

GGKK (3/25/2009)

---

Hi,

Currently we have a stored procedure (SQL Server 2000 (32 bit)) that calls a DTS package which processes an MSAS 2000 Cube Dimensions. This Cube is moved to...

shailendra (3/26/2009)

---

I am selecting from SQL server, and writing into Oracle. The performance is about 100 to 200 rows per sec. I have tried Oracle OLE db, and MSDAORA both....

The standard Send Mail Task doesn't support credentials. You...

This is double post. The same question is posted here.

Do you have OLE DB...