incubator123 (7/14/2011)

---

Hi

Thank you for reply.But in my case the destination table is already exist and i want to maintain the data already there in that table also..Please help me!!

Regards...

SSAS developer:

someone who creates SSAS cubes (including DMVs and dimensions).

Probably able to write DMX.

If you are looking for to apply for a job with the description of SSAS developer and...

ALL the possibilities?

So also "hire a consultant to do it for you"? 😛

Why...

You can read the contents of the file and use a Recordset destination to store it into an object variable.

Then you can use a ForEach Loop that uses an ADO.NET...

Interesting article 🙂

But I had already heard that...

cengland0 (7/13/2011)

---

Somehow I knew I was going to get this wrong and I was wrong indeed. However, this is why:

http://msdn.microsoft.com/en-us/library/ms189629.aspx

States, "Affinity support for servers with 33 to 64 processors...

As it can become quite a long binary string, you can also try converting the image to a hash value, which allows easier comparison:

WHERE HASHBYTES('MD5', cast(ImageColumn1 as varbinary(MAX)))

= HASHBYTES('MD5', cast(ImageColumn2...

Which actually brings this thread back on topic! :w00t:

Gianluca Sartori (7/13/2011)

---

ALZDBA (7/13/2011)

---

Koen Verbeeck (7/13/2011)

---

I handed him "a" solution. And that he doesn't complain, he got *exactly* what...

Oh crap. I had already trouble putting all the new features of CTP1 into a hourly session.

How am I supposed to...

If you can install 3rd party components, try the following:

http://www.sqlis.com/post/file-watcher-task.aspx

It is much easier to configure than the WMI Event Task.

And yes, your package needs to be running, but an idle...

Here you can find a presentation I recently did on SSIS Denali at the Belgian CommunityDay:

http://www.communityday.be/data/PPT/What’s%20new%20in%20Denali%20SSIS.zip

The subtitle is conveniently: The Undo Feature and Much More 😀

And indeed, very exciting shizzle...

To take an interview or to give an interview?

To take: if you have enough experience it won't be a problem. If there's something you don't know or didn't do, just...

I handed him "a" solution. And that he doesn't complain, he got *exactly* what he asked for! 😀