File groups could help if you do frequent data backups on this VLDB where you can back up each devise simultaneously. I don't read that you need to do this.

Is there a way except advanced editor to change the data type of all columns of excel source in one shot instead of doing for every columns one by one...

This is fine if the value is still a ratio,...

SELECT

CASE WHEN LEFT(Customer.StartDate, 2) = '98' THEN substring(convert(varchar(20),Customer.StartDate), 3, 2)

...

When you use 'like' you are opening the door to multiple rows being fetched. Why could you not pass the exact table name? Your issue may be more upstream.

You can import the data as a string and in the dataflow manipulate the string in a derived column transformation to put it into yyyymmdd format, and append that to...

The user account used for SQL Services has to have local admin privileges and the Log on as a Service right.

Based on your data flow, did you encrypt the copy of ssn columns and then tried throwing that encryption value into an Excel cell? This may be causing your error...

As the name "analysis services" implies, you are analyzing data. Think of it this way, the ETL paradigm. SSIS brings in data. SSAS transforms data into information. SSRS reports the...

Stop SQL Server and restart it in single user mode. Then from management studio right click the master database and and use this menu to restore form your backup device....

You may need to coordinate with your IT group. Sometimes the Exchange server ( I assume it is Exchange) may have rules that do not accept messages from unknown domains...

The lookup function is not available in SSRS 2005. Wondering if the OP still has this issue.

I would add the group id that the employee is in to the dim user table as well. This will allow group counts.

The user wants to compare this year to last. You can create two temp tables representing counts this year and last, grouped on date (no time portion) and status....

Hi. Is there been any updates on this matter?