Jayvee questions

Jayvee answers

• Import Excel (.xlsx) with SSIS and Excel source with worksheet containing multiple subsections
• Selecting columns as XML with namespace
• SQL Server Decimal precision
• SQL select items that make datetime range between flag toggle
• Coverting unicode string to non unicode string in SSIS 2012
• How Stuff Works Or Logic of Stuff & XML Path in SQL
• Component OLE DB source has no input
• SQL Query to select records for rows having value =0 in one column and unique id in another column [closed]
• Concatenating Firstname and lastname as Name and then ommit Firtname and LastName in SSIS
• SQL Server Conversion Failure when using INSERT