CODEWITHSUNDEEP
sqlssissql-server-2012ssis-2012
choloboy
choloboy

Reputation: 815

Creating SSIS package in SQL Server from Query

I am new to SQL Server came across SSIS packages. I would like to begin creating a package from a Query but do not know where to start (in terms of starting the package). Can it be built in SSMS or do I need to use other tools such as Data Tools. I have done some research online and many sources refer to BIDS but I don't not think I have that application.

Any tips would be appreciated, Thanks.

Upvotes: 0

Views: 213

Answers (1)

AHiggins
AHiggins

Reputation: 7219

This depends to some degree on what version of SQL Server you have - after SQL 2012, the SSIS development has been moved to a program called SSDT (SQL Server Data Tools), but prior to that it was BIDS (Business Intelligence Development Studio).

A link like this one could help you get the program installed - it assumes you have access to the install disks or program for SQL Server.

As for actually developing the package, there are plenty of tutorials out there to get you started - just Google "SSIS Tutorial" and add the year of your version, and you should find something good. MSDN has one for each version of SQL Server.

Upvotes: 1

Related Questions