patsipatochoa (2/13/2014)

---

It's much simpler your query, but i think query plan make a bad choice, because if SqlServer do it as it's written, not fail, and its a very simple...

dogramone (2/11/2014)

---

Koen and Phil (and anybody else who is able and willing to help),

I am trying and it is really showing my lack of knowledge, I have a book on...

.sln is a solution, not a package....

Giles,

Are you the Network Sysadmin with access to the firewalls and the like? This is typically a domain/server level setting. I don't know the specifics offhand on fixing...

Lowell (2/11/2014)

---

oh yeah no doubt about it Craig; but it does have a narrow use window for me, and it's faster than SMO generating the scripts.

It all started because...

Yes, it does. I was avoiding this conversation figuring a full on train wreck of a derail wasn't good for...

Just FYI: The only variable type in SSIS that's allowed to contain a NULL value is the Object variable, which is why you're not able to pass it in via...

Dear gods, someone sent you an Excel file as XML? That's simply evil. Excel is bad enough as it is.

I didn't notice a code sample to be able...

That is one LONG way around the pond, Lowell.

SSMS. Open database, click on tables. Go to Object Explorer Details window on right. If you don't see it,...

You have given us your business requirements, but we cannot see a thing about your system. We don't know how it's organized, we don't know what the tables look...

An article I wrote... gods, was it really 3 years ago?

http://www.sqlservercentral.com/articles/Career/73400/

Still a valid approach.

Lookup is fussy.

First, realize it's case sensitive. UPPER everything to make sure you're matching like to like.

Next, you have to tell it to ignore failures if you want nulls...

Probably security. What's the error in the Job history/step log?

Connect to the SSIS server, rt-click, execute package?

Otherwise, more details, please.

Double Extra Small and my beer belly... and only in pink?

I'm in. When are we doing the photo ops?