And to add:

I've also logged in directly to the server, and run SSMS there as the SQLServer Service user, and as a Domain and SQL Server admin, and run the...

Thanks for this. Can't wait to see the article on files as linked servers. I have a csv connection that's driving me nuts. It used to work.

What I can't believe is that MS included snippets for CURSORS!!! Egads, what have we been saying (Jeff Moden) for years? NO CURSORS!! OK, some cursors, but only when...

Fuzzy lookups in SSIS

If this is SQL Script Manager compatible, where is the .rgtool file to download?

Edit: I found it, but boy that was unclear.

Phil Parkin (12/10/2010)

---

One thing I should check: you refer to a 'temp' table. I assume you mean a staging table? Temp table is not the ideal mechanism, given the size...

Phil Parkin (12/10/2010)

---

Is there any reason why you cannot engineer the entire process, from picking up a row of data from your source, to inserting it into your target table,...

Yes, Craig, your descriptions does summarize it very well.

I don't know how to restate the first post to be more clear.

here is a screen shot of the package. I hope this loads.

(Why is there...

da-zero (12/10/2010)

---

Where is that SQL Task with the update located? Between the two dataflows?

If yes, then your situation is normal 🙂

You can keep everything in one dataflow, but then you...

My questions is more like, why do I have to create a temp table?

I have one dataflow that imports the data, then saves to a temp table.

Then another data flow...

kevin.l.williams (12/9/2010)

---

I cheated and got it right!

By the way, how many of you read...

I'm a developer /DBA aDmin, and I can totally see where something like a tablet would help while I'm at work (no commuting advantage because I bicycle in, I can't...

WayneS (9/17/2010)

---

Add an Execute SQL Task to get the value from the database.

Put this value into a variable.

Add a For-Each Loop container.

Double-click the For-Each Loop container.

Click on the Collection tab.

In...

Michael Valentine Jones (10/27/2010)

---

Dan Guzman - Not the MVP (10/27/2010)

---

So, is this the simplest and quickest way to get the last day of any month?

DATEADD(MONTH,x,'2010-Jan-01')

Where x is the month...