Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Overview of SSIS Expand / Collapse
Author
Message
Posted Tuesday, May 15, 2007 11:01 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, January 22, 2011 12:01 PM
Points: 702, Visits: 174
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/aLohia/2999.asp


Kindest Regards,

Amit Lohia
Post #366078
Posted Monday, June 18, 2007 6:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, April 18, 2014 8:11 AM
Points: 78, Visits: 718
Superb article.  Many thanks.


Post #374611
Posted Monday, June 18, 2007 9:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 28, 2013 10:36 AM
Points: 1, Visits: 20
Great article, very easy to follow.


Post #374667
Posted Monday, June 18, 2007 11:37 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, April 10, 2014 2:19 PM
Points: 26, Visits: 144
Wonderful article. Lots of useful stuff that is all too often overlooked.
Post #374839
Posted Tuesday, June 19, 2007 5:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 19, 2007 6:59 AM
Points: 1, Visits: 1
Was expecting a section called "Creating a simple package"
Post #374895
Posted Tuesday, June 19, 2007 8:52 PM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 11, 2012 7:59 AM
Points: 21, Visits: 74

great article.

but the job scheduling is i guess very much different from what we have right now.



Jwalant Natvarlal Soneji
BE IT, India
http://JwalantSoneji.com

Post #375142
Posted Wednesday, June 20, 2007 10:50 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Saturday, January 22, 2011 12:01 PM
Points: 702, Visits: 174

Please posted your method of job scheduling. I may learn something new.

 




Kindest Regards,

Amit Lohia
Post #375364
Posted Thursday, June 21, 2007 12:21 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, November 13, 2008 9:13 AM
Points: 499, Visits: 76
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.
Post #375694
Posted Monday, July 23, 2007 10:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 09, 2010 2:37 PM
Points: 7, Visits: 26
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
Post #384239
Posted Monday, July 23, 2007 12:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 09, 2010 2:37 PM
Points: 7, Visits: 26
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.
Post #384307
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse