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! 😀

Here you go:

SELECT 'Employee1' AS [Employees], 'Car' AS [ModeOfTransport]

UNION ALL

SELECT 'Employee1', 'Bus'

UNION ALL

SELECT 'Employee1', 'Train'

UNION ALL

SELECT 'Employee2', 'Car'

UNION ALL

SELECT 'Employee2', 'Bus'

UNION ALL

SELECT 'Employee3', 'Train'

UNION ALL

SELECT 'Employee4', 'Car'

UNION ALL

SELECT 'Employee4', 'Bus'

UNION...