ssis data source

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

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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

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



asked: Nov 04, 2011 at 07:45 PM

Seen: 681 times

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