Most of the data flow components have a error output pipeline that you can redirect that row to, in that path you can fix the data, after that you can...

There is an XML config file for the ssis server, I can't remember its exact path but it will be under C:\program files\[sql server 2005]

I'm willing to bet it references...

I don't see why not..

But absolutely only one can be running at a time..

CEWII

I'm like 99% sure that BIDS is only 32-bit, so it should work great with those drivers.. I just found this:

http://geekswithblogs.net/nestor/archive/2008/01/22/118792.aspx

Take a looksee..

CEWII

No, that one is built in..

CEWII

You could replace the C: with %SystemDrive% which on virtually every system is C:

I'm not a fan of the UNC path since it would require you to think about security...

I know this can be detected from a trace but I don't think you can do it with DDL trigger.. Most DBA's I've worked don't monitor this, they monitor...

You might try adding output to a file in the job that calls the maintenance plan (since it is really just an SSIS package)..

CEWII

You need to install the backward compatibility tools from the SQL Server 2005 Feature pack to see them, but they still exist in msdb, you just can't see them.. ...

If I read your question right you are trying to do a USE statement in a sproc and it won't let you. MY guess is that you are doing...

Good luck, I'm sure it will work out for you..

CEWII

I'm sure you can get to Facebook, but if they watch and you spend too much time there, you might get "counseled"..

CEWII

What kind of custom parameters? Do you want to pass in connection information at run-time or change the values of variables or modify a formula? All of these...

Have you setup the pipeline between them? What you might do is build the package and then save it from the object model to a DTSX file and open...

Do you have triggers on this table?

I have to admit I've never...