x

ssis data source

Does a packgage must have data source and data source view? I have seen a package only have connections manager.

Thanks
more ▼

asked Nov 04, 2011 at 07:45 PM in Default

BI new gravatar image

BI new
66 5 6 7

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Data Source and Data Source Views are not used by SSIS Packages.

However you can create Data Sources and Data Source Views on the SSIS Project Level. Then those objects simplifies development of multiply packages. As you can create a Connection Managers in a Package from a Data Source in the project and once you have such connection manager in place and also have a data source defined, then Sources/Destinations and other objects in SSIS package can benefit from this. Like eg. OLE DB Source can use a named query from the defined Data Source. In this case when you edit the named query in the Data Source, the query will be automatically updated in all SSIS packages referencing it. (but only when you open the package in design mode - I mean connections and other objects in SSIS packages are updated from the project level Data Sources and Data Source Views only after opening in designer, one by one).

If you want more info, don't hesitate to ask.
more ▼

answered Nov 06, 2011 at 11:01 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x946

asked: Nov 04, 2011 at 07:45 PM

Seen: 694 times

Last Updated: Nov 04, 2011 at 07:45 PM