HI Expert, I am trying to create a SSIS package to go through a folder and export all the .xls files into SQL. The problem I'm having is that I'm not to sure which property of the Excel Connection Manager must be changed and how exactly it is done. I know it would be something to do with variables and then in the Excel Connection Manager expressions you change a property during Execution time
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…
In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…