Please start any new threads on our new site at https://forums.sqlteam.com. 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 

madhan
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

gbritton
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 -