Lab Sql

SSIS script task reading only numeric values of excel but fails to read the alphanumeric values pre… Read more Failing To Read String Value From An Excel Column

The situation: I have a list of queries written so that each select data from their respective tab… Read more Meta Data Refresh While Looping Through Tables In Ssis

I have made the following PowerShell script: Set-Location D:\folder1\folder2\folder3\folder4; Get-C… Read more Powershell Returns Negative Exit Code While Script Results Are Correct

Is it possible to format a column in an excel destination in ssis before generating it? I'm thi… Read more Format Excel Destination Column In Ssis Script Task

I have an SSIS package, zip.dtsx. This package successfully runs on serverA. I copied this package … Read more Ssis Package Fails On File.delete Of Script Task

SSIS script task reading only numeric values of excel but fails to read the alphanumeric values pre… Read more Failing To Read String Value From An Excel Column