I think the point is whether they come checking or not, lets say that you are sloppy with your licensing and some disgruntled employee (or former employee) calls them up....

Just a note, please don't cross-post. Please make comments at:

http://www.sqlservercentral.com/Forums/Topic859017-148-1.aspx

CEWII

Just a note, please don't cross-post. Please make comments at:

http://www.sqlservercentral.com/Forums/Topic859017-148-1.aspx

CEWII

If you are migrating that many packages you might want to look at a tool like DTSxchange, I think it is called, by Pragmatic Works.

CEWII

Melton,

I have looked over the docs and I don't think I agree with that interpretation. It is my feeling that SQL Express was meant to not require this. ...

I'm not surprised by what you are saying. It is getting a datetime in both SSIS and DTS, however it seems DTS is dropping the time when it does...

I'm going to guess and say that the field in the pipeline in SSIS is defined as a datetime? Adjust it's type to be a character type (not text...

I don't think who is doing the authentication (SQL vs. Integrated) really makes any difference. I didn't see anything in the licensing FAQ that would apply to you. ...

Agreed.

CEWII

What else is on this server, it sounds like SQL is being forced to page out to virtual memory. What edition of SQL Server? 32 or 64-bit?

CEWII

I'm thinking dynamic properties task to query the environment variable COMPUTERNAME and put it in a global variable.. THen use activex script to interogate value and either succeed or...

I have several questions..

1. How are you moving the data? SSIS, DTS, Linked Server?

2. "When the data is inserted into the table it looks like this: 2010-01-01", How do...

Start with the SQL tutorials, they were likely installed with the SQL Express instance.

CEWII

The backups would probably be executed in the context of the SQL Service account, so whatever account your SQL Server uses to log in to the OS would be the...

I mostly agree with Jeff. Scale out with Enterprise is probably the best way. And SSRS is not cluster aware. You could probably build a number of...