Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS and VS

Author  Topic 

Yak Posting Veteran

59 Posts

Posted - 2015-04-04 : 13:52:01

I am new to SSIS planning on learning it using Visual Studio. Is the procedure creating SSIS package in SQL server and VS same? if I learn SSIS using VS then I can easily develop the same in sql server? please let me know

Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-05 : 13:34:50
Not sure what you mean.

There are three ways to create SSIS packages:

1. in SSMS, using Import/Export Wizard
2. Using the standalone Import and Export Data utility.
3. in Sql Server Data Tools, which is in Visual Studio.

The procedures for 1-2 and 3 are completely different. However, all three produce Integration Services packages that can run in SQL Server.

6-Apr-2015: Edited to include standalone Import/Export utility.
Go to Top of Page

- Advertisement -