SQLServerCentral / Discuss Content Posted by Andy Leonard / Article Discussions / Article Discussions by Author

The SSIS Data Pump - Step 2 of the Stairway to Integration Services

Andy Leonard — Mon, 14 Feb 2011 10:37:08 GMT

Comments posted to this topic are about the item [B]The SSIS Data Pump - Step 2 of the Stairway to Integration Services[/B]

Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services Services

Andy Leonard — Wed, 12 Oct 2011 00:05:53 GMT

Comments posted to this topic are about the item [B]Updating Rows in Incremental Loads – Level 4 of the Stairway to Integration Services Services[/B]

Anatomy of an Incremental Load

Andy Leonard — Thu, 24 Jan 2008 20:16:18 GMT

Comments posted to this topic are about the item [B]Anatomy of an Incremental Load[/B]

What is SSIS? Step 1 of the Stairway to Integration Services

Andy Leonard — Mon, 14 Feb 2011 10:37:06 GMT

Comments posted to this topic are about the item [B]What is SSIS? Step 1 of the Stairway to Integration Services [/B]

SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers

Andy Leonard — Wed, 20 Aug 2008 23:01:55 GMT

Comments posted to this topic are about the item [B]SSIS 101: Object Variables, ResultSets, and Foreach Loop Containers[/B]

Deleting Rows in Incremental Loads – Level 5 of the Stairway to Integration Services

Andy Leonard — Thu, 03 Nov 2011 22:49:06 GMT

Comments posted to this topic are about the item [B]Deleting Rows in Incremental Loads – Level 5 of the Stairway to Integration Services[/B]

Level 3 of the Stairway to Integration Services - Adding Rows in Incremental Loads

Andy Leonard — Sat, 20 Aug 2011 20:29:03 GMT

Comments posted to this topic are about the item [B]Level 3 of the Stairway to Integration Services - Adding Rows in Incremental Loads[/B]

An Example of Test-Driven Development, Part 5

Andy Leonard — Thu, 20 Aug 2009 00:08:59 GMT

Comments posted to this topic are about the item [B]An Example of Test-Driven Development, Part 5[/B]

Data Warehouse Development: Version 0

Andy Leonard — Thu, 07 Apr 2011 00:01:45 GMT

Comments posted to this topic are about the item [B]Data Warehouse Development: Version 0[/B]

SSIS Properties

Andy Leonard — Tue, 01 Feb 2011 20:45:07 GMT

Comments posted to this topic are about the item [B]SSIS Properties[/B]

The Execute SQL Task

Andy Leonard — Tue, 04 Jan 2011 23:12:11 GMT

Comments posted to this topic are about the item [B]The Execute SQL Task[/B]

An Example of Test-Driven Development, Part 4

Andy Leonard — Wed, 15 Jul 2009 00:21:32 GMT

Comments posted to this topic are about the item [B]An Example of Test-Driven Development, Part 4[/B]

An Example of Test-Driven Development, Part 3

Andy Leonard — Sun, 12 Jul 2009 10:50:24 GMT

Comments posted to this topic are about the item [B]An Example of Test-Driven Development, Part 3[/B]

Testing for objects

Fatherjack — Fri, 26 Nov 2010 03:35:36 GMT

What are the pro's / con's of using "If Not Exists(Select Name .." over "If Object_ID('object') >) ..." syntax?

SSIS Execute Package Task

Andy Leonard — Thu, 18 Nov 2010 20:54:11 GMT

Comments posted to this topic are about the item [B]SSIS Execute Package Task[/B]

does SSMS 2008 has project in File-> New?

Christine Sun — Fri, 05 Nov 2010 20:05:41 GMT

I could not move pass the first step in the article. I have SSMS 2008 Express. When I went to File->New, all I had was Query with Current Connection, Database Engine Query, SQL Server Compact Query, and Policy.I could not find 'Project'. Where did I miss?

An Example of Test-Driven Development

Andy Leonard — Thu, 30 Apr 2009 00:25:28 GMT

Comments posted to this topic are about the item [B]An Example of Test-Driven Development[/B]

An Example of Test-Driven Development, Part 2

Andy Leonard — Mon, 15 Jun 2009 23:57:01 GMT

Comments posted to this topic are about the item [B]An Example of Test-Driven Development, Part 2[/B]

SSIS Package Execution

Andy Leonard — Sat, 18 Sep 2010 18:26:29 GMT

Comments posted to this topic are about the item [B]SSIS Package Execution[/B]

SSIS Scripting

Andy Leonard — Mon, 06 Sep 2010 22:56:01 GMT

Comments posted to this topic are about the item [B]SSIS Scripting[/B]

SSIS Control Flow

Andy Leonard — Sat, 11 Sep 2010 12:17:11 GMT

Comments posted to this topic are about the item [B]SSIS Control Flow[/B]

Integration Services Sources

Andy Leonard — Sat, 28 Aug 2010 11:40:03 GMT

Comments posted to this topic are about the item [B]Integration Services Sources[/B]

Control Flow Tasks

Andy Leonard — Tue, 24 Aug 2010 20:34:03 GMT

Comments posted to this topic are about the item [B]Control Flow Tasks[/B]

SSIS Precedence

Andy Leonard — Wed, 18 Aug 2010 23:26:14 GMT

Comments posted to this topic are about the item [B]SSIS Precedence[/B]

is reading an Object Variable in SSIS destructive?

rajesh.gowda — Tue, 03 Aug 2010 08:16:00 GMT

Hello ALl,I have One source SourceTable(COLName1, COLName2)I have 2 destination tables DestinationTable1(COLName1, COLName2),DestinationTable2(COLName1, COLName2)My Design,1. I will query the SourceTable and keep all the data in an Object Variable.2. I have to use the Oject variable to sync the data in both of my destination Tables.[b]3. Here I have succeeded in synchronizing the data to one table but failed to sync both the tables.[/b]4. I have used script component and OleDbDataAdapter in Dataflow task.5. [b]The data in the Object Variable is Blank when my logic tries to read it for the second time.[/b]6. My Question - Is reading datasets from an Object variable 'Destructive'? cant we use the data in the [u]Object variable [/u]multiple times?Please let me know your thoughts.Regards, Raj

Initializing a Object variable in SSIS

rajesh.gowda — Thu, 22 Jul 2010 02:17:54 GMT

I have a variable EmployeFirstName defined as Object in SSIS. Can I make it configurable? if YES, then whats the syntax that I need to follow to pass the values likeName1, Name2 .....or Name1:Name2:it would be a greate help if some one can throw some light on it.Regards, Raj

Scripting in SSIS – Part 1

Andy Leonard — Tue, 29 Dec 2009 01:09:13 GMT

Comments posted to this topic are about the item [B]Scripting in SSIS – Part 1[/B]

1 million plus records

Andrea Bannister — Fri, 14 Aug 2009 01:58:29 GMT

This should have been added to the [b]Anatomy of an Incremental Load[/b] topic.As is always the case, you never deal with just a 100 thousand records, in reality it's more like over a million. So I would like to know what do you think about using drop table followed by select into, finally rebuild the indexes/views which is a technique I used in a package where I loaded many tables with 4-10 million records. At the same time the source table schema was different to the destination table's schema, just to make life interesting. :-)Thanks for your comments.

Output to text concatenating the results

Hemal Modi — Fri, 24 Jul 2009 03:06:42 GMT

Hi Andy,Interesting read! One this I would like to inform you that when pushing the results to text through your AutoGen scripts the generated scripts were getting truncated to 256 chars. For those ignorant of this limitation including me :) this can be rectified by going to Tools --> options --> Query Results --> SQL Server --> Results to text and setting "Maximum number of characters displayed in each column" to something higher like 1000.I hope my 2 cents worth would help someone.Keep up the good work.Cheers,Hemal

How to use an SSIS user variable in a SQL statement

Jim Covington — Mon, 30 Mar 2009 15:38:31 GMT

I am using SQL 2005 and am in SSIS.I have a SQL Dataflow task that has a SQL statement as follows:Select TRACCT,TRATYP,TRDATE,TRDAT6,AMT,SERIAL, TRANCD,DORC ,ATMCODFrom DATMCC.DDHist Where TRDATE > @ORDER BY TRACCT, TRATYP,TRDATE DESC,amt descI also have a package scoped variable user::JulianDate with a date in it.I want to use the value in User::Juliandate1 where the @ sign is in the SQl above.How is this done?Thanks

SSIS 101: Isolating Data in a Data Flow

Andy Leonard — Wed, 11 Feb 2009 00:16:36 GMT

Comments posted to this topic are about the item [B]SSIS 101: Isolating Data in a Data Flow[/B]

HOWTO: Create an Asynchronous Schedule For a Report Server Report

Andy Leonard — Tue, 18 Jan 2005 13:10:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/ALeonard/howtocreateanasynchronousscheduleforareportserverr.asp

Snapshot Reports

havezeroclue — Mon, 21 Jan 2008 09:22:25 GMT

If the reports are created in the snap shot history, how to access those reports which are already created and are in the history. Please let me know.