SSIS.COM (8/10/2010)

---

Hello,

I have created a view joining sysjobs, sysjobhistory, sysjobactivity tables to log the execution of jobs running through SQL server agent. But it looks like the records in sysjobactivity...

pat-261672 (11/21/2007)

---

Hi,

I am trying to set up job to run ssis package on 64 bit SQL 2005 EM. but it errrors out and gives me following error:

Message

Executed as user:...

a

yep, that's what I figured. It's formatted properly in notepad. Thanks for taking a look.

Excel

Thanks to all of you for your help. The solution is simple and it's an SSIS best practice as well. "Use SSIS Package Configuration". Basically at runtime my Data Sources...

I followed the steps above but still got the same error.

djciko,

Were you about to execute this package? If not, what error message(s) are you still getting?

Clearly you have run into memory issues. What is your system setup configuration? Is this a stand-alone SSIS installation? Are other SQL components sharing the system resources? How much data...

1) No, I am not using configuration files with my package. My Data Sources are defined at the project level and added to each package.

2) Yes, the package is...

Thanks for all of your inputs -- it's really appreciated. EJ, I reviewed the links you shared and found a solution that works. Basically I am using the File System...

I know.

I have not used the Compact edition much but never knew there were differences in syntax...very interesting.

You are right jvanderberg, it is the syntax for SQL Server Compact.

Thanks for taking a look.

You are right, Fraggle. The syntax ALTER TABLE table_name ADD CONSTRAINT DF_constraint_name DEFAULT('hello') FOR column_name works perfectly. I was just wondering why the BOL syntax was giving that error.

Thanks

Theo,

Thanks for sharing the solution.