September 8, 2006 at 9:52 am
I knew where to find DTS, but after having recently installed SQL2005 and SSIS (the installer says I successfully installed it) I can't find it. Hmmm. Is there a menu option called SSIS? Is it inside BI (Biz Intelligence)?; can't be...it takes me to VS2005. Can I do something as simple as take an Excel worksheet and suck it into a SQL table like I used to? All the doc does is talk about its programmability with C#. It would be nice to have a tutorial that shows you how to do a simple DTS task within SSIS, if that's possible.
Thx.
September 8, 2006 at 10:00 am
SSIS is a little more detatched in my opinion than DTS was, being its own service now. You can connect to the SSIS instance via Management Studio by changing the "Server type" drop down in the connect to server dialog. From there you can view the packages you have stored.
To build packages you'll want to use the stripped down version of Visual Studio that SQL Server installs and create a new Integration Services Project.
September 10, 2006 at 10:58 am
You should be able to start SQL Server Business Intelligence Development Studio and then from pmenu select File->New->Project. There you should see Business Intelligence Projects under Project Types and under Visual Studio Installed Templates, one of them should be Integration Services Project.
Good luck!
September 11, 2006 at 8:37 am
September 11, 2006 at 3:20 pm
Here's a link to SQL Server Integration Services (How Do I) on MSDN:
http://msdn2.microsoft.com/en-us/library/ms166351.aspx
There are some tutorials and other intro documentation to get you started.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply