Thanks for your reply Florian,

For the first idea, which implies a bit variable, it would be a good idea, but I can't count the rows from a procedure if I...

Is there a way to get the row count from the procedure, in the bcp, and not create the file when there is no row returned?

Your name must have less then 4 characters? This is why Len returns less then 4, then substract 4, and send to the right function, it says invalid parameter, since...

A stored procedure does NOT implicitly create a transaction, so your second statement sounds like the way to go. If you want to be within a transaction for that case,...

michael ham (3/9/2009)

---

Dean Cochrane (3/9/2009)

It's recompiling because the schema has changed. This may be due to declaring temp tables partway through the procedure. At least, that's where I've run into...

noeld (3/5/2009)

---

florian.reischl (3/5/2009)

---

Wow, that's some news there! How can you not like identity columns? I tell database developpers to put 1 on each and every table in the database. Only...

Wow, that's some news there! How can you not like identity columns? I tell database developpers to put 1 on each...

Can you post some real data using the...

Thanks Tim, it worked perfectly! I also changed to put a OleDB Destination as you mentionned. Thanks a lot!

Greg Charles (2/9/2009)

---

On way is to use the MS recommended method (see "deploying packages in BOL) and build an Integration Services project in BIDS to create a package depoyment utility...

Nice! Thanks for those quick answers!

Another question I have is how do you extract a package from the Business intelligence studio, or, is it like in VB, just build the...

I don't think that is right.

When you change a row in the vendor, yes, there's only 1 impacted row in THIS table, but if there are 50k corresponding items in...

You mean I should update the "Key" field depending on the value that has been updated in the Vendor Table? This makes no sense performance-wise... How am I gonna get...

i've done some browsing and found a lot of ways to add a computed column on a table, from another field in the table, but can you add a field...

Well, if you are saying the commas are not always equally disposed, it will be pretty hard to get a script to do this. It looks like some manual work...