We’ll look at each of these in greater detail as we progress through this series. SSIS Designer is broken into four tabs: Control Flow, Data Flow, Event Handlers, and Package Explorer. SSIS Designer : The main working area for developing your SSIS package.Properties : The properties and their values for the package or the selected component within that package.Solution Explorer : A hierarchical view of the data sources, data source views, packages, and other components included within the current solution.Your data sources can include SQL Server databases, CSV files, Excel spreadsheets, and a variety of other sources. Connection Managers : The connections to your data sources (whether retrieving or loading data).(The components will be explained in more detail in this article and in articles that will follow.) For example, the section includes components that let you move or copy data, run SQL statements, or send emails.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |