SSIS Error With Duplicate IDs Of Copied Packages

ERROR EXECUTING Ssis PACKAGES
HI ALL.
I HAVE A PACKAGES WHICH THEN EXECUTES CHILD PACKAGES. tHE CONNECTION managers are specified. and environmental variables are saved on xml file. when i run(debug) parent packages on BIS , it gives me error saying the "error loading package file "childpackage_name.dtsx1st ".the system canot find the file specified.

how ever if i build solution it gives me output saying build successful..
i do not ge this..
anyhelp guys.

View Replies !

---

Error Deploying Ssis Packages
We're getting this message on one of our developer's boxes when they try to deploy a package to any instance of sql, even the local.  Thinking about just reinstalling the workstation components but any ideas to what might be the cause?

 
No description found
 
------------------------------
Program Location:
 
   at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String serverUserName, String serverPassword)
   at Microsoft.DataTransformationServices.Controls.PackageLocationControl.SavePackage(Package package)
   at Microsoft.SqlServer.Dts.ObjectExplorerUI.ExportPackageAction.OnSavePackage(Object sender, CancelEventArgs e)

 

View Replies !

---

Error Handling For SSIS Packages In .NET
Hi guys,
i'm running my SSIS package via a web application,





Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();

Package pkg = app.LoadFromSqlServer("\send mail test", "localhost", null, null, null);

Variables vars = pkg.Variables;

vars["username"].Value = "C# user Name ";

vars["message"].Value = "C# body text";

DTSExecResult result = pkg.Execute();

//MessageBox.Show(result.ToString(), "result from dts"); --app mode

now sometimes the "result" variable return Failure, but i don't know what's wrong, when i run the package in debug mode (in VS) it works fine. DTSExecResult only returns "Success" or "Failure", is there a way to find out more information about the result. like why did the package fail?

the ssis package is built with event handlers but they don't get triggered. it's just when i execute from the web it just returns failed. i checked all the SQL connections as well, they are all fine, as they use SQL authentication, and connection strings are hardcoded as expressions.

any help?

View Replies !

---

Error: Could Not Get A List Of SSIS Packages From The Project.
Hello,

I have a SSIS package and I am trying to build it using devenv.com from command line. It gives me this error:

Error: Could not get a list of SSIS packages from the project.

 

However if I open the project in Visual Studio it builds properly. In project property I have set CreateDeploymentUtility=true.

This is what I do from command line:

devenv.com MySSIS.sln /Build "Development|Default"

 

Any idea what I  should do ?

 

Thanks

Deval

View Replies !

---

SSIS : Stored Packages Error - MSDB
Hi All

View Replies !

---

Error Executing, SSIS Packages Coppied From Another Server
Hello All,

  I am working on an application used to move packages (SSIS Packages) from one server to another.The packages are saved under MSDB folder.  

Case: When the application is running on my system, i try to copy packages created  from another server to my Server.I am using package protection level as "Server Storage". When i try to execute the coppied package from my system, it is giving me error.
An oledb error has occured, Error Code 0x80040E4D, An Oledb record is available, Source : Microsoft OLedb Provider for Sql Server", Description : "Login failed for sa".


Case : When the Package Coppier application is running on my system, i try to copy packages created  on my  server to my another Server.I use the same package protection level as "Server Storage". When i try to execute the copied package on destination server it is working fine without errors.

Please guide me on this issue, as soon as possible

Thanks And Regards
Subin

View Replies !

---

Error When Deploying SSIS Packages Using Deployment Wizard
 have tried to use the Package Deployment Wizard of the Integration Services.

I have been able to deploy it successfully in some PC before I met one error on the other PC.

 It have detail error message like below:

 

===================================

Could not save the package "\bsuser004Shared DocumentMYVUE DW 20060708MYVUE DW - Deployment_ v10_20060710SSIS DeploymentpkgSummarizationWeekly.dtsx" to SQL Server "(local)".  (Package Installation Wizard)

===================================

The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.


------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)
   at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events)
   at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.SavePackageToSqlServer(WizardInputs wizardInputs, String packagePassword, Boolean bUseSeverEncryption, String serverName, String userName, String password, String packageFilePath, List`1 configFileNames)
   at Microsoft.SqlServer.Dts.Deployment.DtsInstaller.InstallPackagesToSqlServer(WizardInputs wizardInputs)

===================================

The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.


------------------------------
Program Location:

   at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.LoadPackage(String FileName, Boolean loadNeutral, IDTSEvents90 pEvents)
   at Microsoft.SqlServer.Dts.Runtime.Application.LoadPackage(String fileName, IDTSEvents events, Boolean loadNeutral)

 

View Replies !

---

Error Importing SSIS Packages On SQL Management Studio
 

I encounter this error when importing SSIS packages using SQL Server Management Studio:
 
===================================
Unable to cast object of type 'Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction' to type 'Microsoft.SqlServer.Dts.ObjectExplorerUI.ISimpleAction'. (Microsoft.SqlServer.DtsObjectExplorerUI)
------------------------------
Program Location:
   at Microsoft.SqlServer.Dts.ObjectExplorerUI.DtsServerMenuItem.Invoke(INodeInformation parent, String mode, String assembly, String type)
 
The Integration Services that I'm using has just been rebuilt due to problems after installing SP2. I'm using Integration Services 9.0.3042. I can't find anything having this same problem. Any help will be appreciated.
 
Thanks!

View Replies !

---

SSIS - Browse MSDB Stored Packages Error
I've just installed sql 2005x64 and sp2 on a active/passive cluster on 2003.  Everything is working fine except browsing the stored msdb packages in SSIS.  Remote acces is enabled - as are named pipes.  I've tried doing this on the local server as well.  I was able to create a maintenance plan and run it with no problems. 

 

We got an error during the install pertaining to SSIS, but hit ignore and it went on successfully.

 

It was - failed to install and configure assemblies .....MSMQTask.dll in the com+ catalog.  Error -2147467259.

description: Error HRESULT E_FAIL has been returned from a call to a COM component.

 

The browsing error is below.

 

Thanks!

Sam

 

 

 

TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

The SQL server specified in SSIS service configuration is not present or is not available. This might occur when there is no default instance of SQL Server on the computer. For more information, see the topic "Configuring the Integration Services Service" in Server 2005 Books Online.

Login timeout expired
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
Named Pipes Provider: Could not open a connection to SQL Server [2].  (MsDtsSrvr)

------------------------------
BUTTONS:

OK
------------------------------


 

View Replies !

---

Error On Executing SSIS Packages On A Remote Machine Using Code
Hello all,

 

I am trying to execute the ssis packages using code.These packages are hosted on remote server under MSDB in local Network.

 

Below is the code tried to Execute
--------------------------------------------------

DTSExecResult execRslt = _dtsxPackage.Execute();

foreach (DtsError dtserr in _dtsxPackage.Errors)
{
         Console.WriteLine("Source: " + dtserr.Source + ", Description: " + dtserr.Description);
}


I get hte following Error
--------------------------------

 

"Dupaco Load MMAs"-------------"An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80004005  Description: "[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.".
"

"Data Flow Task" -------"The AcquireConnection method call to the connection manager "Dupaco" failed with error code 0xC0202009.
"

"Data Flow Task" ----------"component "OLE DB Destination" (119) failed validation and returned error code 0xC020801C.
"

 

"One or more component failed validation.
"

 

"There were errors during task validation.
"

 

When i try to execute the same code on the server where all the package are hosted. It is working fine.

 

More Info:

In thepackage we are using one "Source Flat file connection" and one "Oledb Destination connection"

Please help me to solve this problem, as my client needs it very badly


Thanks
Subin

View Replies !

---

Access Denied Error When Calling Several SSIS Packages In A Chain
Hi.

I have problem executing several SSIS-packages in a chain.

To be more precise:
I have implemented a Biztalk 2006 application which via a local webservice executes an SSIS package. The package it self calls another SSIS package, which is located in the same folder as the calling package. The second package then calls a third package etc.

The problem arises, when the first package calls the second package. An Access Denied exception is received. Can any one explain me how to fix this?

The user connected to the application-pool that the weservice is running under, has execution-rights on all of the packages.

Thanks

View Replies !

---

Calling SSIS Packages From ASP.NET - Packages With File System Tasks End Abruptly
I've run into a problem with SSIS packages wherein tasks that write or copy files, or create or delete directories, quit execution without any hint of an error nor a failure message, when called from an ASP.NET 2.0 application running on any other machine than the one where the package was created from. By all indications it appeared to be an identity/permissions problem.

Our application involves a separate web server and database server. Both have SQL Server 2005 installed, but the application server originally only had Integration services. The packages are file system-deployed on the application server, and are called using Microsoft.SqlServer.Dts.Runtime methods. For all packages that involve file system tasks, the above problem occurs.

When the above packages are run using the command prompt (either DTEXEC or DTEXECUI) the packages execute just fine. This is expected since we are using an administrative account. However when a ShellExecute of the same command is called from ASP.NET, the same problem occurs.

I've tried giving administrative permissions to the ASPNET worker process user to no avail.

I have likewise attempted to use the SQL Server Agent job approach but that approach might not be acceptable for our clients since it means installing SQL Server 2005 Database services on the application server.

I have read the relevant threads in this forum, namely http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1044739&SiteID=1 and http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=927084&SiteID=1 but failed to find any solution appropriate for our set up.

Anybody got any idea on how to go about this?

View Replies !

---

CREATE TABLE DUPLICATE OBJECT/DUPLICATE FIELD NAME ERROR Msg 2714
Hello Everyone:
 
I am using the Import/Export wizard to import data from an ODBC data source. This can only be done from a query to specify the data to transfer.
 
When I try to create the tables, for the query, I am getting the following error:
 



Msg 2714, Level 16, State 4, Line 12

There is already an object named 'UserID' in the database.

Msg 1750, Level 16, State 0, Line 12

Could not create constraint. See previous errors.

 
I have duplicated this error with the following script:
 

USE [testing]

IF OBJECT_ID ('[testing].[dbo].[users1]', 'U') IS NOT NULL

DROP TABLE [testing].[dbo].[users1]

CREATE TABLE [testing].[dbo].[users1] (

[UserID] bigint NOT NULL,

[Name] nvarchar(25) NULL,

CONSTRAINT [UserID] PRIMARY KEY (UserID)

)

IF OBJECT_ID ('[testing].[dbo].[users2]', 'U') IS NOT NULL

DROP TABLE [testing].[dbo].[users2]

CREATE TABLE [testing].[dbo].[users2] (

[UserID] bigint NOT NULL,

[Name] nvarchar(25) NULL,

CONSTRAINT [UserID] PRIMARY KEY (UserID)

)

IF OBJECT_ID ('[testing].[dbo].[users3]', 'U') IS NOT NULL

DROP TABLE [testing].[dbo].[users3]

CREATE TABLE [testing].[dbo].[users3] (

[UserID] bigint NOT NULL,

[Name] nvarchar(25) NULL,

CONSTRAINT [UserID] PRIMARY KEY (UserID)

)

 

I have searched the "2714 duplicate error msg," but have found references to duplicate table names, rather than multiple field names or column name duplicate errors, within a database.
 
I think that the schema is only allowing a single UserID primary key.
 
How do I fix this?
 
TIA

 

View Replies !

---

How To Remove Duplicate From CSV Using SSIS
Hi All ,

 

I have a CSV file which contains some duplicate record and i have to load this file in SQL server database using SSIS package .

 

What i have to do is read the file and if the same record entry is occur more than 10 times for a particular unique combination ( like ID , Date , Time ) then  i need to take only one record for that occurance.

 

Plesae suggest , Help ,

 

Regards,

Ashish

View Replies !

---

How To Get The Duplicate File In Ssis
is it possible that i can retrieve the list of all records that are duplicate and put them in a excel files

View Replies !

---

Duplicate Logging In SSIS
I am having a problem where duplicate log statements are being written to a log file (as defined by a log provider).
 
I believe that this is because in the logging dialog box, I have ticked the checkbox next to a child task to override the logging functionality.
I need to do this because it is a script task and I want to capture "ScriptTaskLogEntry" events (something that I cannot do at the parent level).
However by doing this I seem to get the script events written at the parent, as well as at the Script Task level.
 
Is there any way of avoiding this, but still capturing the log events from the script task?
 
Another issue that is possibly linked is that I am getting an error from the log provider:
 

The SSIS logging provider "SSIS log provider for Text files" failed with error code 0x800700EA ((null)). This indicates a logging error attributable to the specified log provider.
 
Could this be because of the parent and child task are both attempting to write to the same log provider?
 
Thanks in advance

View Replies !

---

SSIS:package Contains Two Objects With The Duplicate Name
public static void CreateDestDFC1()
{
destinationDataFlowComponent1 = dataFlowTask.ComponentMetaDataCollection.New(); destinationDataFlowComponent1.Name = "SQL Server Destination 1"; destinationDataFlowComponent1.ComponentClassID = "{5244B484-7C76-4026-9A01-00928EA81550}";
managedOleInstance1 = destinationDataFlowComponent1.Instantiate(); managedOleInstance1.ProvideComponentProperties(); managedOleInstance1.SetComponentProperty("BulkInsertTableName", "Employee"); managedOleInstance1.AcquireConnections(null); managedOleInstance1.ReinitializeMetaData(); managedOleInstance1.ReleaseConnections();
 }
//Second one here..
public static void CreateDestDFC2()
{
destinationDataFlowComponent2 = dataFlowTask.ComponentMetaDataCollection.New(); destinationDataFlowComponent2.Name = "SQL Server Destination 2"; destinationDataFlowComponent2.ComponentClassID = "{5244B484-7C76-4026-9A01-00928EA81550}";
managedOleInstance2 = destinationDataFlowComponent2.Instantiate(); managedOleInstance2.ProvideComponentProperties(); managedOleInstance2.SetComponentProperty("BulkInsertTableName", "Customer");
 managedOleInstance2.AcquireConnections(null);
managedOleInstance2.ReinitializeMetaData();
managedOleInstance2.ReleaseConnections();
}
And its giving a error.can anyone say why? or can anyone change this?
The package contains two objects with the duplicate name of "component "SQL Server Destination" (50)" and "component "SQL Server Destination" (22)".

View Replies !

---

How To Extract Duplicate Record Using Ssis
 

ex. from source the file you want to split the record into two, the one with a clean record and the other one with duplicate records

View Replies !

---

Duplicate Primary Key Issue In SSIS
I have 3 source for IS flow. One is flat file, one is DB table and one is output bad data. It might be a situation when I could have duplicate primary key since records come from 3 sources (flat file, db table, reject (output) table). Can any one give me suggestion how to handle duplicate primary key problem in this situation.
 
Any suggestion will be appreciated.
 
Thanks..
 

View Replies !

---

SSIS- Doing Conditional Duplicate Removals
Hi,

First post here. Anyway, I have a question regarding SSIS. I'm currently given a task that requires reading a flat file, applying duplicate removal as well as invalid data removal, processing it, and finally writing it to a SQL Server 2005 DB.
 
Part of the processing requires checking for partial duplicates in the batches of records provided in the text file. For example, the record contains a a phone number, status, timestamp of creation and various other entries. If a phone number is repeated (meaning, duplicate entry), a column called 'Status' must be checked, and only entries with the status of 'C' is allowed through.

 
Another part of the processing requires that if the phone number is repeated along with various other entries including status, the timestamp of creation is checked and only the entry with the most recent timestamp is accepted.
 
I would like to know how to implement this in SSIS without using table objects and scripts, as my experience tells me that doing this in a script can really take a hit on system performance. The task is expected to handle tens of thousands of records in a day.
 
Any help will be appriciated.
 
Thanks.

View Replies !

---

What's In SSIS Causing Duplicate Records?
I've a dtsx package which runs nightly to do following:

1. select data from a SQL replicated table
2. do some lookups (Lookup, Derived Column, Multicast, Conditional Split, etc.)
3. insert into another SQL table on another server using "Table or view - fast load", rows per batch = 10000, maximum insert commit size = 10000, and "redirect row" on error output on destination to an error log text file.
Once in a while, I found duplicate records in the error log; these rows cannot be inserted into destination table due to primary constraint.  For example, transaction_id=111000 appears twice in the error log but it is a unique key in the source table.

 
My questions:
1. What could be the cause of duplicating rows during ETL in SSIS?  I've asked this before and have spent so much time research but still could not find the reason.  This link is from my previous post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=452319&SiteID=1
 

2. For a daily extract data with over millions of rows, what would be best to set rows per batch, maximum insert commit size, etc?  I've read  some posts on this forum and decide to use 10000 for both, but once in a while there's just one duplicate rows that causes the whole batch of 10000 rows not committed.
 
Thanks for any feedbacks.
 
-Ash

View Replies !

---

SSIS Packages
Hi,


Is there a way to reuse existing Configuration Files in SSIS Packages?

I have two packages with the same connection managers, properties and variables.

I want to reuse the Config file of the 1st package in the second one. While building the packages it gives error like

“Config file already exists cannot recreate”.

View Replies !

---

SSIS Packages
Hi All,

I have created SSIS (.dtsx) files and have stored in different servers.
Now my query is I want to move all dtsx files from filesystem to Sqlserver2005 database how should i do it.

Please help

Regards
Hassan

View Replies !

---

SSIS Packages Run Twice After SP2
Hi,

I upgraded to Microsoft SQL Server 2005 Service Pack 2 and now when I run the master SSIS package( that has several packages in it), all the packages run twice.

After removing SP2, they work fine. Any ideas how to make this work with SP2?

 

 

View Replies !

---

Ssis Packages
Where are SSIS packages stored and how can I see them in SQL Server Management studio?

View Replies !

---

DTS Packages In SSIS
I read in Kirk Haselden's book "Microsoft SQL Server 2005 Integration Services" that if SQL Serfver 2005 and 2000 are installed on the same machine as seperate instances then you can view the SQL Server 2000 DTS packages in 2005 Management Studio under the Management tree, Legacy, Data Transformation Services node.

But in my case, I am not able to see DTS packages in Management Studio. Is there a property or a setting that we need to configure for that?

Thanks.

 

 

View Replies !

---

SSIS Packages
I am writing a vb application that is supposed to let the users set the connection string for the datasources in the package. After new connection strings are entered the application is supposed to run 8 packages in a certain order, but I haven't been able to set a new connection string successfully. Is there a way to programmatically modify the connection string of a package's datasource? (the packages are moving data from a D3 database to sql server 2005)

Here is what I have tried so far:

A.
        Dim pkgLocation As String
        Dim app As Application = New Application()
        pkgLocation = "c:Package1.dtsx"
        Dim pkg As Package = app.LoadPackage(pkgLocation, Nothing)
        Dim myConns As Connections = pkg.Connections


        MessageBox.Show(myConns(0).ID.ToString)
        Dim myConnMgr As ConnectionManager = myConns(0)
        Dim connProperties As DtsProperties = myConnMgr.Properties

        connProperties(0).SetValue(myConnMgr, "notsupposed=towork;")
        MessageBox.Show(myConnMgr.ConnectionString)


B.
        ConMgr = p.Connections.Add("OLEDB")

        ConMgr.ConnectionString = "Provider=SQLNCLI.1;Data Source=192.168.0.233;                      User  ID=sa;    Initial Catalog=Rmt_New"
        ConMgr.Name = "SqlDatabase"
        ConMgr.Description = "Sql Connection"


Any help would appreciated.

View Replies !

---

Can't Seem To Run SSIS Packages On The 64 Bit...
I am connecting to a DB2 mainframe to pull data into SQL 2005.  Very simple import.  SSIS package works fine on 32 bit.  However, once deployed to the 64 bit machine, I get "invalid product license" on the Acquire Connection method.  

I've worked with IBM support.  I have the correct version of the DB2 Connect client installed.  The license is there and in the right place.  I can connect to the mainframe from the 64 bit server using the DB2 client tools.  I just can't seem to execute the package from Integration Services or run a job in SQL Server that executes the package.

According to BOL, the package should automatically detect the 64 client I installed.  It and the 32 bit client I developed with share the same name/id.

Am I missing something?  Any hints? 

View Replies !

---

New To Ssis Packages
Hi,

iam New to Packages. So Please give me the guidelines to Learn Packages.

Thanks for Advance

View Replies !

---

SSIS Packages
I need to create the ssis package in business intelligence developement studio i am need to sqlserver 2005.When i opened the BID studio i am not able to see the integration services packages type..
Please help the steps to design the package.

I have experience of using the 2000 in dts designer mode.

Thnks for your help in advance.

View Replies !

---

SSIS Packages Dashboard
Hi there,I've planed the excecution of packages, some at different times, someother at the same time.Do you know how I can follow in real-time the execution of the packageswith the start time, the current status....etc...Is there a native Microsoft tool existing for that? Otherwise, is therea 3rd party tool?Thanks,Chris

View Replies !

---

Editing SSIS Packages
I have created several packages in SQL Server 2005 to transfer tables between databases on various servers. After the fact, I realized that I need to edit one of the packages because of an error I made. When making the package, I chose to save it on "SQL Server" rather than as "File". How do I edit the SSIS package? My only other option is to delete and recreate, which I would like to avoid if possible! Any help would be greatly appreciated....thanks!:eek:

View Replies !

---

SSIS Packages In A Cluster
I'm still new to SSIS packages and I'm NOT a developer. I am in the process of doing preliminary/prepatory work for migrating our SQL 2000 platforms to SQL 2005.

I am having a REAL headache with migrating/moving DTS packages from SQL 2000 to SQL 2005. Here are things that I know :

1. I know that some packages cannot be migrated due to ActiveX issues and other issues. Fine.

2. I know that I can install DTS backwards compatibility components on the server in order to be able to edit the DTS packages using a SQL 2000 DTS GUI. Fine.

3. I know that I can use the Migration wizard to migrate packages (and that some of them can't be migrated this way). Fine.

Here's what I don't know/or am conjecturing:

1. In a clustered environment, I have to edit the <%Install Path%>/90/DTS/Bin/MsDtsSrvr.ini.xml file to set the <ServerName> property to the Virtual Server name. Correct? Why can't M$ do this for me?

2. Do I HAVE to export the SSIS package to a .DTSX file in order to be able to edit it with Visual Studio? Is there ANY way around this?

3. If I am running in a clustered environment and I use the File System for storing packages, then the pacakges must be stored on a shared volume, right?

4. I did not find SQL Server Integration services on the B- (Passive) node. Do I have to install it separately onto the B server (much like having to install the Client Tools)?

If anyone has some guidance or tips on running SSIS in this brave, new, wonderful world, I would sure appreciate it.

And yes, I am going to go out right now and order a new book on SSIS.

Regards,

hmscott

View Replies !

---

SSIS- I Can Not Save Big Packages
Hello,
When I try to save modifies in packages with many components the system show me a information dialog telling me that there was a System.OutOfMemoryException

Anyone knows how to solve this problem without divide the package in 2 or more packages?

View Replies !

---

Migrated DTS Packages To SSIS
I have migrated all of my DTS Packages into a Integration Service Project on my SQL Server. I'm lost as to how I can get these to show up under the SQL Server Management Studio. Any direction is appreciated.

Thanks,
J

View Replies !

---

SSIS Packages In SourceSafe
I've figured out how to store new SSIS projects in SourceSafe, but is there a way to configure an agent job to execute a package from SourceSafe, or do I have to maintain a copy outside? (Which doesn't seem to make sense...)

 

TIA

View Replies !

---

Copying SSIS Packages
Is there any way to copy SSIS packages from one mirrored server to another? I'm considering using robocopy, but is there another solution?  I'd then like to use this solution with the Transfer jobs task.

View Replies !

---

SSIS Packages And MaximumErrorCount
1st question:
 
1.  Create a new SSIS package
2. Add Script Task. Modify the script: Dts.TaskResult = Dts.Results.Failure
3. Run the package. Results into message:"Warning: The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors". This is expected behaviour.
4. Add another Script task after the 1st Script Task and connect the tasks using "Failure" type of precedence constraint.
5. Run the script. The message is identical. There are now two tasks that set return value to Failure. Shouldn't there be two erroneous tasks and shouldn't the message say something like:"... number of errors raised (2) reached the maximum allowed (1)..."?
 
2nd question:
 
The documentation of MaximumErrorCount-property of a SSIS package is:"The maximum number of errors that can occur before a container stops running. The default value of this property is 1". What does this mean precisely - what does the statement "container stops running" mean. Let's assume MaximumErrorCount=M=1. If there is one task that fails should the whole SSIS package stop running? And secondly, how is the total number of errors calculated, i.e. if it is some kind of counter, when is the counter incremented. This relates to my 1st question, in which I though the number of errors would be two, but it only was one.

View Replies !

---

Creating SSIS Packages In C#
How can I create a SSIS package using C#? Can anybody have source code for the same.

thanx in advance,

Vinod

View Replies !

---

Hosting SSIS Packages Where?
After i create a SSIS package, where can i put it or store it in the SQL SERVER 2005 so that i can execute it later on???

View Replies !

---

How Should You Document The SSIS Packages?
Well - we havent done it with DTS packages - but now that we are moving to SQL 2005 and SSIS & .Net (from SQL2K & asp) - it sounds to be as a good idea to document. How should I get started on creating documentation for SSIS packages?

View Replies !

---

Dts 2000 Packages With SSIS
I need help,

I've got 51 pretty complex Dts packages that are running on Sql 2000. I'm
trying to make them run on Sql 2005 without at first migrating them with the
migration wizard, since i know that many of them cannot be migrated.

I'm using the "Execute DTS 2000 Package Task Editor" to make them run in an
SSIS package, some of them are running fine, but many of them, especially
those with a "Data Driven Query Task" are returning this error:

Error: System.Runtime.InteropServices.COMException (0x80040427): Execution
was canceled by user. at DTS.PackageClass.Execute() at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Exec80PackageTask.ExecuteThread()

After many research on the web, i've reinstalled the Sql 2000 tools on the
Sql 2005 server, but i'm still receiving the same error. Also, i've tried to
repair the "Microsoft Sql Server 2005 backward compatibility" in the
Add/remove program of the Sql 2005 server without much success.

For your info, i've installed the hotfix Build 2153 on both the server and
the client and i'm still having the same problem......

Any idea?

Thanks.

View Replies !

---

Editing SSIS Packages
I have successfully created several SSIS packages in the Development Studio.  I want to schedule those packages to run with SQL Agent.  The only way I could schedule them was to go to File>Save copy as...(not save as) which would give me a choice of either to save it to SQL Server or SSIS Package Store.  Using this method allowed me to schedule the package but then I couldn't figure out how to edit the package without going back into the Development Studio, right-clicking on SSIS packages and selecting "Add Existing Package" and selecting that package from the SSIS Package store then opening it to edit.

That seems like a lot of work to edit a package.  Is that the desired way to create, save, schedule and edit a SSIS package?

Thanks for any help.

 

View Replies !

---

DtsBackup2000 For SSIS Packages??
hi everyone,

Up to moment I've been using Dtsbackup2000 for do backup for our DTS but now, which let's allow do the same with dtsx???

TIA

View Replies !

---

SSIS Packages In Registry?
I thought so but I'm looking for a couple of packages and I am not be able to find any there at all.

 

View Replies !

---

Multithreaded Run Of SSIS Packages
Is it safe to run several SSIS packages in parallel in a multithreaded application? The package objects are not accessed from multiple threads: every thread is handling its own package (see below).

void task_inside_thread()
{
 
 System::String ^s = "...";
 Microsoft::SqlServer::Dts::Runtime::Package p;
 p.LoadFromXML(s, nullptr);

  // callback handler
 MyEventsClass ^ eventsClass = gcnew MyEventsClass();

 DTSExecResult result = p.Execute(nullptr, nullptr, eventsClass, nullptr, nullptr);
 
 return;

}


Is there any relevant documentation with respect to this issue?

Thanks,

Bogdan

View Replies !

---

Making Changes To SSIS Packages
Hello,

I created a SSIS project with some SSIS packages within my local machine.  Once all development and testing stuff was finished I imported the same to SSIS package store within Integration services.  Then I created another test folder within my local machine and copied all the packages along with the project .sln file to that test folder. 

Now the problem, If I make any changes to the package within test folder it automatically saves the changes to my other folder.  Does anybody have a reason why it is doing so.

 

Thank You

Jatin

View Replies !

---

Triggering SSIS Packages
I am currently building an ASP.Net web app and implementing SQL Server 2005 for a project.  I was relying somewhat on kicking off SSIS packages from the web app, but I am not really sure how to do this. 

If anyone could help me out, I would really appreciate it.

View Replies !

---

Converting DTS Packages To SSIS
 

Guys,





I got this error while I try to migrate one of my dts packages from dts to ssis. Where do I start from?

The package is got 4 separate vb active x scripts in it and it is also calling four other packages. The package run successfully when I migrated from SQL 2000 DTS to SQL 2005 legacy DTS using 2000 runtime. But the problem is when I attempted to to migrate to SSIS using the package migration tool in sql server 2005.
The problem is I am a DBA but never have to create a DTS or SSIS from the scratch before...



Regards,
 



LogID=1

#Time=11:11

#Level=DTSMW_LOGLEVEL_WARN

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Not all the connections from SQL Server 2000 are migrated to the main SQL Server 2005 package. For example, Text (Source) and Text (Destination) are not migrated to the main package.



LogID=2

#Time=11:11

#Level=DTSMW_LOGLEVEL_WARN

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Not all tasks from SQL Server 2000 and SQL Server 7.0 are migrated to SQL Server 2005. For example, the migration of the Analysis Services Processing task and the Data Mining Prediction task is not supported.



LogID=3

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Finished migrating connections for package: Pub Extract Search Data



LogID=4

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSDynamicPropertiesTask task migration for package: Pub Extract Search Data



LogID=5

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSDynamicPropertiesTask task migration for package: Pub Extract Search Data



LogID=6

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSExecuteSQLTask task migration for package: Pub Extract Search Data



LogID=7

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSExecuteSQLTask task migration for package: Pub Extract Search Data



LogID=8

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSExecuteSQLTask task migration for package: Pub Extract Search Data



LogID=9

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSExecuteSQLTask task migration for package: Pub Extract Search Data



LogID=10

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSExecuteSQLTask task migration for package: Pub Extract Search Data



LogID=11

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSExecuteSQLTask task migration for package: Pub Extract Search Data



LogID=12

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSExecuteSQLTask task migration for package: Pub Extract Search Data



LogID=13

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSExecuteSQLTask task migration for package: Pub Extract Search Data



LogID=14

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSActiveScriptTask task migration for package: Pub Extract Search Data



LogID=15

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSActiveScriptTask task migration for package: Pub Extract Search Data



LogID=16

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSActiveScriptTask task migration for package: Pub Extract Search Data



LogID=17

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSActiveScriptTask task migration for package: Pub Extract Search Data



LogID=18

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSActiveScriptTask task migration for package: Pub Extract Search Data



LogID=19

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSActiveScriptTask task migration for package: Pub Extract Search Data



LogID=20

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Started DTSActiveScriptTask task migration for package: Pub Extract Search Data



LogID=21

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Completed DTSActiveScriptTask task migration for package: Pub Extract Search Data



LogID=22

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Finished migrating tasks for package: Pub Extract Search Data



LogID=23

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Finished migrating variables for the package: Pub Extract Search Data



LogID=24

#Time=11:11

#Level=DTSMW_LOGLEVEL_MSG

#Source=Microsoft.SqlServer.Dts.MigrationWizard.Framework.Framework

#Message=Successfully saved the package "Pub Extract Search Data" in the destination "ITEM-40561SQL_2005Pub Extract Search Data".

View Replies !

---

Dynamic SSIS Packages
 

Hello All,
 
I have 5 SSIS Packages out of which 1 is the parent package which calls the other 4 packages.
 
There are some database connections in my child packages.
 
Now, I want to make the packages dynamic.
 
I have two options.
 
1) Have all the connection information in the parent package and pass those values to the child packages. This way I'll be having only 1 configuration, the one for the Parent.
 
2) Have a separate configuration file for each package that will have all the connection related informations.

 
What is the better practice ?
 
Thanks & Regards,
Kapadia Shalin P.

View Replies !

---

Cannot Run SSIS Packages As A SQL Agent Job
We are just migrating to sql servr 2005. I have created ssis pkg that runs fine when run mnaulli under BI. However, when I setup the ssis pkg to run as a SQL job. It errors out. Err is listed below. Seems like it is running the job under the SQL Agent account which does not have permissions to access the server i am pulling data from. Can u assit.
 1984-2005. All rights reserved.    Started:  1:30:51 PM  Progress: 2008-02-22 13:30:57.55     Source: DTSTask_DTSDataPumpTask_1      Validating: 0% complete  End Progress  Error: 2008-02-22 13:30:58.33     Code: 0xC0202009     Source: Laser- Connection manager "FTWSQL"     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E4D.  An OLE DB record is available.  Source: "Microsoft OLE DB Provider for SQL Server"  Hresult: 0x80040E4D  Description: "Login failed for user 'CFC0SQLA'.".  End Error  Error: 2008-02-22 13:30:58.33     Code: 0xC020801C     Source: DTSTask_DTSDataPumpTask_1 OLE DB Source [1]     Description: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "FTWSQL" failed with error code 0xC0202009.  There m...  The package execution fa...  The step failed.

View Replies !

---