92 How to import only specific columns from excel using SSIS

[@redwite9661]

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

[@learnssis]

The fix is not always same, I think it depends from version to version of excel. Try this method kzbin.info/www/bejne/n2XddmyvhZeaqKM if not works then try this one kzbin.info/www/bejne/o6jMZoOXit1npsk

[@franciso4650]

can you execute queries within an excel sheet?

[@learnssis]

Yes, we can execute the queries but as far as I am aware the syntax is a bit different. In this example I executed the select query and in below video I created the excel sheet using a sql query kzbin.info/www/bejne/hIG8qYKmiJKegsk

[@Shra1Chin2]

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.

[@learnssis]

You can try implementing Error handling in Data flow task so that if a row fails to insert then it can be moved to an staging table. Take a look at this video kzbin.info/www/bejne/gHe3gHlnitCheK8

[@learner_SSIS]

Very useful sir for my projects

[@learnssis]

Okay glad to know that.

[@kichuchinnu3303]

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

[@kichuchinnu3303]

Please suggest some of your video,

[@learnssis]

@@kichuchinnu3303 On the OLE DB Destination make sure you have selected Table or View Fast Load option. And make sure that there are no indexes on the table when you are loading data to it.

[@kichuchinnu3303]

@@learnssis yes. It's working thank you so much

[@learnssis]

@@kichuchinnu3303 No problem.

[@Shra1Chin2]

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?

[@learnssis]

I think we won't be able to load data for all 100 large data files as every file will need some memory and of course the memory will be limited on the machine, thus you can may be start testing like loading 5 files at a time and then next 5 files and so on. You can create an SSIS package and then you can execute the SSIS package using sql agent job.

[@Shra1Chin2]

While loading the data if suddenly we have some issue as some of the data got loaded then what will we do for whole tha data will get loaded?

[@learnssis]

@@Shra1Chin2 You should write data handling mechanism in SSIS so that suppose out of 10 Million records if there is some issue in may be 100 records then those 100 records can be moved to an staging table and rest of the data will be loaded to the destination table. kzbin.info/www/bejne/gHe3gHlnitCheK8

[@SyedSohail-i4o]

Can you do with CSV/FLAT FILE?

[@learnssis]

Yeah in the flat file source, if you go to mapping then you can uncheck the columns those you do not want to be inserted to destination table.

[@sohailsyed5243]

@@learnssis I tried it is not working. Will you try and pls do more me

[@TKJ]

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.

[@learnssis]

Take a look at this video where I talked about performance tuning of SSIS packages and creating indexes on sql queries. May be in future I can create a separate video on Indexing. kzbin.info/www/bejne/baSudpqjZ9qEe68

[@sureshareti2843]

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!!

[@learnssis]

Please take a look at this video kzbin.info/www/bejne/kHaam5-NqtamrLc