Lab Sql

What I need to do is export data into CSV file using T-SQL. And I'm very confused about there a… Read more I Need Best Practice In T-sql Export Data To Csv (with Header)

I'm trying to Partition a Table by both Year and Month. The Column through which I'll parti… Read more How To Partition A Table By Month ("both" Year & Month) And Create Monthly Partitions Automatically?

I am running an SSIS Package that contains a C# Script which formats an Excel File on Windows Serve… Read more Microsoft Excel Cannot Access The File On Windows Server 2012

This similar question gave the solution that in order to check the status of a job in C# you must r… Read more Checking A Sql Job Status In C# Using Sp_help_job

I have created an SSIS package that reads a csv file from a network shared drive and imports the da… Read more Ssis Job Fails - Access Denied To Flat File

I have been trying to find sample code with using SQL Server 2005, I need to start an Agent Job and… Read more Need To Start Agent Job And Wait Until Completes And Get Success Or Failure

I have created SSIS package which is running successfully and dumping the data to the required plac… Read more The Job Failed. The Job Was Invoked By User. The Last Step To Run Was Step1