May 15, 2007 at 11:01 am
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/aLohia/2999.asp
Amit Lohia
June 18, 2007 at 6:56 am
Superb article. Many thanks.
June 18, 2007 at 9:31 am
Great article, very easy to follow.
June 18, 2007 at 11:37 pm
Wonderful article. Lots of useful stuff that is all too often overlooked.
June 19, 2007 at 5:47 am
Was expecting a section called "Creating a simple package"
June 19, 2007 at 8:52 pm
great article.
but the job scheduling is i guess very much different from what we have right now.
June 20, 2007 at 10:50 am
Please posted your method of job scheduling. I may learn something new.
Amit Lohia
June 21, 2007 at 12:21 pm
I have to agree with Andrew. I saved this article for reading when I had time to learn something about SSIS. I currently know jack, and I still don't. Where is the "creating a simple package" part? Can anyone recommend an "SSIS for Dummies" type article out there with step by step instructions on creating an initial simple package? Thanks.
July 23, 2007 at 10:18 am
I agree with the preceding posters: it's a very helpful article. It helped me unlock parts of SSIS I had no idea were there.
However the article could be a lot easier to follow if some of the shorthand was expanded to include more context, so as to be understandable for those who are not familiar with SSIS and the SQLServer 2005 tools.
For example, under "Accessing SSIS via SQL Server Management Studio (SSMS)", it says "We can connect to SSIS Service for various reasons via SSMS. To connect to SSIS we have to mention the server name without the instance of SQL Server." But it doesn't say that you need to go to "Connect / Integration Services" in order to connect. That took me a while to figure out.
Another example is where it says "Let's add a new data source. Right Click Data Source -> New Data Source -> Complete the Wizard (Use SQL server Authentication)" I cannot find where to right-click. The section title talks about a command-prompt utility, but it doesn't sound like it has a GUI, so the right-click must not be referring to that. (If we were supposed to right-click there, I imagine the article would tell us how to launch dtexec.) I'm looking at the SSIS package name in SSMS under Integration services server / Stored Packages / MSDB, but there's no "Data Source" to right-click on.
Similarly, below where it says "SSIS -> Variables", I would love to know where to find this. But I can't figure it out.
Again, this article looks to have a great deal of useful introductory information about SSIS to help a new user get off the ground. If the above points could be clarified to provide more thorough context "for dummies", it would be a lot more useful to people like me.
Thanks,
Lars
July 23, 2007 at 12:55 pm
P.S. I have now discovered, via other articles, that some of the things I was wondering about in the above post are found in Visual Studio (i.e. BIDS), after creating or opening an Integration Services project. It would be good to mention that in the article.
July 23, 2007 at 1:01 pm
Lars,
It is very difficult to write an article to address all level of reader.
Amit
Amit Lohia
March 27, 2008 at 11:00 am
It certainly is. But after these several neophytes have brought attention to areas where more info is needed, your efforts to incorporate those would be greatly appreciated. After expanding your article to address those matters, you should have something that ought to be published in a print-magazine or in the bulletin of a professional org. And that should be listed on your resume.
In other words, it will become a significant contribution to everyone's knowledge of a complex, new product.
August 12, 2008 at 10:16 am
Lars - I know where you're coming from, it could be a little better explained in parts for an SSIS newbie. If you open the solution explorer you'll see Datasources, right-click there to add....
One thing I'm not seeing after creating my datasource is, in the properties window, anything for expression. I only see Location and Object Model properties. Anyone else had similar problems with it?
July 22, 2009 at 3:08 pm
The links to the images appear to be broken. Can they be updated?
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply