You shouldn't need to do anything with the schema in 2005.

I'm not real familiar with OPENROWSET, but it appears that the OPENROWSET command in SQL Server 2005 is using varbinary(max) as the SQL Server datat type for SINGLE_BLOB in the...

Grant Fritchey (12/17/2008)

---

Personally, C#. It's what all the cool kids seem to be doing these days, so it's more likely to allow you get jobs and/or recruit people into the...

I'd pick VB.NET. You have some classic VB experience and most syntax has stayed the same (If, While, etc...). I also like the greater verbosity of VB instead...

I've never used any of the others, so I can't speak about their performance and usability, but IMO, the best feature of SSIS is that it is included with SQL...

Your derived column should do something like this:

x==True ? x + y : Null(DT_I8)

You need to choose the correct data type in the Null, but that is the basic idea.

MarkusB (12/17/2008)

---

You have two options. One is writing your own function which generates new ID's.

The second option which I would prefer is using two columns one for location and one...

There is setting in the replication properties for how long to keep a subscription active if there is no connectivity. I believe the default is like 72 hours. ...

Unfortunately, based on my Google search, a lot of people are having this problem, but I have not seen a solution. There may be, but not likely, a fix...

First I should say that I am not a replication expert, but based on the error message it appears there is a difference in the security setup on the 2...

Sergiy (12/16/2008)

---

Just don't update what does not need to be updated:

update [my_table]

set [row_uid] = newid()

...

Grant Fritchey (12/16/2008)

---

MGS (12/16/2008)

---

I would like to be able to create a foreign key reference in a child table to part of a compound primary key in the parent table....

Thanks for posting your fix. Many people don't do that.

I've had the same problem with the .NET provider to DB2 as well. IBM seems to break...

I have to admit I have never tried what you are doing, but I am not sure it is possible either. I think you are just getting lucky with...

Grant Fritchey (12/16/2008)

---

Human beings do not look at 200000 rows worth of data... ever. So, you need to identify the data that is actually needed for the report, the last...