That is true. However I (for whatever reason) never used 'ActiveX script task' but the plain 'Script task' with underlying C# code.

I haven't used SSIS for a while but I remember similar behaviour from elder versions (SQL...

If you want to save the INSERT script in the same location where the spreadsheet is located and name the file like the active sheet:

Dim FieldName As...

The following covers for a lot:

DECLARE @tstString VARCHAR(255)

SET @tstString = '20080528 '

SELECT

CASE

WHEN LEN(LTRIM(RTRIM(@tstString))) >= 6 AND LEN(LTRIM(RTRIM(@tstString)))...

Thanks Jack,

Seems to confirm what my colleagues and I found out.

I do believe however that it would be a nice add-on to Report properties in a future version/SP. I find...

Initialize your variable with a dummy SELECT statement at design time. The result should reflect the output structure (data types and column names) of your final query result.

Ex.: SELECT CAST(1...