The only pre-requisite to run packages via DTExec (i.e. the replacement for DTSRun) is to install Integration Services, you don't need to install workstation components.

I think this is analogous to...

What logs are you talking about? Agent logs or those provided by a SSIS log provider? If its the former then you should read this article: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html as you will...

Scheduling: Use SQL Agent. And leverage the advice here: http://wiki.sqlis.com/default.aspx/SQLISWiki/ScheduledPackages.html

Only new updated data: You're going to have to use a timestamp column on the source rows to determine if...

There is no requirement to "declare" these variables. They already exist within the package. Have you looked in the "Variables" pane when inside an eventhandler?

If you want to use them...

SSIS is certainly better at this. You could import the data as a recordset with just a single field continaing a long string and then parse it out in the pipeline,...

What do you mean? To do what?

You can use whatever you want in an eventhandler?

-Jamie

The OnError eventhandler contains the information that you mentioned in the following variables:

• System::ErrorCode
• System:ackageID
• System::SourceName

plus others such as

• System::ErrorDescription
• System:ackageName
• System::SourceID
• System::SourceDescription

So you have...

http://blogs.conchango.com/jamiethomson/archive/2005/09/01/2096.aspx

HTH

-Jamie

I agree. Building your own expression library would be really useful. Have you requested it at the feedback center (http://lab.msdn.microsoft.com/productfeedback/default.aspx)?

-Jamie

Yeah, building property expressions on variables is a pain. SP1 contains an expression editor that makes this a heck of alot easier.

In the meantime, the best method is to build...

The DTS runtime is distributed with SSIS. There is an Execute Package2000 Task in SSIS that allows you to execute DTS2000 packages. I think you can execute DTS2000 packages from...

Whilst not agreeing with it, I accept your opinion that

a) Microsoft are seperating themselves from their customers and

b) They are creating problems for their customers

Can you please clarify why that is the case?

-Jamie

If people don't send feedback then its their own fault that it doesn't get acted upon. You can't blame MS for that. Its not as if its difficult to submit...

They do still screen the requests via the feedback center tho. Many of mine have been linked to a duplicate or something in a similar vein (another good thing in my...

Steve,

Do you not think that your requests are more likely to be read and comprehended when they are submitted in a structured format (where you are forced to enter all the...