Is there a requirement that it be an open-source tool? My gut feel is that an open source tool will cause you more coding.

I've not used os...

sounds to me like normal verbiage on a failed process.

What you need to do when it fails is poke around in the top window to find the actual error message...

whew, ok, yes, Thank You, and pardon my adding confusion!

I have used ProcessInputROW plenty of times, that's what is stuck in my head.

Sorry !

I know what that link said, but I can absolutely confirm that when I use script component as a transform that it is called Per Input Row, not per buffer.

I guess I am puzzled as to how a graphic would be displayed at all in SSIS? Can't imagine SQL Agent being ok with it, and there is no...

could be user permissions, based on the actual text of the message. If the package runs fine but it's only when executing this step, then I think something else...

venus.pvr (10/3/2012)

I have a requirement to see if any rows are present in the input. If they exist, I just have to set a uservariable to true and exit. ...

steve.burton 78514 (10/4/2012)

I am using a MERGE JOIN SSIS transformation to join the results of 2 queries, which already contain joins in the SQL. I am expecting some NULL values...

You do realize that this thread is very old??

In an effort to be helpful,can you tell me first why...

Problem is, he doesn't touch the warehouse and is telling me to find out why !

But what you are saying is that potentially changes in the source servers could cause...

Ah, Steps Forward!!!! YAAAY!!!

I was delayed in launching a case with MS and haven't learned much yet, but, he did confirm that the Att Key Not Found is...

I'm not sure quite what you are doing with Access macros in conjunction with SSIS? Using as a front end you mean that it fires ssis packages??

can you...

YES, you can set up logging via SSIS:

http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx

Great Article I keep handy.

File is very easy, just remember that it is a new data connection - whoever configures the...

That's a major beef of mine, having to set your settings Every Time. I'm sure there is a way around it, but, damned if I know what it is!!

Yes,...

Nope, still stuck. Boss is looking at me like I am the biggest idiot but after pulling a double shift Thurs tryign everything I could find, I am also...