Probably.

But unless you provide a better description of what you are trying to achieve, that's the best answer I can provide.

Here[/url] is a link to an article which will describe...

Haha,...

Stringzz (2/1/2011)

---

I figured this one out. I put the following line of sql at the end of my code, and did a result set looking for the RowCnt and populating...

You'd be wise not to mention the 'c' word in this forum 🙂

Have you tried SELECT ... rather than RETURN?

Koen (da-zero) (1/28/2011)

---

The...

The power of Google is there for you as well as me, but since you're new I've done it for you, just this once. Check here.

Try removing the double quotes from your expression:

@[User::LopVariable]==@[User::IterlopVariable]

A pleasure.

Are you running the package as yourself, or another user? It is good practice to use a UNC path to your file, rather than drive letters, as these are not...

I'm with Koen. There was no need for an SP - running the count query and assigning the result to an SSIS variable can all be done in a single...

Please post the text of the error message from the job history.

Or it might be possible via a conditional split (just redirect all the unwanted rows to an unused output and keep the good stuff) - don't use SQL Server at...

What is your OLEDB data source?

Derrick Smith (1/25/2011)

---

I always try to keep my queries as SPs on the database itself, and then reference the SP from the package. Makes maintenance/troubleshooting much easier.

That would also fix...

I'm guessing that there can be a lot of files in this share that you do not wish to process?

An alternative solution may be to nominate a folder on the...