Hello everyone. I have a really beginner question: I've been told to conect to a SSIS DEV environment and a BD DEV server and I've been provided with the necessary data (domains, user, pw as well as TNS connection) but I'm not exactly sure how can I do this. any welp would be extremely appreciated! !

Hi Perhaps you can give us a bit more information about where you are stuck. I don't get enough information from your original post to give you any help. If you are saying that you don't know how to get started, I suggest you read some beginner's tutorials. You can search for "ssis beginner tutorial" on Google or Bing. Here is a site that seems to have some good links:http://consultingblogs.emc.com/jamiethomson/archive/2007/01/30/SSIS_3A00_-Online-Beginner-Resources.aspx Craig Bryden - Please mark correct answers

Thank you for the link you posted. I will give a really deep look into it. Nevertheless I'm going to try to explain me a little bit better, I'm supposed to look into some dimensions and for that I'm supposed to conect to the SSIS environment and to the DB server. I've the domains/adresses , user, pw but I'm not sure how can I, in BIDS, connect to a SSIS env with the data I've been provided.

Hi, Your requirement is still tricky. I assume that you have to connect to some data source and fetch the data to some target. These are the steps to do so Create a package Drop data flow task and go to Data flow layout Add Data flow source and configure the connect to the server using your domains/address. user name, password. now add, Data flow destination task Connect the source task to destination, I mean the green line should be connected to destination task Now, map the fields save the package and run for testing Thanks Ayyappan Thangaraj UG Lead, Puducherry, http://SQLServerRider.blogspot.com

When you say "dimensions", are you referring to SQL Server Analysis Services?Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt) MCT, MCPD, MCITP, MCDBA, MCSD, MCAD

Thank you all one more time. What I mean is that I have somehow to conect to a project in order to take a look into somethings that are being done in the project. One of the things that is making me confused is that the domain / adress they gave me to conect to the SSIS environment and to the BD server is something like this: SSIS environment : VKDABC01 - 10.166.172.45 ( for example ) BD server : VABCDEF11,1523 - 10.166.199.32 I'm not totally sure what should I do with this

Hi A7289, 1) SSIS environment can be hosted on any client environment which in your case it is given as this server : VKDABC01 - 10.166.172.45 . You could do a remote login into the server and get started with the BIDS(Business Intelligence developemnt Studio). 2) BD Server here I think is your database server where your source / destination data resides. You can connect to this server VABCDEF11,1523 - 10.166.199.32 from BIDS in the SSIS environemnt server. Clear or any deviation?Happy to help! Thanks. Regards and good Wishes, Deepak.

Thanks a lot! I'm guessing that is what I should do. In order to proceed to the remote login to access to the SSIS environment I should I proceed ? Windows remote login or VPN ?? and regarting the "VKDABC01 - 10.166.172.45" is this the hole name of the server or should I use just part of it ??

You could use either the Server Name or the IP address to remote login to that server and check it out to see whats in there. It doesn't matter whether you use a VPN tunnel or a Windows remote login for as long as you can get in there using the UserID and password privided to you. Generally, when we talk about a SSIS environment, it means a physical server (or machine if you call it that) which has the SSIS "software" installed on it. That "software" turns the physical machine into a server that can "hold" SSIS "objects" (just like you'd have Oracle software or Ab-Initio software installed on a machine to turn it into a respective "server"). In SQL Server world, those "Objects" are called "SSIS Packages" which have the workflow that moves data around, performs manipulations and transformations on the data and does other stuff. I believe the first server provided to you is exactly that. However, instead of assuming anything, I'd suggest to go back and ask for more details about what exactly is installed/stored on those two servers, how to connect to each of them and what exactly are they used for. I;d also suggest you sitting with one of the developers in teh team who have worked with these servers (if that be the case) and watch him do what you are supposed to do. There is no harm in asking if the intention is to get it right rather than messing something up and cutting a sorry figure later :) Once you have all these details, you can come back to this forum/thread and ask for specific help. Hope this helps! Cheers!! Muqadder.

create a new ssis package and then add a connection manager consume the connection in the dataflow http://msdn.microsoft.com/en-us/library/ms140237.aspxhttp://joeydj.com

create a new ssis package and then add a connection manager consume the connection in the dataflow http://msdn.microsoft.com/en-us/library/ms140237.aspxhttp://joeydj.com