Lab Sql

I want to create a flat file output, where format of rows is different. file has header, middle da… Read more Ssis : Creating A Flat File With Different Row Formats

I am using BIML and BIDSHelper to create SSIS package. I am trying to import data from csv to sql s… Read more Create Table Before The Dataflow In Biml

How could I add multiple file extensions to the Files: input field in the Foreach loop container in… Read more How To Add Multiple File Extensions To The Files: Input Field In The Foreach Loop Container Ssis

I am using a C# Script Tasks in SSIS to output ASCII characters. I am doing this because I am creat… Read more C# Script Using Streamwriter Creates Extra Character?

I am trying to do a query that allow for multiple columns in a view. Any assistance would be helpfu… Read more Multiple Select Case Statements In Query For Shoretel Reports

Not too familiar with dtsx packages - can they be created/run outisde Visual Studio? Is BIDS (Busin… Read more Can I Run/test/create Dtsx Packages Outside Visual Studio?

I have business intelligence development studio v 9.0 installed and am trying to create some sample… Read more No Shared Datasets In Solution Explorer Of Business Intelligence Development Studio

I have installed Microsoft SQL Server 2005. This consists of the configuration tools (SQL server co… Read more Installation Of Sql Server Business Intelligence Development Studio