I think it is worth mentioning you are also working with SSIS.

Why are you trying to store rowversion into a variable?

Wouldn't it be easier to do the comparison directly in...

Can't you use User!UserID?

http://blogs.msdn.com/b/tudortr/archive/2004/07/20/189398.aspx?wa=wsignin1.0

Are...

martin.whitton (12/8/2011)

---

Just out of interest, does anyone know what would happen if you did try to create the 32768th database?

Is there an error message for just this occurrence?

And, no, Philip,...

Hmmm. When I click on the Forums link on the homepage, I get the maintenance page.

(http://www.sqlservercentral.com/Forums)

However, the link http://www.sqlservercentral.com/forums - with a lower f - works.

The forums themselves obviously work...

I do. It is the angry DBA I am worried about 😀

The best, most maintainable way is to store your packages in the MSDB database, and not on the filesystem.

If that is not an option, go with package configurations.

The problem is that you are processing two versions of the same business key in the same batch.

When you do a lookup on your destination, the business key doesn't exist...

Angelindiego (12/7/2011)

---

Greengiant....is there some special knowledge I need to move data from a table in a db to an xls?? I get conversion errors and it won't work. ...

:w00t: Easy one! Thanks!

It should be easy to test.

WITH CTE_Numbers (number)

AS

(SELECT ROW_NUMBER() OVER (ORDER BY sc1.name) AS number

FROM master.sys.columns sc1, master.sys.columns sc2)

SELECT TOP 32767 'CREATE DATABASE Test' +...

Congrats and good luck with the BI track.

Although they almost look identical, they are surely not. The first one has 4 column, the last one 3.

You can do some preprocessing, by removing the final comma from the...

Ah yes, you are still using the MIN aggregate, so you will of course get only one result.

I should drink more coffee.

I just noticed you are using in fact "MIN...

It creates a new column in your dataflow with the name that you provided in that property.

mic.con87 (12/7/2011)

---

The code works but it doesn't return the individual ClaCaseID's, rather a single value. I tried to add a group by clause but that didn't help, neither did adding...