sdvoranchik (7/13/2011)

---

You should be able to just add a simple where clause:

select * from [download$]

where column1 = 'value'

You can use all of the regular sql syntax from here to...

The reason for the initial error is that a stored procedure doesn't have an explicit metadata contract, such as a view or a table-valued function. But SSIS does expect metadata...

Phil Parkin (7/14/2011)

---

asranantha (7/14/2011)

---

hi friends,

plese solve this and send my mail id =asranantha@gmail.com

...

You're probably doing something wrong 🙂

So you have a string variable at the package level which has the connectionstring as the value, right?

Is it hard-coded, or loaded by an expression...

GBeezy (7/14/2011)

---

Which path, DBA or DB Dev, has the best outlook over the years come? I agree, with the DBA Dev translate to the BI Dev easier. BI...

If your question is:

"How to found out how many rows we processed today with SSIS?""

You need to set up logging to investigate that. The standard SSIS logging only logs the...

Try using signed integers instead of the unsigned ones.

Well there isn't anything out of the box to do that for you (yet, in Denali it will be possible).

So if you really want to generate the metadata, you'll need...

The first one I got from a quote from Matt Mason (developer on the SSIS team), the...

Craig Farrell (7/14/2011)

---

Hey guys, does anyone know of boot camp training session(s) for SQL Server for practical skills (not certifications). I'm talking real basics here. I didn't see...

The method seems OK to me. Do you use package configurations to change the path at runtime?

Joins maybe (although I was under the impression that it...

David.Poole (7/14/2011)

---

My data warehouse project is trying to integrate 60+ lines of business that function almost as separate companies into a unified whole (or hole). The referential integrity, domain...

opc.three (7/14/2011)

---

The list of new features is impressive...lots of my past gripes have been addressed 🙂

Huge improvements for me:

> Load files...

And this is you solving your problem on your own...