Data Sources and Connection Managers

Greetings my SSIS friends

This is probably a silly question but what exactly is the purpose of creating Data Sources when it is possible to set up individual connection managers?

Thanks for your help in advance.

If you want to reuse connection managers across different packages, you can create data sources and choose new or existing data connections.

Data regions

Greetings,

Can someone explain the rationale as to why nested data regions are restricted to use the same dataset?

Craig

We didn't have time so far to implement hierarchical data source support in our processing engine - but it is under consideration for a future release.

Anyway, there are a few options available today to achieve similar results:
* join the datasets already in the query (e.g. by using linked server functionality)
* use subreports for the "nested data region" - but this is usually not very efficient
* use SQL Server 2005 Integration Services to join the datasets in the query (there are various options to perform such joins) and use that SSIS package directly in reporting services as data source.

-- Robert

|||

hey Robert,

can you point me toward some documentation on how to do this:

"use SQL Server 2005 Integration Services to join the datasets in the query (there are various options to perform such joins) and use that SSIS package directly in reporting services as data source."

Thanks,

jen

Data regions

Greetings,

Can someone explain the rationale as to why nested data regions are restricted to use the same dataset?

Craig

We didn't have time so far to implement hierarchical data source support in our processing engine - but it is under consideration for a future release.

Anyway, there are a few options available today to achieve similar results:
* join the datasets already in the query (e.g. by using linked server functionality)
* use subreports for the "nested data region" - but this is usually not very efficient
* use SQL Server 2005 Integration Services to join the datasets in the query (there are various options to perform such joins) and use that SSIS package directly in reporting services as data source.

-- Robert

|||

hey Robert,

can you point me toward some documentation on how to do this:

"use SQL Server 2005 Integration Services to join the datasets in the query (there are various options to perform such joins) and use that SSIS package directly in reporting services as data source."

Thanks,

jen

Data Migration using SSIS in SQL 2005

Greetings,

I am using SQL Server 2005 and I want a clue if there is some good built-in support to do the following.

I want to transfer all the data from one source database to another destination database having same number to tables and schema like source database. I also want to ensure that the old data on the destination database should be secure too.

I have an idea that this can be done through SSIS in coding but can anyone give me a guide, tip, link, sample code that can be helpful.

Thanx a million in advance.

Regards

Try the link below for code samples from DTS/SSIS expert. Hope this helps.

http://www.sqlis.com/