You can only construct expressions in a Conditional Split that apply to the columns in the current data flow. So if you need to do a lookup to see...

If you're trying to use a Script - UR doing it wrong 🙂

It even sounds like you're using the script to do the lookup - and you shouldn't.

Use the Lookup...

The File Properties Task doesn't use any T-SQL at all - it uses the System.IO namespace which is .Net code. And no - it's not SQLCLR either. It's...

You can add your "conditional checks" right into your SSIS package, so the SQL Agent job is just a simple "run this package" step.

You can use a Script Task with...

You wouldn't necessarily need to pass that recordset down to the Data Flow Task - I wouldn't think of doing that as my first choice. What I would do...

It's not an issue that VS or SSIS 2008 can solve. It's an Office issue. However, there are definitely very usable workarounds, and some good news about Office...

Office itself (in its entirety) doesn't need to be installed, but you'll need to (at least) install the providers. Go here for the download: 2007 Office System Driver: Data...

Quick answer for you - no.

Don't think you'll like that answer though. Your only solution is to install 2005 - which you can (apparently) do safely. Personally, I...

Here's the docs for DTExec, including command line parameters: http://msdn.microsoft.com/en-us/library/ms162810.aspx

I read from your post that you were using SSIS 2005. Agent jobs in 2005 don't have that handy checkbox, so you have to use an OS Step. ...

There are (of course) a lot of ways to accomplish what you want, and your posited method should work.

Keep in mind that for #1, you're going to have to use...

You should read up on the issues that are common with the Excel Provider in Douglas Laudenschlager's blog - posts tagged with Excel.

The problem you're having is that Excel is...

You can also use the one-step method of installing a custom zip task - there are several out there, the first two of them are free (source included) - no...

Not exactly sure - but you can debug your component by starting up a session of Visual Studio and connecting to the DTExec process. Set a breakpoint in your...

Or just search the SSIS Community Tasks and Components[/url] directory for the word "zip".