92 How to import only specific columns from excel using SSIS

preview_player
Показать описание
How to import only specific columns from excel using SSIS

Download the file\script used in the Video from below link

How to import only specific columns from excel using SSIS
SSIS selective columns import from Excel
How do I extract data from Excel using SSIS?
How do I truncate and import Excel files in SSIS?

Happy Learning.

Рекомендации по теме
Комментарии
Автор

Bhaiyya... How to read only column header and build sql query select col1, col2...from table name and based on select query data generate excel file
Please create video on this bhaiyya
Thanks in advance!!

sureshareti
Автор

in this method, how to avoiding NULL values in excel containing mixed data types ?

redwite
Автор

Can you make video on sql server indexing?
because my project has 50 cr data. In SQL server even count(*) takes 5 min to load. I want to make fast performance in SSMS. So, I want to do indexing. Can you please make a video on it.

TKJ
Автор

Hii I have sending 1million record from excel to sql using ssis but it take 10mins to send data from flate file source to ole db destination. Is that any or possibility for reduce the time for source to destination
Please help me to solve this

kichuchinnu
Автор

Hello brother...
Can we load the 100 large data files with the help of sql server agent at a time.
Is it possible to load when we have the same database as a source for all the data files?
What is the best scenario for this?
And how to overcome the issues while we loading the data at a time?

ShraChin
Автор

While running the SSIS package suddenly it got stopped as some of the rows got loaded then how can we load the remaining rows? What can we do in this situation?
Pls give me the solution brother.

ShraChin
Автор

can you execute queries within an excel sheet?

franciso
visit shbcf.ru