you can resolve problem of invalid records by using error path of your SSIS component (Red line of component).

Try this link :

http://msdn.microsoft.com/en-us/library/cc304392.aspx

"Lesson 3: Handling Data Flow Errors...

Hi

you can use Reporting services configuration Tools.

this link contain detailled information about this tool:

http://technet.microsoft.com/en-us/library/ms156305.aspx

Hi

- First you can deploy package in SQL server DB or in DTS directory or let it in file systeme .

- You can find SQL Server Agent in...

hi

you can use SSIS 2005, it is most performent than DTS.

and you can planify your package in SQL server Agent to be executed every day, week, or month.

create SSIS project...

hi

review installation of SQL server 2005, install SP2 if you didn't install it, and review hardware&software requirements.

when you double clik on Source view -> Identity wich check box is enabled:

try to use default

hi

you can use DataConversion Task to convert unicode to DT_STR

hi

can you give me more details especialy errors returned by SSAS

Hi

Every DBMS has its own datetime definition

I supposes that SSIS gets back the information of the field DATETIME of MAS90 as DBTimestamp

At any rate you can solve the...

Hi

I have working with on 1 project, I also have to realize many Proof of concept for a set of customer

In fact Performance came to add more integration and...

hi

i used named query in 3 BI project of international company

i don't remark any difference between named query and simple query or direct views

hi

verify if SQL server agent has the autorization to access of oracle database or create an configuration file and use it with SQL server Agent

if your excel file has always the same name and the same path you should check overwrite destination of the file system task

else you can use variable to change the...