PACKAGE START / PACKAGEEND In SSIS

May 31, 2007

This is a repeat listing - third time - of this problem.

Here's the deal:
If I turn on logging on an SSIS package in Development Studio, when the package executes it will log all the events I choose to the sysdtslog90 table in the MSDB database - INCLUDING the PACKAGESTART and PACKAGEEND events.

When I create my own custom logging, however, those two events ARE NOT being logged, even though I explicitly state in my script I want those two logged. Everything else in the script (OnWarning, OnPreExecute, OnPostExecute, etc.) is being logged.

In my reading, it states that the PACKAGESTART and PACKAGEEND events are defaults and are always logged and cannot be excluded.

If this is the case, can someone explain why they aren't getting logged?

I've seen other people have run across the same issue...

View 8 Replies


ADVERTISEMENT

Start To Run A SSIS Package

Dec 6, 2006

I have a SSIS package which copies data from Excel file to the database.
As soon as the file is copied to a specific location on the file system I insert an entry in the database table, which should kick off the above mentioned SSIS package.

I tried to read on WMI Event Watcher Task to do the above thing. I am not sure that I can do something like that.

Can anybody please help me out on this?

View 4 Replies View Related

Start SSIS Package

Sep 24, 2007

I have a Stored Procedure preparing data, which then are exported (flat files) using 2 SSIS packages. What is the best way to execute those 2 SSIS packages (sp,job, other) ?

Every advise is appreciated!

View 5 Replies View Related

RUN NET START/STOP MSSQLSERVER FROM SSIS PACKAGE

Mar 27, 2007

HELLO,

I want to create a package which start and stop the SQL server's services... i know i can achive this via NET COMMAND.... but i coudnt find in which task (SSIS) I can place that command?..

I also came across that I can achieve this using Execute Process task but for this I have to define executable file.... actually i dont want ne thing outside from my SSIS package

CAN I ACHIEVE THIS WITH IN SSIS PACKAGE?

is there ne other alternative?



regards,

Anas

View 9 Replies View Related

Easiest Way To Start And Read A Trace From Within A SSIS Package

Jun 19, 2006

I'm trying to gather information from within a SSIS package for benchmarking, reconciliation, and reporting purposes in regards to cube processing, which I'm initiating using the AS processing task.

What is the easiest way to capture this information?

The only way I've been able to come up with is to use a profiler trace. If this is really the only way, what is the easiest way to execute and read the trace from within SSIS?

Also, if a script task has to be used, does anyone have a code sample?

Thanks in advance!

View 3 Replies View Related

OK So How Do You Start An SSIS Package With A ForEach And A WMI File Watch Task?

Mar 21, 2007

Can't an SSIS package run "in the background", so to speak, without having either the cmd.exe or dtexecui windows open while executing? I'd obviously rather not have to have a window open when the thing is running right?

View 2 Replies View Related

PACKAGESTART And PACKAGEEND Not Logging

May 24, 2007

I have a DTS package that performs some custom logging of othe rchild SSIS
packages. Everything is being logged as it should be, except for the
PACAKGESTART and PACKAGEEND events.

The pacakage executes a series of child packages, but even the main - or
parent - package doesn't log the PACKAGESTART and PACKAGEEND events.

I've attached the script for review:

Public Class ScriptMain

' The execution engine calls this method when the task executes.
' To access the object model, use the Dts object. Connections, variables,
events,
' and logging features are available as static members of the Dts class.
' Before returning from this method, set the value of Dts.TaskResult to
indicate success or failure.
'
' To open Code and Text Editor Help, press F1.
' To open Object Browser, press Ctrl+Alt+J.

Public Sub Main()
'
' Add your code here
'
Dim strPathPkg As String
Dim pkgChild As New Package
Dim app As New Application
Dim execCtrl As Executable ' An Executable is a Work Flow control in
DTS


' Load package
strPathPkg = Dts.Variables("PackageFolder").Value.ToString +
Dts.Variables("ChildPkgName").Value.ToString
app.PackagePassword =
Dts.Variables("PackagePassword").Value.ToString()

pkgChild = app.LoadPackage(strPathPkg, Nothing)
pkgChild.FailParentOnFailure = True
pkgChild.MaximumErrorCount = 1

' Set vairables
If Dts.Variables("parmInt1Name").Value.ToString <> "" Then

pkgChild.Variables(Dts.Variables("parmInt1Name").Value.ToString).Value =
Dts.Variables("parmInt1Val").Value
End If
If Dts.Variables("parmInt2Name").Value.ToString <> "" Then

pkgChild.Variables(Dts.Variables("parmInt2Name").Value.ToString).Value =
Dts.Variables("parmInt2Val").Value
End If
If Dts.Variables("parmSTR1Name").Value.ToString <> "" Then

pkgChild.Variables(Dts.Variables("parmSTR1Name").Value.ToString).Value =
Dts.Variables("parmSTR1Val").Value
End If
If Dts.Variables("parmSTR2Name").Value.ToString <> "" Then

pkgChild.Variables(Dts.Variables("parmSTR2Name").Value.ToString).Value =
Dts.Variables("parmSTR2Val").Value
End If

' We do not use Serializable, because it is too system intensive.
If the developer has left
' the default options, change them
If pkgChild.IsolationLevel = IsolationLevel.Serializable Then
pkgChild.IsolationLevel = IsolationLevel.ReadUncommitted
pkgChild.TransactionOption = DTSTransactionOption.Supported
End If


' Set Checkpoint to be used
'pkgChild.CheckpointFileName =
Dts.Variables("PackageFolder").Value.ToString + "CheckPoint" +
Dts.Variables("ChildPkgName").Value.ToString.Replace(".dtsx", ".chkpoint")
'pkgChild.CheckpointUsage = DTSCheckpointUsage.IfExists
'pkgChild.SaveCheckpoints = True
pkgChild.CheckpointUsage = DTSCheckpointUsage.Never
pkgChild.SaveCheckpoints = False

' Initialize Logging
Dim logClass As LogClass = New LogClass()
pkgChild.LoggingMode = DTSLoggingMode.Enabled
pkgChild.LoggingOptions.EventFilterKind = DTSEventFilterKind.Inclusion
pkgChild.LoggingOptions.EventFilter = New String() {"PackageStart",
"PackageEnd", "OnProgress", "OnPreExecute", "OnPostExecute", "OnError",
"OnWarning", "OnInformation", "Diagnostic"}

' Set each task in package to Log
Dim evProvider As EventsProvider

For Each ex As Executable In pkgChild.Executables

evProvider = CType(ex, EventsProvider)
evProvider.LoggingMode = DTSLoggingMode.UseParentSetting


evProvider.FailPackageOnFailure = True ' For CheckPoint

' We do not use Serializable, because it is too system
intensive.
evProvider.IsolationLevel = IsolationLevel.ReadUncommitted
Next

' Run child package
logClass.StartLogging(Dts.Variables("ChildPkgName").Value.ToString, _
Convert.ToInt32(Dts.Variables("RunPackageID").Value), _
pkgChild.ID)
pkgChild.Execute(Nothing, Nothing, Nothing, logClass, Nothing)


If pkgChild.Errors.Count > 0 Then
logClass.EndLogging("Failure", pkgChild.ID)
Else
logClass.EndLogging("Success", pkgChild.ID)
End If

If pkgChild.Errors.Count > 0 Then
Dts.TaskResult = Dts.Results.Failure
Else
Dts.TaskResult = Dts.Results.Success
End If
End Sub

End Class


Public Sub Log(ByVal logEntryName As String, ByVal computerName As String,
ByVal operatorName As String, _
ByVal sourceName As String, ByVal sourceID As String, ByVal
executionID As String, ByVal messageText As String, _
ByVal startTime As Date, ByVal endTime As Date, ByVal dataCode
As Integer, ByRef dataBytes() As Byte) Implements IDTSLogging.Log

If String.Compare(_PackageName, sourceName, True) <> 0 Then
Select Case logEntryName

Case "PackageStart", "PackageEnd"
LogStep(logEntryName, sourceName, startTime,
messageText, sourceID, dataCode)

Case "PackageStart", "PackageEnd", "OnPreExecute",
"OnPostExecute", "OnProgress"
LogStep(logEntryName, sourceName, startTime,
messageText, sourceID, dataCode)

Case "OnError", "OnWarning", "Diagnostic"
LogStep(logEntryName, sourceName, startTime,
messageText, sourceID, dataCode)

Case "OnInformation"
If messageText.IndexOf(" wrote ",
StringComparison.CurrentCultureIgnoreCase) >= 0 _
AndAlso messageText.IndexOf(" rows",
StringComparison.CurrentCultureIgnoreCase) >= 0 Then

LogStep(logEntryName, sourceName, startTime,
messageText, sourceID, dataCode)
End If
End Select
End If
MyBase.Log(logEntryName, computerName, operatorName, sourceName,
sourceID, executionID, messageText, startTime, endTime, dataCode, dataBytes)
End Sub

Thanks in advance...

View 13 Replies View Related

PackageStart And PackageEnd Log Messages

May 2, 2008

I am a SSIS newbie and I have a created a SSIS package that runs every 5 minutes that imports a CSV file. It logs the PackageStart and PackageEnd events to a log file. I would like not to have these events logged. I only want error and warning messages to be logged in order to keep the log file small. With the GUI logging parameters, I was able to get the appropriate error and warning messages logged however, I was not able to turn of the ParkageStart and End messages. The reason to turn off these messages is to keep the log file small.

I have searched through this forum and it appears some sort of custome logger has a bi-product (feature/bug) of not logging these events. According to the threads, this is a bug and will be fixed at some point so this does not appear to long term the solution.

If I cannot turn off these messages, the other option would be to archive the log file every month and keep the current month and the previous months log file. Any log files prior to that can be deleted. Let me know if there are any examples of this. Also, I believe that this package would probably have to be called outside of the SSIS package the imports the CSV file since the import package probably has some sort of file handle open to the log file. Is this correct?


View 3 Replies View Related

Job Running SSIS Package Keeps Failing But The SSIS Package By Itself Runs Perfectly Fine

Aug 30, 2006

Hey, I've a few jobs which call SSIS packages. If I run the SSIS package, it runs fine but if I try to run the job which calls this package, it fails. Can someone help me troubleshoot this issue? None of my jobs that call an SSIS package work. All of them fail.

Thank you

Tej

View 7 Replies View Related

Event PackageEnd Not Firing - When Custom Logging Programatically

Oct 24, 2007

In my console application code which creates and executes SSIS package I have this code.





Code Block
provider.ConfigString = loggingConnection.Name;
package.LoggingOptions.SelectedLogProviders.Add(provider);
package.LoggingOptions.EventFilterKind = DTSEventFilterKind.Inclusion;
package.LoggingOptions.EventFilter = new string[] { "OnPipelineRowsSent","PackageEnd" };
package.LoggingMode = DTSLoggingMode.Enabled;


I use a custom log component to log the events. However the "PackageEnd" event does not seem to get fired at all.



Am I missing something in this?

Thanks

View 1 Replies View Related

Failed To Start Package

Sep 22, 2006

Hi,

I am getting the following error message, when I was trying to execute an existing SSIS Package which was working properly before.

"Failed to Start Package

Cannot communicate with the debug host process. Failed to obtain child process active object. (Microsoft.DataTransformationServices.VsIntegration)"

So I tried creating a new package and execute it, still I am getting the same error message.

If anyone have come across this problem and rectified it, pls let me know.

Thanks in advance for your help.

Regards,
Prakash Srinivasan

View 6 Replies View Related

Why Does The Start Of My Package Seem To Get Validated Last

Apr 15, 2008



I truncate some tables before refreshing the data and that is one of the last steps shown in the package execution progress window when watching the package run.

Both in Visual Studio and when I use the Execute package utility once I have put the package on the server?


Is there a problem with having multiple truncate statements in one execute T-SQL statement task?

View 11 Replies View Related

Can A Trigger Start A DTS Package Process?

May 26, 2001

I expect to create a trigger to post updated data from GoldMine hosted in MS-SQL to my migration MS-SQL database in the appropriate tables mirroring the destination PICK data tables.

Then, start an ActiveX DTS package to migrate the data via a PICK DSN to data tables in a PICK database.

Currently the dba has been able to use VB6.0 with ADO to push data into PICK. He also was able to do similar using MS-Access.

However, PICK (RainingData) is of the opinion that he must script a PICK server side Basic (RealBasic) insert script to receive the data from a VB6.0 application triggered by MS-SQL.

I think that I could skip the Basic script and go direct with ADO in DTS as he has before with VB6.0 with a user form.

Can I have the trigger start the DTS or should I just schedule it to run as often as necessary to update the PICK database?

FYI, this is a one-way data flow into PICK.

TIA

Anyone within the L.A. CA area that has experience with PICK and MS-SQL can get some well paid consulting hours. I'm just the GoldMine GMT whose been enlisted to get the job done, but would appreciate an expert with PICK to join the project.

jEfFp...

View 1 Replies View Related

Error While Executing SSIS Package From Other SSIS Package

Jan 10, 2007

Hi,

In our project we have two SSIS package.

And there is a task (Execute SSIS package) in First package that calls the execution of second package.

I m continuously receiving an error "Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available."

As we are running first package by job, job runs successfully logging above error

The protection level of second package is set to "EncryptSensitiveWithUserKey"

Can anybody please suggest how to handle it?

View 4 Replies View Related

Dtsrun To Start A Package - Cannot Find Xp_cmdshell

Jul 23, 2005

Newbie here.In my database I'm needing to automate some data imports. I have theimport set up as a DTS package and it works wonderfully. But I'mhaving trouble kicking it off as a stored procedure, or even from theQuery Analyzer. I used dtsrunui to get a proper connection string, butwhen I enterEXEC xp_cmdshell 'dtsrun /S "(local)" /N "MyPackage" /A"KeyNum":"19"="19687627" /W "0" /E'I get an error that says "Could not find stored procedure'xp_cmdshell'". xp_cmdshell is indeed there, under Master, ExtendedProcedures. I tried calling it dbo.xp_cmdshell, but that didn't help.I'm guessing that I need to point the command to the location of theSP, but I have no idea how to do that. Anyone willing to shed a littlelight would get my eternal gratitude. :)Thanks in Advance, maddman

View 2 Replies View Related

Log Start &&amp; End Of Every Step &&amp; Send File At End Of Package

Nov 15, 2007

I would like to create a log of what happens with each step in the package, at least start & start time and email that at the end of the package

Is this possible?

Thanks

JPS

View 3 Replies View Related

SQL 2012 :: Long Delay Between Job Start And Actual Package Execution

May 7, 2014

I have problems sometimes with a package.

There is and SQL Agent job that starts a package (from a file system using cmd command). Usually job takes 8-10 minutes. But sometimes it get stuck for a long time (1+ hour).

DTexec process can be found with procmon, but it seems it just not doing anything (And package is not logging to file Start of the execution) After long wait it just runs a package quickly.

I've moved a package to SSIS catalog to try to get more detailed logging, but with no luck.

Job starts at 1 PM, package execution starts at 1:49 PM. Without any messages about the execution in SSISDB log.

First I've thought it might be long validation problem, but when package executes validation messages are there and they perform quick.

View 3 Replies View Related

Scheduled Package Runs Longer Time Than Manually Start The Job

May 16, 2008

Hi,

I have a package designed as bring data tables over to SQL Server. There are 9 data flow tasks that runs parallel, to bring 9 datatables over. In BIDS, when I execute the package, it runs like 8 minutes. Or if I start the scheduled job manually, it runs around 8 minutes too. But it runs about 30 minutes at the scheduled time at midnight.

I wonder what I can do to speed up the scheduled job.

Thanks

View 13 Replies View Related

HOWTO Disable Package Start / Finish Events In Eventviewer

Oct 10, 2006



hi all,

i searched and all i found is questions, not answers.

maybe it's a silly question, but i really can't find any documention / posts about this.



i have a scheduled job in sqlagent that executes a SSIS package that runs every minute. As a result, my application log in eventviewer gets filled very quickly.

i tried using "/REPORTING E" option with no luck.

i tried enabling logging on the package, and then select only the OnErro Event, no luck.

does anyone have this problem ?

does anyone have a solution ?



TIA

View 4 Replies View Related

Can't Start SSIS

May 12, 2006

Hello,

Our enterprise have bought a sql server 2005 standard edition.
Before installing it i have installed the beta version.
And after I desinstalled this beta version (with difficulties).
But the problem is that I can't start SSIS.

I have the following message:
"The request failed or the service did not respond in a timely fashion.
Consult event log or other applicable error logs for details."

Please can you help me.
Thanks.

View 5 Replies View Related

Passing Execute DTS Package Result (success/failure) To Calling SSIS Package

Mar 6, 2008

I have a SSIS job, one of the last steps it performs is to execute a SQL 2000 DTS package. This has to be done as a SQL 2000 DTS package as it is performing rebuilds of SQL 2000 Analysis Services dimensions and cubes. We've found that when the DTS fails the SSIS job is happily completing showing as a success, we would prefer to know it went wrong.

As far as I'm aware SSIS merely starts the DTS off and doesn't care about it's result. I've taken a look in to turning on the logging for the execute DTS package and thought that the ExecuteDTS80PackageTaskTaskResult would give me the answer I need...but is merely written to the log not available as an event-handler. It also looks like it is not safe to put a SQL task in as the next item to go look at the SQL 2000 system tables to look at the log for the DTS package as the SSIS documentation warns that the DTS package can continue to run after the execute DTS package task has ended.

Ideally I want any error raised within the DTS package to cascade up to be an error in the SSIS job, I can then handle it appropriately. I cannot find a way to do this. Is there a way?

If not, can anyone suggest how in the remainder of the SSIS tasks I can be sure that the DTS has completed before I start any other tasks that will check for the SQL 2000 log of its execution?

View 5 Replies View Related

Error Stating Package Failure While Executing SSIS Package In Standard Edition

Feb 2, 2007

Hi,

I have developed an SSIS package for ETL purpose. I am invoking the SSIS package through .Net console application by referencing the ManagedDTS Assembly. I am able to execute the package in Sql Server 2005 Developer Edition and it runs fine till completion.

But when i try to execute the packahe in Sql Server 2005 Standard edition, by invoking the package through .Net console application the status of the package is failure.

Can any one help me how to over come this problem.



View 1 Replies View Related

Several Different Errors When Creating And Running SSIS Package. Package Runs Successfuly Sometimes.

May 2, 2008

Hi All,



I am in the process of moving from a 32-bit SQL Server 2005 Enterprise (9.0.3054) to a 64-bit SQL Server 2005 Enterprise (9.0.3054 with 4 CPUs and 8GB of memory on Win 2003 SP2) and the process has been very frustrating to say the least. I am having a problem with packages that I created on my 64-bit SQL Server. I am importing a few tables from the 32-SQL Server into the 64-bit SQL Server using the Task --> Import to create the package.



Sometimes when I am creating a package I get the following error in a message box:



SQL Server Import and Export Wizard

The SSIS Runtime object could not be created. Verify that DTS.dll is available and registered. The wizard cannot continue and it will terminate.

Additional information: Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (System.Windows.Forms)





Other times when I run a package that has run successfully before I get the following error:



Faulting application dtexecui.exe, version 9.0.3042.0, stamp 45cd726d, faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault address 0x025d23f0.





Other times I get this error message:



.NET Runtime version 2.0.50727.1433 - Fatal Execution Engine Error (79FFEE24) (80131506)





And still other times



The package appears to hang when running. By this I mean that the Package Execution Progress shows progress up to a point then it just stops. (The package takes about 17 seconds to run normally) CPU usage is at 1% and the package cannot be stopped.





I have deleted and re-created the package several times and I have also re-installed the service pack on the SQL Server (9.0.3054) but that did not help.





Does anyone have any other suggestions to try?





Thanks.



View 4 Replies View Related

Is It Possible To Change Or Replace The Default Package Template Named New SSIS Package?

Feb 21, 2008

I would like to standardize SSIS development so that developers all start with the same basic template. I have set it up so it is an available template ( http://support.microsoft.com/kb/908018 ) but I would like it to be the default when a new project or package is created. Is this an option?

View 4 Replies View Related

SQL 2012 :: How To Capture Data Flow Component Name Dynamically While Package SSIS Package Is Executing

Jun 3, 2014

I would like to fetch the data flow component name while package is executing. Since system variable named [System::SourceName] only fetches name of the control flow tasks? Is there a way to capture them?

View 5 Replies View Related

Problem When Running A SSIS Master-package-child Package On Non Default Sql-server Instance

Dec 6, 2007

Hi there

We have a SSIS run which runs as follows


The master package has a configuration file, specifying the connect strings
The master package passes these connect-strings to the child packages in a variable
Both master package and child packages have connection managers, setup to use localhost. This is done deliberately to be able to test the packages on individual development pc€™s.
We do not want to change anything inside the packages when deploying to test, and from test to production. All differences will be in the config files (which are pretty fixed, they very seldom change). That way we can be sure that we can deploy to production without any changes at all.

The package is run from the file system, through a job-schedule.

We experience the following when running on a not default sql-server instance (called dkms5253uedw)

Case 1:
The master package starts by executing three sql-scripts (drop foreign key€™s, truncate tables, create foreign key€™s). This works fine.

The master package then executes the first child package. We then in the sysdtslog get:

Error - €œcannot connect to database xxx€?
Info - €œpackage is preparing to get connection string from parent €¦€?

The child package then executes OK, does all it€™s work, and finish. Because there has been an error, the master package then stops with an error.

Case 2:
When we run exactly the same, but with the connection strings in the config file pointing to the default instance (dkms5253), the everything works fine.

Case 3:
When we run exactly the same, again against the dkms5253uedw instance, but now with the exact same databases defined in the default instance, it also works perfect.

Case 4:
When we then stop the sql-server on the default instance, the package faults again, this time with


Error - €œtimeout when connect to database xxx€?
Info - €œpackage is preparing to get connection string from parent €¦€?

And the continues as in the first case

From all this we conclude, that the child package tries to connect to the database before it knows the connection string it gets passed in the variable from the master package. It therefore tries to connect to the default instance, and this only works if the default instance is running and has the same databases defined. As far as we can see, the child package does no work against the default instance (no logging etc.).

We have tried delayed validation in the packages and in the connection managers, but with the same results (error).

So we are desperately hoping that someone can help us solve this problem.


Thanx,
/Nils M - Copenhagen

View 3 Replies View Related

SSIS Service Won't Start

Jan 3, 2006

I've been completely unsuccessful so far in getting the SSIS service to start under normal circumstances.



I've got the SQL 2005 RTM DVD and a clean, brand-new installation of
Windows 2000 Server (Service Pack 4). All system requirements have been
met according to the SQL installer. I choose to install just the
Database Engine, SSIS and the Workstation components, all other
installation options are defaults except Services, which are set to use
a Domain User account.



The install completes without problems and the SQL Server & SS
Agent services start suceessfully, but the SSIS service refuses to
start (timeout). If I change the service to use LocalSystem, the same
happens. If I make the Domain User (DOMAINMisterSQL) account a member
of Local Admins on the server, the service still won't start.



If, however, I use a Domain Admin account, the service does start, so it appears to be a security issue, but how can I configure the service to start with fewer privileges?



This problem has appeared on each machine I've tried this on, four to
date, so it's not related to the particular setup of this server. I've
searched the web for weeks for a solution with no success; any help
would be greatly appreciated.

View 10 Replies View Related

SSIS Won't Start - XP Pro WMI Error

Jan 16, 2006

I have an install of SQL Server 2005 Developer Edition, and the Integration Services Service will not start.  If I attempt to start the service via the Services Computer Management screen, the system throws a message that says the service started, then stopped.

If I attempt to start the service via the SQL Server Configuration Manager, I get a "service did not respond in a timely fashion", which is so unfashionable.

Of particular interest is that during the install I did get an error message about WMI security.  Looking at the WMI Security tab in WMI Control, I noticed that the key that the setup program was trying to configure did not exist under "ServerEvents".

There is a key named "MSSQLSERVER", but that did not match the key that the setup program was complaining about. 

I am not seeing any event log items relating to errors.  The system log shows the service startup and service shutdown as information items.

Anyone have any ideas?

 

 

 

View 3 Replies View Related

SSIS Failed To Start

Jan 23, 2006

We installed the SQL Server 2005 Developer edition on one of our test server after uninstalling the beta version.   Also, we had to rename an entry in the registry to get the install (all components)  to work.   When I tried to start Integration Services (all the other servers started OK), I get the following error in the Event log.

 

Microsoft SSIS Service failed to start.

Error: Method 'GetVersionInfo' in type.

 

Any ideas on how to get SSIS to start.

 

 

 

View 2 Replies View Related

Passing Value From A Child Package To The Parent Package That Calls It In Ssis

May 21, 2007

hi,



I am interested in Passing value from a child Package variable to the Parent package that calls it in ssis.



I am able to call the Child package using the execute package task and use Configurations to pass values from the parent variable to the child, but I am not able to pass the value from the child to the parent.



I have a variable called datasetId in both the parent and child. it gets computed in the child and needs to be passed to the parent...





Any suggestions?



Thanks for any help in advance..



smathew

View 8 Replies View Related

Report With SSIS Package Having Indirect Package Configuration Setup

Sep 10, 2007

Deployed Report having SSIS package as source do not work when Indirect Package configuration is used in ETL package. It seems ETL package when called/executed from Report manager does not recognize environment variable to pick up the dtsconfig file.

The Report works when Direct package configuration is used to same dtsconfig file.

What could be the reason? Any solution for this? This will cause our build/deployment to QA and Prod very difficult.

View 1 Replies View Related

How To Compose The Connection String Of A SSIS Package That Execute Another Package?

Jul 6, 2006

Dear All,

I now have two SSIS package, "TESTING" and "LOADING". The "TESTING" package have an execute package task that call the "LOADING" package. When I want to execute the TESTING package, how can I setup the connection string so that I can edit the password of the database connected by the "LOADING" package?

Regards,

Strike

View 8 Replies View Related

SSIS Parent Package Can Not Find The Child Package

Oct 13, 2007

I have two SSIS packages in a project, one calling the other. The parent package works fine in my local mechine. After they are deployed to the production, I schedeul jobs to run the packages in the SqlServer. The child package works fine if I run it alone, but the parent package could not find its child package if I run the parent package . As I checked, all xml config files and the connection string pointing to the child package were set correctly. It seems the parent package did not use the xml config file. Can someone help me? Thanks in advance.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved