question

BI new avatar image
BI new asked

ssis data source

Does a packgage must have data source and data source view? I have seen a package only have connections manager. Thanks
ssis
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.