billinkc

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <PackageProjects>
        <PackageProject Name="ProjectParameterTest" ProtectionLevel="DontSaveSensitive">
            <Parameters>
                <!-- I think this is the project parameter-->
                <Parameter DataType="String" Name="FolderBase">C:\ssisdata</Parameter>
            </Parameters>
            <Packages>
                <Package IsEntryPoint="true" PackageName="POC"/>
            </Packages>

billinkc

DECLARE 
    @schema sysname = 'DW'
,   @tableName sysname = 'DimDate'

DECLARE
    @Header nvarchar(max) = N'INSERT INTO ' + QUOTENAME(@schema) + '.' + QUOTENAME(@tableName)
,   @Body nvarchar(max) = N'';


WITH SRC AS

billinkc

-- Create a Database Master Key
IF NOT EXISTS
(
    SELECT
        SK.*
    FROM
        sys.symmetric_keys AS SK
    WHERE
        SK.symmetric_key_id = 101
)

billinkc

<Biml xmlns="http://schemas.varigence.com/biml.xsd">

  <Packages>
    <Package Name="EventAndLog"
            ConstraintMode="Linear">
      <Events>
        <Event Name="ControlFlowOnError"
               EventType="OnError"
               ConstraintMode="Linear"
               >

billinkc

CREATE TABLE dbo.SessionEval
(
    [SessionCode] varchar(10) NOT NULL 
,   [Title] varchar(80) NOT NULL
,   [Speakers] varchar(250)
,   [AvgRating] numeric(3,2) NOT NULL
,   [Responses] smallint NOT NULL
,   [Attendance] smallint NOT NULL
);

billinkc

//-----------------------------------------------------------------------
// <copyright file="Driver.cs" company="billfellows.net">
//     I mention copyright so StyleCop is happy.
// </copyright>
//-----------------------------------------------------------------------
namespace SOCode
{
    using System;
    using System.Collections.Generic;
    using System.Linq;

billinkc

-- http://msdn.microsoft.com/en-us/library/ff877994.aspx
-- Find all error messages
SELECT
    OM.operation_message_id
,   OM.operation_id
,   OM.message_time
,   OM.message_type
,   OM.message_source_type
,   OM.message
,   OM.extended_info_id

billinkc

USE tempdb

-- Map of sql server builds
-- http://sqlserverbuilds.blogspot.com/
SELECT 
    SERVERPROPERTY('productversion') AS ProductVersion
,   SERVERPROPERTY ('productlevel') AS ProductLevel
,   SERVERPROPERTY ('edition') AS Edition
,   DOWI.windows_release
,   DOWI.windows_service_pack_level

billinkc

SET NOCOUNT ON;

CREATE TABLE ##Zane
(
    db_nm sysname
,   obj_nm	nvarchar(128)
,   object_id	int
,   definition	nvarchar(max)
,   uses_ansi_nulls	bit
,   uses_quoted_identifier	bit

billinkc

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
    <Connections>
        <OleDbConnection Name="CM_OLE" ConnectionString="Data Source=localhost\dev2012;Initial Catalog=tempdb;Provider=SQLNCLI10.1;Integrated Security=SSPI;"></OleDbConnection>

        <FlatFileConnection
    Name="FF Source"
    FileFormat="FFF Source"
    FilePath="C:\SSISData\swasheck.csv"
    CreateInProject="false"
		/>