Thanks a lot for sharing this tutorial!! I keep having issues because the Excel Source task couldn't read files with multiple names but now the issue has been fixed!! Again thanks a lot!!!
When I run this with the start button, it just hangs / does nothing. When I execute just the container, it displays the first file, and then the DFT does nothing (if I use a data viewer, it does not read the excel file). Any guesses what needs to change?
It's a good point. For those reading this comment you may run into an issue with the nvarchar datatype regarding unicode. In the past I usually CAST the field as a varchar.
@@databasetales3562 Hey I really liked you video, is there one where you do the exact same as this video but you also use a dynamic naming convention of the files and incorporate that in your variable. like 112024_CCC for November and 122024_CCC for December but that they are all in the same folder. SO the variable will automatically change to the correct MonthYear and look for that specific string within the name of the file. I can give examples if what I said was too convoluted.
I got this working in VS, but when deploy it I get an error about the ACE OLEDB 12 driver not being installed. Does anyone know what would cause this to throw an error in SQLServer but not VS?
The server may need the Office objects installed.. (NOT Full Office App) just the objects to create the Office files. Google "Microsoft Access Database Engine Redistributable "
Create a Job in SQL Server Agent. When creating Steps of the Job, go to Settings of the Step. There must be an checkbox with option to execute the job in 32-bit runtime. Put a check on it. It will execute the 32-bit SSIS package with the right 32-bit driver.
Finally a very well explained process on loops; I used it for Ms Access files and worked too
Thanks a lot for sharing this tutorial!! I keep having issues because the Excel Source task couldn't read files with multiple names but now the issue has been fixed!! Again thanks a lot!!!
Thank you so much, after spending lots of hours , I found your video and solved multiple excel data transfer problem :)
Great video. Very clear, step by step and easy to understand. It helps me a lot. Thanks!
you are fantastic man
Thank you, it helped a lot my friend
Thank you, gracias!!! me estaba volviendo loca!
Great Tuto! Thank you
Nice...
When I run this with the start button, it just hangs / does nothing. When I execute just the container, it displays the first file, and then the DFT does nothing (if I use a data viewer, it does not read the excel file). Any guesses what needs to change?
What would you do if the worksheet structure is the same but the sheetname is different in each excel file? it always matches the file name
@javierrodriguez3624 hey man, I have the same problem, sheet name changes with each file. I am wondering if you found a solution to this?
Great video! Thank you! I am surprised you didn't have to do datatype conversion from excel Unicode datatype to non-Unicode datatype!
It's a good point. For those reading this comment you may run into an issue with the nvarchar datatype regarding unicode. In the past I usually CAST the field as a varchar.
@@databasetales3562 Hey I really liked you video, is there one where you do the exact same as this video but you also use a dynamic naming convention of the files and incorporate that in your variable. like 112024_CCC for November and 122024_CCC for December but that they are all in the same folder. SO the variable will automatically change to the correct MonthYear and look for that specific string within the name of the file. I can give examples if what I said was too convoluted.
How can I make my SISS project automatically run , sir ?
Look into setting up an SSIS Catalog to publish your package to. The package can be hosted there and then scheduled via SQL job.
I got this working in VS, but when deploy it I get an error about the ACE OLEDB 12 driver not being installed. Does anyone know what would cause this to throw an error in SQLServer but not VS?
The server may need the Office objects installed.. (NOT Full Office App) just the objects to create the Office files.
Google "Microsoft Access Database Engine Redistributable "
Create a Job in SQL Server Agent. When creating Steps of the Job, go to Settings of the Step. There must be an checkbox with option to execute the job in 32-bit runtime. Put a check on it. It will execute the 32-bit SSIS package with the right 32-bit driver.