March 2, 2010 at 10:10 am
This may sound like a stupid question.. but I have several MS SQL Server 2005 Standard Edition installs and have never used SSIS.
Do I have to download and install Business Intelligence Development Studio for SQL Server 2005 in order to use SSIS?
If so, can someone point me in the right direction? I cannot find the download in the microsoft site.
March 2, 2010 at 1:18 pm
Business Intelligence Development Studio, aka BIDS, is actually plain old Visual Studio. When you start Visual Studio for the first time, you can choose a 'role'. For example, .NET developer, project manager or BI developer. Visual Studio then adapts its user interface to make it easier for that role to use it.
In short, download Visual Studio (or Visual Studio Express for free) if you want to develop SSIS packages.
You don't need BIDS to run packages in SQL Server and you can always create simple packages with the data import wizard in Management Studio, but for more complex packages, you need BIDS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 2, 2010 at 1:46 pm
Thank you for your reply!!!
I will download Visual Studio ...
I do have a related question thought. I DID create an SSI package via the import\emport wizard.. but how do I look at or run the package I created in Management Studio?
I was able to create a new 'job' under SQL Server Agent\Jobsew job and call the SSIS package that I created that way.. but is that the only way to look at or run the package from management Studio?
March 2, 2010 at 11:59 pm
In Management Studio, you can connect to Integration Services.
(choose Connect and then click Integration Services...)
There you will see two folders:
Running packages and Stored packages. We will look at the last one, which has also 2 folders:
File System and MSDB. The first one is well... for packages stored in the file system 🙂
The second one is for packages stored on SQL Server itself.
You can view and run packages from there.
When you have BIDS, you can also create a package that runs other packages (a so called master package). There you need the Execute Package Task.
A final option is to go to the fysical location where you've stored the package with explorer and then double-click the package. This will launch the tool dtexecui that will execute your package.
(actually, you can also launch packages from the command line, but that would take us too far)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2010 at 5:36 am
yeah.. I'll have to play around with command line.. but not now : )
question. now that I'm connected to SSIS (duh!!! i should have known that)
I created two packages yesterday via the import\export wizard that I do not see ?
I even searched my file system (real shot in the dark because I saved then in SQL Server not to the file system)
any ideas:?
March 3, 2010 at 5:55 am
Try checking the folder sysssispackages. If they are not there and they are not somewhere else in the MSDB folder, well, then I don't have a clue 🙂
More information about managing packages:
http://msdn.microsoft.com/en-us/library/ms137916.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 3, 2010 at 5:59 am
I actually was able to import the packages under SSIS, Stored Procedures, MSDB, Maintenance plan then right click and import!!
Thank you so much for your help and guidance.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply