Day 3. Overview of Importing Data with the SSIS Wizard

The speaker discussed possible strategies for using the SSIS Wizard in SQL Server Management Studio for over an hour. They provided a superficial overview of the available data sources for importing data and the role of ODBC drivers in the process.


 

Комментарии

Отправить комментарий

Популярные сообщения из этого блога

Today's activity report #17

Изображение
Today I re-cleaned the primary data for the second round of the survey. Reduced the number of pseudo-unique names and patronymics. Converted respondents' dates of birth from text to date and verified their correctness. Found about 80 errors (for example, people born in 2023 and 2064). In the part of names, when entering, the Latin letter 'i' was used instead of the Ukrainian one. In addition, I found 9 cases of missing names or patronymics (surname or first name written twice) Time spent: 4h
Далее...