question

nitish1300 avatar image
nitish1300 asked

What actually happens in the background while a SSIS package is being created?

Hi all, Hope everyone is doing good. Hey, can any one explain what actually happens in the background of SQL SERVER while a SSIS Package is being created. what does SQL SERVER actually do to create a package? Help would be appreciated. Thank you guys in advance.
ssissql-server-2012msbi
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
erlokeshsharma08 avatar image
erlokeshsharma08 answered
SSIS and SQL are different services. When a package is created you could either save it to sql server (package store or ssisdb) or a file system. The creation of ssis package is handled by ssis engine.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.