Feeds:
Posts
Comments

Posts Tagged ‘SSIS’

SQL SERVER – List of Article on Expressor Data Integration Platform

Posted in PostADay, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on June 22, 2011 | 1 Comment »

The ability to transform data into meaningful and actionable information is the most important information in current business world. In this fast growing and changing business needs effective data integration is single most important thing in making proper decision making. I have been following expressor software since November 2010, when I met expressor team in [...]

Read Full Post »

SQL SERVER – Import CSV File into Database Table Using SSIS

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on May 12, 2011 | 58 Comments »

It is very frequent request to upload CSV file to database or Import CSV file into database. I have previously written article how one can do this using T-SQL over here SQL SERVER – Import CSV File Into SQL Server Using Bulk Insert – Load Comma Delimited File Into SQL Server. One of the request which [...]

Read Full Post »

SQL SERVER – Introduction to Adaptive ETL Tool – How adaptive is your ETL?

Posted in Business Intelligence, Pinal Dave, PostADay, SQL, SQL Authority, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged , on February 17, 2011 | 2 Comments »

I am often reminded by the fact that BI/data warehousing infrastructure is very brittle and not very adaptive to change. There are lots of basic use cases where data needs to be frequently loaded into SQL Server or another database. What I have found is that as long as the sources and targets stay the same, [...]

Read Full Post »

SQL SERVER – Automated Type Conversion using Expressor Studio

Posted in Database, Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, SQLAuthority News, T SQL, Technology, tagged on November 30, 2010 | 6 Comments »

Recently I had an interesting situation during my consultation project. Let me share to you how I solved the problem using Expressor Studio. Consider a situation in which you need to read a field, such as customer_identifier, from a text file and pass that field into a database table. In the source file’s metadata structure, [...]

Read Full Post »

SQLAuthority News – Interesting Whitepaper – We Loaded 1TB in 30 Minutes with SSIS, and So Can You

Posted in Business Intelligence, SQL, SQL Authority, SQL Performance, SQL Query, SQL Server, SQL Tips and Tricks, SQL White Papers, SQLAuthority News, T SQL, Technology, tagged on March 14, 2010 | 2 Comments »

We Loaded 1TB in 30 Minutes with SSIS, and So Can You SQL Server Technical Article Writers: Len Wyatt, Tim Shea, David Powell Published: March 2009 In February 2008, Microsoft announced a record-breaking data load using Microsoft SQL Server Integration Services (SSIS): 1 TB of data in less than 30 minutes. That data load, using [...]

Read Full Post »

Older Posts »