Hi.

Why don't you use an Excel Source and an OLE DB Destination to accomplish this?

That...

Nice question!

I learned something new about SSIS, a product I work with every day.

(I got it right, but only after some experimenting in SSIS).

Sorry if this sounds rude:

if you want the complete solution, hire a consultant.

Phil and I have given you enough hints so that you can...

Well, apparently the original poster didn't. 🙂

Dammit, I remembered to change the .be to...

Use the stored procedure in an OLE DB Source and then connect your input with an OLE DB Destination component.

To use the input parameters, it is best that you store...

http://www.google.com/search?source=ig&hl=nl&rlz=1G1GGLQ_NLBE331&q=ssis+ebook&aq=f&aqi=g1&aql=&oq=&gs_rfai=

And don't forget variables and expressions!

Professional Microsoft SQL Server 2008 Integrations Services from Wrox is a very complete and comprehensive book on SSIS. It covers too many subjects for a beginner, but you can read...

Well, one thing that can go wrong is the connection strings to your databases. In 2008 they differ lightly from the 2005 version.

Paul_Harvey (8/18/2010)

---

I hope someone can help.

When I open one of my SSIS packages in Visual Studio, the control flow screen alway open on the bottom right of the "canvas", and...

Raunak Jhawar (8/18/2010)

---

Phil Parkin (8/18/2010)

---

This is an SSIS forum,...

The solution you worked out seems fine to me.

You only need to make sure that no other .txt or .xls file comes in with a different metadata structure, as it...

That is indeed very odd. Maybe even SSIS can have the Monday blues?

If you use trim functions in the lookup component, don't forget to provide aliases for the columns!

(sorry, I forgot to mention that sooner :))

If you don't do that, every column...