What to do with finished pkgs created in BIS?? 2

[sqlsadie108]

Hi,

I have been in the process of creating some new pkgs in BIS. My question is, once I am done writing the pkgs, what next?

That is, how do I get the pkgs into SQL Server, and how do I schedule them to run?

Also, what if I have the following scenario:

I have created a new SSIS pkg that has several EXECUTE DTS 2000 tasks in them. The DTS packages that are called from the EXECUTE DTS 2000 task are stored in the database under "Legacy". These should still run OK once I "load" the packages to SQL Server 2005, yes?

Where do the SSIS packages "live" in SQL Server 2005? That is, where can I view them.

Thank you!!

 

[dhulbert]

Reply

You can schedule the packages to run in the SQL server agent Jobs.

The schedule can call a package that is stored eithe rin the file system ot one that held in the SSIS package store

Connect to your Integration services server from management studio, browse to stored packages, MSDB then right click and select import package, follow the prompts and away you go.


i've not tried to run ond DTS packages through SSIS but ti should work, best way to find out is to try it.


I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[MDXer]

To get you SSIS packages onto the the server you need to Build the proje. This will create the packages and manifest in the directory yo have configured. You can then move these files to the server and execute the manifest, which will install the packages. Depending on what deployment mode you select File or Server will determine what steps need to be taken or locations specified for your scheduling.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[sqlsadie108]

Is there any advantage to storing the pkgs as files or on the server? That is, why would one choose one over the other?

I suppose if the pkgs are on the server, you can back them up easily when you back up the msdb db, which would be one small advantage.

But are there arguments for either or?

 

[sqlsadie108]

Hi,

I realize I am confused. Posted are seemingly 2 different methods for putting the pkgs on SQL Server.

Which one should I do?