To get you started, read the following article:

Working with Excel Files with the Script Task

Example 2 Description: Check Whether an Excel Table Exists is the one you need.

I'm further answering your question on the MSDN forum 🙂

I don't see the link with certification, but anyway...

You first need to find which sheet you need to load from.

I think the easiest option is to find that sheet using...

Yahoo has SQL Server cubes that go into the terabytes.

You'll be fine as long as the hardware can handle it and as long as your processing window is large enough.

When I execute the command given in the question, I get the following error:

That's because you need to specify the...

n.heyen (6/14/2012)

---

Just in case anyone else runs across this little bit fo SSIS frustration, what we found was this:

The very last line of the SQL query did not have an...

Kiara (6/14/2012)

---

So, I'm moving to a new laptop. And trying to decide whether to stick with my dev environment installed locally on the machine, or building a/several virtuals to put...

No, that's not correct.

The default for a...

I didn't even know...

What exactly do you mean with "directory path held in an XML file"?

Include AND derived.Status = @status at the end.

Normally this should work:

Alter procedure [dbo].[Application]

@forename varchar(50),

@surname varchar(50),

@status int,

@origin int,

@pagenumber int,

@pagesize int,

@sortexpression varchar(32),

@sortorder varchar(4)

as

select OriginName,[Status],Forename,Surname,EmailAddress,CreateDate,LastUpdate,UseAccountNumber

from

(

...

Maybe you can share some more information?

What is the stored procedure supposed to do?

What is the structure of the table?

Read the first link in my signature about posting questions.

It will...

SELECT * FROM

(SELECT

myID -- something that uniquely identifies your row

,userAccount

...

There must be some other issue, because SSIS string variables can go at least to 4000 characters.

ps: please don't crosspost. If someone else answers on your other thread, it will...