|
I have an SSIS package that I've saved under Maintenance Plans on SQL Server 2005. Though I can select SSIS packages, I am not sure how I can delete them.
Started by Sheehan Alam on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
How do I....
From there you should, rename them etc.
It sounds like you are trying to delete the package from Database Engine --> Management --> for the package you want to delete under Running Packages or Stored Packages.
|
|
How do I schedule SSIS to automatically execute a package from a file at a given time every day?
Started by BlueEyes on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
For ....
When you create your package step, for Type choose SQL Server Integration Services Package .
(Only possible on the SSIS server) Check also execution with dtexec
Server Agent Job.
Your ssis package with dtexec.
|
|
Hi,
I'm calling a SSIS package using LoadPackage(...).
Is it possible to make this call an Asynchronous call?
Started by Blankman on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
However #2 (as long = Future.Create(()=>LoadPackage....
For #1 I can't give a definitive answer because I don't use the SSIS framework.
; // Wait for package load to complete and get the value
I'm calling an SSIS package from my UI.
|
Ask your Facebook Friends
|
Hi When I set permissions on an SSIS package (ProtectionLevel) & I enter a PackagePassword, then when I open the package on my computer, it does not prompt me for a password.
Am I doing something wrong?
Answer Snippets (Read the full thread at stackoverflow):
I also hear it's a best practice...)
If you want to limit access to your SSIS package, use security:
If you set the ....
Here's some things I've learned about SSIS package admins...
You are probably not doing anything wrong.
|
|
Hello everybody,
can anyone help me and tell me how can I run a SSIS package from vb6?
Started by elghoul_girl on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Dtexec /f c:\mypackage.dtsx", vbNormalFocus) End Sub
Dim dtsApp As Application Dim package As IDTSPackage90 Set dtsApp = New Application Set package = dtsApp.LoadPackage("c:\MyPackage.dtsx", True.
|
|
We have SSIS package config files that contain DB encryption passwords or PGP encryption passwords. I came to the conclusion that there is no "silver bullet" solution for encrypting SSIS package config files like with web.config files ect.
Should we consider...
Started by Dieter G on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
You can use.
Encryption of configuration files are not handled by SSIS itself.
This, but theoretically it might work.
|
|
What are the tools available for DTS to SSIS package conversion as part of the SQL servr upgrade and which ones do you recommend?.
Started by kishore on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
EDIT: Downvotes!!?!?? Jeez/MigrationWizardSteps.html....
Rewrite the packages in SSIS as and when you get a chance.
Requires some manual migration; runtime DTS DLLs available in SSIS; package re-architecture as a learning aid.
|
|
Hi If I want to Develop SSIS Package from scratch what techniques/needs to be fallow in related to design,development,testing and deployment.
Started by rmdussa on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
And, if you can....
IMO, SSIS is a software development discipline, just like C# or any other development tool here: http://www.accelebrate.com/sql_training/ssis_tutorial.htm
Learn also the pros and cons of using and transaction support.
|
|
In SQLServer 2005, is it possible to schedule an SSIS package to run something other than the AQL Agent Service Account?
I've got an SSIS package that makes a connection to a db and runs a stored procedure. My criteria is that I will not specify user ...
Started by Jeremy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx or http://msdn.microsoft.com/en-us/library/ms403355.aspx
might help
If you want to execute the SSIS package.
|
|
I have a SSIS package, which depending on a boolean variable, should either go to a Script Task or an Email task.(Note: the paths are coming from a Script Task)
I recall in the old dts designer there was a way to do this via code. What is the proper way...
Started by D Scott on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Then just tie the outputs (default and new) to the Script and Email tasks... .
Add the Conditional Split task, add in an additional output (a default output is provided), and set up the Condition for that output .
A Conditional Split task does what you want.
|
