You can't dynamically assign a file to a source. Everything...

This is a very, very, very common problem with SSIS and Excel. It shows up in hundreds of blog and forum posts.

Have you tried Google?

The issue is that Excel guesses...

Can you give more configuration details? What have you done so far?

In a for each loop, you can specify which types of files the loop has to pick up. Maybe...

In SSIS you can use the precedence constraints (green, blue, red arrows) to control the flow of your package.

Double click on an arrow and you will arrive in an edit...

It is normal that when you want to run a job manually, you get a pop-up asking you at which step to start.

That way you can skip steps if you...

Don't set anything at the Parameter Mapping. This is intended for when you use variables in your SQL Statement.

Just set the resultset at 'Single Row' in the general tab, then...

Right, sorry. In my current environment we have 32-bit and 64-bit co-exisiting and so we have a program files (x86) for 32-bit and a regular program files for the 64-bit...

http://krisvenky.tripod.com/id18.html

First result on Google for the search terms dimension facts.

arik_beri (6/24/2010)

---

Thanks Chris, it sure looks much more simple that way.

But yet it still doesn't work. When I copied this expression to the expression column in the SSIS edit box,...

What Elliot W was trying to say is that you should run the package in your job in 32-bit mode.

Start the package with the following command:

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\DTExec.exe"...

I would store the filename in a configuration table. At the beginning of the package, read the filename and set the connection string with an expression. At the end of...

facticatech (6/23/2010)

---

You need to use Execute SQL task to get the Max Surrogate key and store it in a variable. And then use a script component to increment the Skey...

What exactly is going wrong? Does the package crash or do you just receive faulty results?

Can you give the error messages?

Are there any null values in the source?

Most of the times when my packages end up hanging, it has something to do with locks.

Either a deadlock or a table lock that isn't released by another job...

Has the table dbo.test_delete_yes only 1 column?