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

Business Intelligence Development Studio download Expand / Collapse
Author
Message
Posted Tuesday, March 2, 2010 10:10 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:34 PM
Points: 751, Visits: 1,560
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.



Post #875339
Posted Tuesday, March 2, 2010 1:18 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #875492
Posted Tuesday, March 2, 2010 1:46 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:34 PM
Points: 751, Visits: 1,560
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?



Post #875514
Posted Tuesday, March 2, 2010 11:59 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
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)




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #875700
Posted Wednesday, March 3, 2010 5:36 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:34 PM
Points: 751, Visits: 1,560
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:?



Post #875859
Posted Wednesday, March 3, 2010 5:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 8:15 AM
Points: 13,017, Visits: 10,800
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




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #875872
Posted Wednesday, March 3, 2010 5:59 AM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Yesterday @ 12:34 PM
Points: 751, Visits: 1,560
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.



Post #875879
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse