Use method 2 from here: http://www.sqlis.com/default.aspx?311

-Jamie

Joe,

The LOOKUP transformation only supports equality comparisons. I would hope that this be addressed in the next version (along with a few other issues I have with the LOOKUP transform).

Inthe...

Manisha,

You can create custom tasks and components in C# and within there, as far as I know, you can use any .Net control in your UI. Would this help?

-Jamie

P.S. The Script...

Rick,

On the surface it would seem that you can't do this because the Flat File Adapter expects files with known and consistent metadata. In this context your files could be considered...

Ah yeah, sorry. Debuggin doesn't work in the script component. Your best bet is to raise some OnInformation events at various points at the code - this works a  bit like...

The buffers are declared outside of this and I dare say that Manisha used Intellisense on this object to call methods on it - which would prove that the use...

Its virtually impossible to say what's wrong from the information you have given. You need to debug the code using the built-in features that enable you to do that. Put...

No problem. You should take a look at the post concerning folder structure cos that has alot to do with the deployment issues that you are currently weighing up.

-Jamie

Yes, all stored on a central server.

We run them using dtexec.exe.

-Jamie

I prefer to not have my packages on any server - I have them as flatfiles instead.

You can still control them from the SSIS node in SSMS.

-Jamie

Yeah there are a number of options. You could use the WMI EventWatcher Task to watch the folder for it appearing or use the FileWatcher task from SQLIS.com.

-Jamie

I started back in Feb 2000. I joined a new company (INT 21) and on day one they sat me down with a book called "Data Warehousing on SQL Server...

No problem. The reason you read something that isn't there anymore is cos I misread your original post and wrote something that didn't make sense - so I got rid of...

Hang on, I'm lost.You say there are no OnSuccess constraints. Not only is it there - its the default.

You are talking about control-flow right?

-Jamie

You've lost me. What is the difference between:

"We only want to execute this on successful completion of the previous task"

and

"not just completion was either success or failure"

???

-Jamie