InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 23:55:43 GMT20http://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxAndy,Both tables are in SQL Server 2005.. different servers. However I did find a way to fix the problem...In SSIS I went to Tools > Database Tools > Table and Database Designers > Column OptionsIn the drop down "Default column type" change to "varchar".That fixed SSIS's conversion of the data to nvarchar.However if I ever have to go from a nvarchar to varchar.. I guess one of the ways you listed is the way to go.Oh, I have made it down to Level 5... Very good article and easy to follow.Mon, 11 Feb 2013 14:33:13 GMTdwilliscphttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi dwilliscp, When data is read from some flat file sources, SSIS treats it as unicode data. The data flow will not implicitly convert unicode to non-unicode data types, so you need to perform this conversion yourself. One way is to use the Data Conversion tranformation. Another way is to use a Derived Column transformation. In both cases, a new column is added to the data flow task's pipeline with the desired data type (you cannot change the data type of a column using either of these tasks). If you use the Derived Column transformation, you need to perform a type cast operation on the unicode column to create a new non-unicode column. If your input column is named MyCol, the type cast will read something like (DT_STR, 255, 1252)[MyCol]. DT_STR is the type cast that yields an SSIS data type compatible with the SQL Server varchar data type. The 255 is the length of the string, and 1252 represents the US-EN code page.Hope this helps,AndyMon, 11 Feb 2013 09:49:56 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxThanks for the lovely article... this is my first effort at SSIS. I am trying to do the same steps, in this second article, but on our databases. I am getting a data error.Error 1 Validation error. Data Flow Task: Data Flow Task: Column "MRP_Area_CD" cannot convert between unicode and non-unicode string data types. Package.dtsx 0 0 Both source and destination tables have the same data type, so I guess this is something that SSIS is doing, how do I fix it?From the alter table code...[MRP_Area_CD] [varchar](10) NOT NULL,Fri, 08 Feb 2013 12:15:05 GMTdwilliscphttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxAlright! I have successfully made it through your tutorial and have learned much! Thank you for your initial handholding, I think I can actually build something in SSIS now! :)As promised, here are my notes: (As well as C# equivalents to your VB.NET examples)Here's the list of corrections/suggestions I said I'd provide from my notes of running through your tutorial. In order to refer to specific pieces of your tutorial, I went with the step number followed by the figure the suggestion/correction appears nearest (Usually right below that figure).[b]Step 2, Fig 36[/b]: Using the copy of the database you supplied, the dbo.Contact table already exists. Need to delete that table in SSMS in order to complete this step.[b]Step 4, Fig 33[/b]: The double-quotes around Humperdinck have been converted to Word-style double quotes (The kind that point in towards the text they are surrounding). Convert these in the editor to use HTML escape sequence &dquo; to avoid this. [code="plain"]Ex: &dquo;Humperdinck&dquo;[/code][b]Step 5, Fig 2[/b]: Wording is a bit rough for describing the addition of new Data Flow "Delete Rows". Initially thought I was supposed to add a new "Execute SQL Task".[b]Step 8, Fig 13[/b]: Succeed Script Task 1 dialog doesn't appear. Perhaps I missed something?[b]Step 8, Fig 29[/b]: Says to disable "Sequence Container 1 - the original one", but "Sequence Container" is the original.Also converted your example script code from VB.NET to C#, will come in handy for those that work primarily in C# like me.Step 6, Figure 13: C# Version:[code="plain"]public void Main(){ string sTaskName = Dts.Variables["TaskName"].Value.ToString(); MessageBox.Show(sTaskName + " completed."); Dts.TaskResult = (int)ScriptResults.Success;}[/code]Step 7, (On Completion (Failure) [No Listing # on code example]):[code="plain"]public void Main(){ var sTaskName = Dts.Variables["TaskName"].Value.ToString(); var iResponse = MessageBox.Show("Succeed " + sTaskName + "?", sTaskName + " Success Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (iResponse == DialogResult.Yes) { Dts.TaskResult = (int)ScriptResults.Success; } else { Dts.TaskResult = (int)ScriptResults.Failure; }}[/code]Step 8, Listing 1: C# Version:[code="plain"]public void Main(){ var taskName = Dts.Variables["TaskName"].Value.ToString(); var response = MessageBox.Show("Set MyBool to True?", taskName, MessageBoxButtons.YesNo); if (response == DialogResult.Yes) { Dts.Variables["User::MyBool"].Value = true; } else { Dts.Variables["User::MyBool"].Value = false; } Dts.TaskResult = (int)ScriptResults.Success;}[/code]Step 8, Listing 2: C# Version:[code="plain"]public void Main(){ var sTaskName = Dts.Variables["TaskName"].Value.ToString(); var iResponse = MessageBox.Show("Succeed " + sTaskName + "?", sTaskName + " Success Question", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (iResponse == DialogResult.Yes) { Dts.TaskResult = (int)ScriptResults.Success; } else { Dts.TaskResult = (int)ScriptResults.Failure; }}[/code]Step 9, Listing 1: C# version:[code="plain"]public void Main(){ int iErrorCode = Convert.ToInt32(Dts.Variables["ErrorCode"].Value); string sErrorDescription = Dts.Variables["ErrorDescription"].Value.ToString(); string sSourceName = Dts.Variables["SourceName"].Value.ToString(); string sSubComponent = "Script Task 4 OnError Event Handler"; string sMsg = String.Format("Source: {0}ErrorCode: {1}Error Description: {2}", sSourceName, iErrorCode, sErrorDescription); MessageBox.Show(sMsg, sSubComponent); Dts.TaskResult = (int)ScriptResults.Success;}[/code]Mon, 22 Oct 2012 14:22:03 GMTben.kimballhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]Andy Leonard (10/18/2012)[/b][hr][quote][b]joresnik (10/16/2012)[/b][quote]Figure 13The server name can be typed into or selected from the Server Name dropdown. Once the server name is configured, SSIS actually connects to the server and retrieves a list of databases. You can enter or select the database in the “Select or enter a database name” dropdown. In this case, I connected to the (local) instance of SQL Server and selected the AdventureWorks database.[/quote]I think you skipped something here. What if a person new to this does not have a local instance of SQL server created? Will they know how to do this?[/quote]Hi Joresnik, While I understand your point, I disagree. This series is focused on learning to develop data integration solutions with SSIS. Hope this helps,Andy[/quote]I do see your point, but you do also cover the basics of BIDS, so describing how to create a local instance doesn't seem like it would be beyond the scope of the tutorial. The fact is, I am one of the people who did not know how to create a local instance, and I had to take a break from your tutorial and find another tutorial that described this.Perhaps a solution would be to provide a link to a tutorial that covers it?Mon, 22 Oct 2012 12:15:09 GMTjoresnikhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi Everyone, I corrected the typo and added a link to the first step (Level 1) of this series. I also updated Level 1 to that it walks you through creating the initial SSIS project. I accept full responsibility for any confusion and I apologize. I hope many will enjoy this series and learn more about SSIS by reading it and building the solution. Thanks to everyone who provided feedback - please continue.:{>Fri, 19 Oct 2012 20:24:23 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxYou are very correct on my trying to do it using SSMS instead of SSIS. I had just learned that you can view an existing SSIS package through SSMS by using "Connect to... Analysis Services", but it doesn't seem you can create one that way, so I made things worse by running down the wrong path at first. :/I am currently going through your tutorial and making progress (Up to Step 4 now! :) ) and taking notes that I will post here when I'm through the whole thing.One tiny gotcha I ran into using the database backup you supplied: The backup seems to be in the state of "after going through the tutorial" - found that dbo.Contact was already there which threw me for a couple minutes when the tutorial tried to create that table. No big deal once I figured that out, deleted dbo.Contact and was able to keep going.Thank you in advance for a tutorial focusing purely on SSIS, all the rest out there seem to introduce SSIS at the same time as cubing/mining (Also new to me) which is too much to process at one time.Fri, 19 Oct 2012 10:27:40 GMTben.kimballhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]ben.kimball (10/16/2012)[/b][hr]OK, I am fully confused. I created a "First_SSIS_Project" project, and now have an empty solution that looks like:First_SSIS_Project - Connections - Queries - MiscellaneousNow what do I do?[/quote]Hi Ben, I believe you created a new project in SQL Server Management Studio and not in SQL Server Business Intelligence Development Studio. My first article in the series did not do a good job of explaining how to create a new SSIS solution. I have edited the first article and hope the updates will be published soon.[quote]Sorry, remember, I am completely inexperienced with SSIS, so even absolute beginner steps are needed with such things.[/quote] Ben, you are my target audience. [i]You[/i] have no reason to apologize. [i]I apologize[/i] for not writing an article clear-enough for you to know exactly how to create the desired project type.AndyThu, 18 Oct 2012 20:14:04 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]joresnik (10/16/2012)[/b][quote]Figure 13The server name can be typed into or selected from the Server Name dropdown. Once the server name is configured, SSIS actually connects to the server and retrieves a list of databases. You can enter or select the database in the “Select or enter a database name” dropdown. In this case, I connected to the (local) instance of SQL Server and selected the AdventureWorks database.[/quote]I think you skipped something here. What if a person new to this does not have a local instance of SQL server created? Will they know how to do this?[/quote]Hi Joresnik, While I understand your point, I disagree. This series is focused on learning to develop data integration solutions with SSIS. [quote]Also, unless I'm misunderstanding something, Persons.Contact seems to be a pre-made table, and I don't see you referencing it anywhere until it's being used. When I follow the steps of the tutorial, that table is not associated with my project.[/quote] A backup of the AdventureWorks database I use may be found [url=http://andyleonard.me/files/AdventureWorks_backup.zip]here[/url].Hope this helps,AndyThu, 18 Oct 2012 19:50:02 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]ben.kimball (10/16/2012)[/b][hr]Oops, just noticed a previous reply about the same thing. However, in the link in your reply, it just takes me to Step One of the SSIS Stairway. I still can't make the connection between what you say in Step Two and its reference to Step One. What exactly was supposed to have been done in Step One to be ready for Step Two. Nothing looks like an "Action Item" in Step One.[/quote]Hi Ben, When we started this series, I started writing the first three articles together. I wrote a few different versions of Step 1 which were renamed and which had different content. I updated the content of Steps 2 and 3 to adjust, but I obviously missed some of the changes n content and the name change for Step 1 in at least one place in Step 2. I apologize for any confusion this has caused.AndyThu, 18 Oct 2012 19:37:12 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxThank you so much! :)Thu, 18 Oct 2012 09:55:05 GMTben.kimballhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]ben.kimball (10/16/2012)[/b][hr]What version of AdventureWorks are you using? This example fails with AdventureWorks for SQL Server R2.Person.Contact doesn't exist anymore, it's been broken into separate tables for EmailAddress, etc.[/quote]Hi Ben, A backup of the AdventureWorks database I use may be found [url=http://andyleonard.me/files/AdventureWorks_backup.zip]here[/url].Hope this helps,AndyThu, 18 Oct 2012 06:48:57 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxWhat version of AdventureWorks are you using? This example fails with AdventureWorks for SQL Server R2.Person.Contact doesn't exist anymore, it's been broken into separate tables for EmailAddress, etc.Tue, 16 Oct 2012 14:58:39 GMTben.kimballhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxOK, I am fully confused. I created a "First_SSIS_Project" project, and now have an empty solution that looks like:First_SSIS_Project - Connections - Queries - MiscellaneousNow what do I do? Your next words are "From the Control Flow toolbox, drag a Data Flow Task onto the Control Flow canvas." but no words on how to open the Control Flow canvas or how to create Package.dtsx.Sorry, remember, I am completely inexperienced with SSIS, so even absolute beginner steps are needed with such things.Thanks again!Tue, 16 Oct 2012 13:57:42 GMTben.kimballhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxOops, just noticed a previous reply about the same thing. However, in the link in your reply, it just takes me to Step One of the SSIS Stairway. I still can't make the connection between what you say in Step Two and its reference to Step One. What exactly was supposed to have been done in Step One to be ready for Step Two. Nothing looks like an "Action Item" in Step One.Or in other words, what are you expecting to be already in place before starting to create My_First_SSIS_Project.PS: Luckily I already knew, but it seems you could improve this by pointing out how to connect to SQL in "Integration Services" mode rather than the normal "Database Connection" mode, that could throw a few people.Thanks!Tue, 16 Oct 2012 13:49:36 GMTben.kimballhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHello, could you tell me what you are referring to (under "Play Along at home") by "Open (or create) the SSIS project named My_First_SSIS_Project from SSIS Quickstart: Business Intelligence Development Studio and Your First SSIS Project."?Not sure what/where SSIS Quickstart: Business Intelligence Development Studio and Your First SSIS Project might be. Could you turn that into a hyperlink pointing to whatever you're talking about?Thanks!Tue, 16 Oct 2012 13:38:21 GMTben.kimballhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxA couple things I think need clarification:Figure 12[quote]Click the New button here to define a new data connection using the Connection Manager Editor. Earlier I wrote the connection managers handle things like database engine instance and database name. This is where we configure those items:[/quote]I believe you mean to say "Earlier I wrote [i]that[/i] the connection....." Amazing how missing one word can make a sentence confusing.[quote]Figure 13The server name can be typed into or selected from the Server Name dropdown. Once the server name is configured, SSIS actually connects to the server and retrieves a list of databases. You can enter or select the database in the “Select or enter a database name” dropdown. In this case, I connected to the (local) instance of SQL Server and selected the AdventureWorks database.[/quote]I think you skipped something here. What if a person new to this does not have a local instance of SQL server created? Will they know how to do this?Also, unless I'm misunderstanding something, Persons.Contact seems to be a pre-made table, and I don't see you referencing it anywhere until it's being used. When I follow the steps of the tutorial, that table is not associated with my project.Tue, 16 Oct 2012 12:15:04 GMTjoresnikhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxCool, thanks. Great articles though :-) Sat, 13 Oct 2012 04:26:59 GMTrussgriffhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]russgriff (10/12/2012)[/b][hr]Hi, thanks for these articles.When you say: "Open (or create) the SSIS project named My_First_SSIS_Project from SSIS Quickstart: Business Intelligence Development Studio and Your First SSIS Project.", are you implying that we've already downloaded/installed some samples? If so, where from?Many thanks.[/quote]Hi Russ, You found a typo. I wrote a couple versions of [url=http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/72492/]the first article in this series[/url]. An earlier (unpublished) version was titled "SSIS Quickstart: Business Intelligence Development Studio and Your First SSIS Project." Please create the SSIS solution where you read that instruction.Thank you (and apologies),AndyFri, 12 Oct 2012 12:06:07 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi, thanks for these articles.When you say: "Open (or create) the SSIS project named My_First_SSIS_Project from SSIS Quickstart: Business Intelligence Development Studio and Your First SSIS Project.", are you implying that we've already downloaded/installed some samples? If so, where from?Many thanks.Fri, 12 Oct 2012 07:33:00 GMTrussgriffhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]macrocharlie (9/12/2012)[/b][hr]Did I miss something or is there another article on BIDS? I use BIDS almost daily for SSRS but have never used it for Integration Services.[/quote]Hi MacroCharlie, You did not miss anything, but I sure did. You found a typo. Actually, a missed edit. When we started this series, I started writing the first three articles together. I wrote a couple / three versions of "Part 1" and one of them was entitled "BIDS". I later re-wrote and renamed the first article, but didn't catch this edit. It's an error and I apologize for it.:{>Wed, 12 Sep 2012 13:36:35 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxI guess I am getting into this game a little late but just started the articles since they were in the latest daily newsletter. Just read the Part 1 and just about to start Part 2 when I noticed one of the first lines said "In our last installment (Part 1 – BIDS) you learned your way around Business Intelligence Development Studio and you are now itching to build an SSIS package that moves real data!". Did I miss something or is there another article on BIDS? I use BIDS almost daily for SSRS but have never used it for Integration Services.Wed, 12 Sep 2012 05:36:10 GMTmacrocharliehttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi Andy,Thanks for getting back to me. I am really excited to do your lessons!CornéFri, 25 May 2012 01:14:29 GMTclerouxhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi Corné, In this series, we are using Microsoft SQL Server 2008 R2 Business Intelligence Development Studio. In the very first article in the series, I cover where to find this application. If you do not have SQL Server 2008 R2 client workstation tools installed, you cannot perform the examples provided in this series.Hope this helps,AndyThu, 24 May 2012 13:13:20 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]cleroux (5/24/2012)[/b][hr]I have googled and googled, and googled some more ..., but cannot find what I am looking for....Corné[/quote]What are you looking for?Thu, 24 May 2012 11:05:25 GMTjohnbrown105 56149http://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi Andy, Thanks for the informative articles!One quick question: what software application do you use? I have googled and googled, and googled some more. I am using SQL Server Management Studio 2008 R2 and I have Visual Studio 2010 Pro., but cannot find what I am looking for....Thanks!CornéThu, 24 May 2012 06:09:43 GMTclerouxhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi Andy, Thanks for the informative articles!One quick question: what software application do you use? I have googled and googled, and googled some more. I am using SQL Server Management Studio 2008 R2 and I have Visual Studio 2010 Pro., but cannot find what I am looking for....Thanks!CornéThu, 24 May 2012 06:08:04 GMTclerouxhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxThe OLE DB Source allows you to write a SELECT statement to only pull the columns you desire. I recommend always writing such a statement.Hope this helps,AndyTue, 10 Jan 2012 19:13:09 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi Andy,This was a very nice article with a very specific details. But I have got a very important question to ask and is been there for a quite a long time and am unable to resolve.on Oledb source adapter through column pane, you select the required columns at design time. Hence SSIS knows which column we are interested in at design time only, but when you run the package at look at the profiler, the oledb source adapter always runs select * from table query. so1) why it fires such query eventhough aware of selected columns at design time.2) how do I create custom component to achieve this( Say I would want to work with table or view acccess mode).Tue, 10 Jan 2012 10:48:15 GMTparekhpiyush22-1075662http://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]Samuel Vella (11/25/2011)[/b][hr][quote][b]Thomas LeBlanc (11/9/2011)[/b][hr]Andy,You meniton that connections are stored in your profile. Where is the profile?[/quote]Hi ThomasA quick dig round my registry uncovered this:HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\Packages\{4a0c6509-bf90-43da-abee-0aba3a8527f1}\Settings\Data\ConnectionsWhich contained a list of all the previously used connections which are displayed in the Data Connections dialogue boxThe information about each connection i.e. server, DB, user etc... appears to be encrypted or at least obfuscated so I'm not sure what value you could derive from this.[/quote]Confirmed. Thank you Samuel!:{>Sun, 27 Nov 2011 11:22:44 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspx[quote][b]Thomas LeBlanc (11/9/2011)[/b][hr]Andy,You meniton that connections are stored in your profile. Where is the profile?[/quote]Hi ThomasA quick dig round my registry uncovered this:HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\Packages\{4a0c6509-bf90-43da-abee-0aba3a8527f1}\Settings\Data\ConnectionsWhich contained a list of all the previously used connections which are displayed in the Data Connections dialogue boxThe information about each connection i.e. server, DB, user etc... appears to be encrypted or at least obfuscated so I'm not sure what value you could derive from this.Fri, 25 Nov 2011 03:36:51 GMTSamuel Vellahttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi Thomas, I honestly don't know where the connections metadata is specifically stored, and I cannot recall who told me it was stored in the Users' profile. :\Wed, 09 Nov 2011 08:22:47 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxAndy,You meniton that connections are stored in your profile. Where is the profile?"As you develop SSIS packages on a server, you create connections. [b]The connections you create are stored in your profile and will appear in the Data Connections list [/b]in the Configure OLE DB Connection Manager list. If this is the first SSIS package you’ve built, your Data Connections list will be empty"Thanks,ThomasWed, 09 Nov 2011 07:25:38 GMTThomas LeBlanchttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi Andy,Thanks for making it crystal clear to me.Tue, 08 Nov 2011 05:19:34 GMTrrn 62873http://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxHi rrn 62873, Thank you for your kind words. You will find some outdated SSIS advice that recommends using the SQL Server Destination instead of the OLE DB Destination. When that advice was originally offered, it was sound (somewhat). Since SQL Server 2005 SP2 (or so), OLE DB functionality has been improved. You get roughly the same performance loading SQL Server from either Destination. OLE DB is more stable (meaning it doesn't crash as much as the SQL Server Destination - especially under load) and is portable (to use the SQL Server Destination you muct execute the SSIS package on the same physical server as the Destination database). those are my reasons for recommending the OLE DB Destination over the SQL Server Destination.Hope this helps,AndyFri, 04 Nov 2011 14:51:27 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxAndy, thanks for taking the time and effort to write something like this. It is a very interesting read for me, who are just coming into the BI-world.As a side note, why do you recommend using the OLE DB Destination over SQL Server Destination in the Data Flow Task? Are there any main differences between the two (when working with MS SQL Server 2008R2)?Fri, 04 Nov 2011 01:10:54 GMTrrn 62873http://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxThanks Everyone! Half the credit (minimum) goes to The Best Editor On The Planet: Steve Jones. :{>Sat, 08 Oct 2011 09:17:00 GMTAndy Leonardhttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxFine and professional article, thanks! It has been well written and easy to follow. A great resource for starting out with SSIS.Sat, 08 Oct 2011 03:11:49 GMTEric Hielkenshttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxAn Excellent article Andy. I am a beginner of SSIS and this article makes me everything so clear and easy. I am really waiting forward for next articles.Sat, 06 Aug 2011 20:26:35 GMTh.parajulihttp://www.sqlservercentral.com/Forums/Topic1063686-208-1.aspxAnother great article Andy!I found it very nice that you gave some attention to the layout of the package, as unfortunately, messy control and data flows do appear in books or blog posts. :-)Sun, 10 Apr 2011 23:56:18 GMTKoen Verbeeck