Unable To Save Already Created Package

Sep 28, 2000

I have about 100 DTS packages and they were created by a user who has left the company. Now I( the new user)am trying to open the packages from another client machine and trying to save them back. I am connecting to SQL server where the packages are stored using NT authentication(domain account).
When I try to save the package, I get the following error

Ole DB, Only the owner of the DTS package "packagename", or a member of the sysadmin role can create new versions of it".

What I have tried is that I can save the same package with a new name without being a member of the sysadmin role but I cannot save the package with the same name.
ANy help will be greatly appreciated.

View 2 Replies


ADVERTISEMENT

Save DTS Package Created In DTS Designer(SQL 2000) On SQL 2005 Under Legacy

May 13, 2008



Hi All,
One of my user was able create DTS package using DTS Wizard, working from his workstation and saved this DTS in Legacy(in Data Transaformation services) on different SQL 2005 EE SP 2(9.0.3042) production server..
At same time he has no access to msdb on this SQL 2005 server(he also not sysadmin for this server).. How this could happen..??

View 2 Replies View Related

Analysis :: How To Save Parameter From A Report Created In Browse View Under Cube

Nov 10, 2015

After connected to Analysis Services and following the path below:

Analysis Service - Databases - Cubes

I create the parameters for a custom report after right click on a specific Cube and select Browse to arrive at a view where i can define dimensions and parameters as well as drag and drop measure to the report rows and columns. The left top File bottom only give me a Save Selection or Save ALL option. However, i'm not sure where it saves it to or if it saves the settings for this custom report at all.

I pull this report monthly and it's a pain to recreate all the parameters. How to save this template for future pulls or maybe even incorporate the pull into excel for monthly refresh instead?

View 3 Replies View Related

Unable To Login To Database Created By Admin

Oct 12, 2007

Using SQL Server 2005 under XP Professional.  I am attempting to log into the Server Management Studio as "UserX".  I had previously been using Server Management while logged in as admin.
 I now get this error message when attempting to connect to the database server:
 **********************************************************************TITLE: Connect to Server------------------------------Cannot connect to [**NAME OF SERVER**].------------------------------ADDITIONAL INFORMATION:Login failed for user '[**NAME OF SERVER**].UserX. (Microsoft SQL Server, Error: 18456)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476------------------------------BUTTONS:OK------------------------------
*******************************
 Microsoft help doesn't have a specific help for that particular error message.  Any hints as to what is going wrong?

View 4 Replies View Related

Commit Transaction Gets Deleted - Unable To Save SP

Jan 24, 2006

I've re-written a stored procedure and when I post the following codeinto the existing SP in EM, is saves OK. However, when I re-edit theSP, the last line 'Commit Transaction' has been removed.I cannot save the remainder of the SP as it throws error 208 (InvalidObject name #Max) about two of the temp tables I use when I post theentire script. It shows in a message box with the header : 'MicrosoftSQL-DMO(ODBC SQLState:42S02)I haven't posted the full SP nor the structure as it's quite large(2000 lines), so hopefully I have given enough detail, but my questionsare :Why does it now have problems with (temp) #Tables ? The use of thesehas not changed. All I have done is wrap the script into varioustransactions as this helps a lot for performance and tweaked a fewparts later in the SP again for performance.Also, why does the line get removed once I save the SP ?If I run this in QA, I get the same errors, so I suspect it's myscript, but don't know where I'm going wrong.SQL2000 (Need to upgrade the service pack as recently installed on myPC, so this may help)Thanks in advanceRyanCREATE PROCEDURE [dbo].[JAG_Extract] (@ExtractYear INTEGER,@ExtractMonth INTEGER) ASBEGIN TRANSACTIONSELECT 0 AS MaxYear, 0 AS MaxMonth INTO #MaxUPDATE #Max SET MaxYear = @ExtractYearUPDATE #Max SET MaxMonth = @ExtractMonthPRINT 'Stage 1 - ' + Convert(VarChar, GetDate())CREATE TABLE #Extract ([DEALER_SOURCE_DATA_ID] INT,[DSD_YEAR] INT NULL,[DSD_MONTH] INT NULL,[DEALER_CODE] VarChar(20),[FranDealerCode] VarChar(20) NULL,[Line_No] VarChar(75),[Current] [numeric](15, 5) NULL,[YTD] [numeric](15, 5) NULL,[12Months] [numeric](15, 5) NULL,[24Months] [numeric](15, 5) NULL,[Average_YTD] [numeric](15, 5) NULL,[Average12Months] [numeric](15, 5) NULL,[Average24Months] [numeric](15, 5) NULL,[Last_YTD] [numeric](15, 5) NULL,[Current_STATUS] INT,[PD1] [numeric](15, 5) NULL,[PD2] [numeric](15, 5) NULL,[PD3] [numeric](15, 5) NULL,[PD4] [numeric](15, 5) NULL,[PD5] [numeric](15, 5) NULL,[PD6] [numeric](15, 5) NULL,[PD7] [numeric](15, 5) NULL,[PD8] [numeric](15, 5) NULL,[PD9] [numeric](15, 5) NULL,[PD10] [numeric](15, 5) NULL,[PD11] [numeric](15, 5) NULL,[PD12] [numeric](15, 5) NULL,[PD13] [numeric](15, 5) NULL,[PD14] [numeric](15, 5) NULL,[PD15] [numeric](15, 5) NULL,[PD16] [numeric](15, 5) NULL,[PD17] [numeric](15, 5) NULL,[PD18] [numeric](15, 5) NULL,[PD19] [numeric](15, 5) NULL,[PD20] [numeric](15, 5) NULL,[PD21] [numeric](15, 5) NULL,[PD22] [numeric](15, 5) NULL,[PD23] [numeric](15, 5) NULL,[PD24] [numeric](15, 5) NULL,[PD25] [numeric](15, 5) NULL,[PD26] [numeric](15, 5) NULL,[PD27] [numeric](15, 5) NULL,[PD28] [numeric](15, 5) NULL,[PD29] [numeric](15, 5) NULL,[PD30] [numeric](15, 5) NULL,[PD31] [numeric](15, 5) NULL,[PD32] [numeric](15, 5) NULL,[PD33] [numeric](15, 5) NULL,[PD34] [numeric](15, 5) NULL,[PD35] [numeric](15, 5) NULL,[PD36] [numeric](15, 5) NULL)INSERT INTO #ExtractSELECT DISTINCTSD.DEALER_SOURCE_DATA_ID,SD.DSD_YEAR,SD.DSD_MONTH,DN.DEALER_CODE,DN.FRAN_DEALER_CODE,DV.FIELD_CODE,0,0,0,0,0,0,0,0,SD.STATUS,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0FROMDEALER_NAW DN WITH (NOLOCK)INNER JOIN DEALER_SOURCE_DATA SD WITH (NOLOCK)ON DN.DEALER_CODE = SD.DEALER_CODEINNER JOIN DEALER_SOURCE_DATA_VALUES_Current DV WITH (NOLOCK)ON SD.DEALER_SOURCE_DATA_ID = DV.DEALER_SOURCE_DATA_IDAND SD.STATUS < 4096INNER JOIN DEALER_FIXED_GROUP_RELATION GR WITH (NOLOCK)ON DN.DEALER_CODE = GR.DEALER_CODEAND GR.FIXED_GROUP_ID IN(11,12,13,14,15,16,17,18,23,42,43,44,45,46,47,48,4 9,50,51,52,53,54,55,56,57,58,59,60,61,106,109,110,111,1 12,113,114,115,130,131,132,133,134,135,136,137)GOCOMMIT TRANSACTION

View 2 Replies View Related

DB Design :: Unable To Save Foreign Keys

Sep 4, 2015

I'm trying to setup my foreign keys so I can use them in a VisualStudio projects but I'm getting an error and I can't track down what's causing it.

'tbl_departments' table saved successfully
'tbl_people' table saved successfully
'tbl_locations' table saved successfully
'tbl_position' table
- Unable to create relationship 'FK_tbl_position_tbl_departments'.  

The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_tbl_position_tbl_departments". The conflict occurred in database "MyProjectDB", table "dbo.tbl_departments", column 'ID'. All of my tables have an ID field that is a primary key with Allow Null unchecked.

View 3 Replies View Related

Created View With Join Query - Unable To Fetch Details

Feb 12, 2014

I created a view with a simple join query

there are 2 rows with orderid as null, i am unable to fetch the details when i give WHERE Condition as

"select orderid from joins where orderid=NULL"

Query :

create view joins as
select A.customerid,A.Companyname,A.Contactname,A.City,B.OrderId from Customers A
left join orders B
on A.Customerid=B.Customerid

View 1 Replies View Related

SQL Tools :: Unable To Save A Maintenance Plan In 2005 / Class Not Registered

Nov 2, 2015

Unable to save a maintenance plan in sql server 2005, SP3. Error is class not registered.

View 2 Replies View Related

Error Creating Package - Failed To Save Package File ... Emp EmpD4B.tmp With Error 0x80040154 Class Not Registered

May 19, 2006

I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.

Following is the text of the error details:

TITLE: Microsoft Visual Studio
------------------------------

Error creating package

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

Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".


------------------------------

Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".


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

OK
------------------------------
I found a similar post that suggested that they try the following:


regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll

But msxml6.dll could not be found.

I did get a copy of this file from a coworker, and after copying it and registering it, I was able to add a package to the project.

My concern now is what is the likelyhood of this being the only file missing from the installation.

I'm wondering if I should reinstall, or (if it exists) do a repair on the installation.

Thanks.

Marshall

View 12 Replies View Related

Integration Services :: Unable To Load Package As XML Because Of Package Does Not Have Valid XML Format

May 11, 2015

i have created one package in production server called User_Import,It will fetch the info from excel file to the Sql  table, I have executed this package in ssis console successfully,But i have to schedule one job using this package on daily basis for that i have created on sql job using this package, Then it is failing i dont know the exact problem,I have full access to my database and full access to the sql agent to exuete any jobs,I have sharing the error message which am getting in the sql agent level, Please find the error msg:

05/11/2015 15:10:20,User_Imports,Error,1,SFRFIDCSCDB003PSQCM03,User_Imports,AD_User Load,,Executed as user: SFRSA-SFR-SQCM-02. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.1600.1 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  15:10:20  Error: 2015-05-11 15:10:20.41     Code: 0xC0011007     Source: {8E9D75BC-AA22-4366-9AC5-1507DA7AB21B}  

Description: Unable to load the package as XML because of package does not have a valid XML format. A specific XML parser error will be posted. End Error  Error: 2015-05-11 15:10:20.41     Code: 0xC0011002     Source: {8E9D75BC-AA22-4366-9AC5-1507DA7AB21B}

Description: Failed to open package file "C:UserssccmadminDocumentsVisual Studio 2008ProjectsUser_ImportsUser_ImportsUser_Imports.dtsx" due to error 0x80070005 "Access is denied.".  This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.  End Error  Could not load package "C:UserssccmadminDocumentsVisual Studio 2008ProjectsUser_ ImportsUser_ ImportsUser_ Imports.dtsx" because of error 0xC0011002.  

Description: Failed to open package file "C:Userssccmadmin DocumentsVisual Studio 2008 Projects

User_ImportsUser_ImportsUser_Imports.dtsx" due to error 0x80070005 "Access is denied.".  This happens when loading a package and the file cannot be opened or loaded correctly into the XML document. This can be the result of either providing an incorrect file name was specified when calling LoadPackage or the XML file was specified and has an incorrect format.  Source: {8E9D75BC-AA22-4366-9AC5-1507DA7AB21B}  Started:  15:10:20  Finished: 15:10:20  Elapsed:  0.015 seconds. The package could not be found.  The step failed.,00:00:00,0,0,,,,0

View 4 Replies View Related

Where Is The Package I Just Created?

Jul 19, 2007

I loaded the import/export wizard into my Tools menu. I ran it and exported a view to an excel worksheet with mixed results (I got the headings, but no data). I want to take a look at the package that should have been created (I selected that option, but the export didn't complete and I couldn't decipher the log to determine whether the package was created).
If it was successfully created, where would I find it in SQL 2005 Express?

Thanks,

Bill

View 12 Replies View Related

I Just Created My First SSIS Package

Jun 27, 2007

Hi,



I just created my first SSIS package.



For now, I can only run it inside Visual Studio.



I want this packet to be run every day as a scheduled task. How do I do that?



When I double click my .dtsx I get an Execute Package Utility. Where can I set my package to run every day at certain time?



Thank you.

View 4 Replies View Related

How Save A DTS Package On SQL Server?

May 16, 2002

Hi all,
When I try to save a DTS package on SQL Server(local),I have a error message "refused acces" ,T don't know what's the problem?

Any help will be appreciate?
thanks in advance

View 3 Replies View Related

How To Save DTS Package As An Application

Sep 29, 2005

Hi,I want create stand alone application from DTS package. I remember Idid one time ago, I couldnt recall how I did it.Thanks.

View 4 Replies View Related

Trying To Save Package To Sql Server

Jan 24, 2007

When I try to save a package to sql server with the delpoyment manifest I got this error



TITLE: Package Installation Wizard
------------------------------

Could not save the package "C:copiaPackage.dtsx" to SQL Server "ATLANTE".

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

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.


------------------------------

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.


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

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


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

Could not save the package "C:copiaPackage.dtsx" to SQL Server "ATLANTE". (Package Installation Wizard)

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

The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.


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

at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)
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 SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Client unable to establish connection). The SQL statement that was issued has failed.


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

at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.SaveToSQLServer(IDTSPackage90 Package, IDTSEvents90 pEvents, String ServerName, String ServerUserName, String ServerPassword)
at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServer(Package package, IDTSEvents events, String serverName, String serverUserName, String serverPassword)

View 4 Replies View Related

Save DTS Package To File?

Jan 7, 2008

I have a server with MSDE 2000 installed onto it. I also installed SQLEXPR_TOOLKIT.EXE . Now there is a DTS package present on that server saved in the DB. How can I alter that package? And if that's not possible: how can I save the package to a file so I can transfer that file to my development machine?

Thanks in advance,

Stijn Verrept.

View 3 Replies View Related

Execute A Dts Package From A Newly Created JOB

Feb 17, 2000

I am trying to execute three dts packages from a Job that I created. When creating the steps I am setting the Type To: Operating System Command(CmdExec).

The Command I am using is: dtsrun /S servername /E /dtsPackageName

For some reason whenever I try to run thes jobs it fails. Within this Job I have three steps. For each step I am using the same job but with a different package name. I have a trusted connection so my command should work just fine. What am I doing wrong. Can some please explain this process.

Thanks

View 1 Replies View Related

Can't Edit A Package Created With Wizard

Mar 12, 2008

I was working on a flat file import spec yesterday, using the import wizard, and I saved my work as a SSIS package. Today, if I connect to Integration Services through SQL Management Studio, I can see the package, but I can't edit it. I've tried to open the package using BIDS, but I can't find it on the server. Obviously it exists, but where?

How the heck can I edit this package? And, where is it? I don't understand why things are so much more difficult in 2005 vs. 2000.

Thanks.


View 4 Replies View Related

Not Able To Save Existing DTS Package In Sqlserver2000

Jun 19, 2007

Hi
I have a dts package created by different user. Now If i want to modify and save the dts package it wont allow me to do that.
I get error message.
"Only onwner of DTS package "PackageName" or a member of sysadmin role can save the package".

I can do save as with different name. But i want to use the same package.
Please help

Thanks
Hassan

View 2 Replies View Related

Failed To Save Package File

Sep 13, 2007

I am just beginning to work on an ETL project at a new client site using their computers. They are an IT department new to SQL Server. We have SQL Server 2005 up and running, no probkem. But I get that error when I try to add a new package to an SSIS project. The error number is 0x8002801D "Library Not Registered". I did see the post about the MSXML DLL files and when I try to load an existing package I get 3 errors regarding XML - stating that the MSXML binaries may not be installed or registered properly. I searched and found the MSXML3 & 6 DLLs but the MSXML4.DLL appears to be missing. If I repair the installation, will this fix it? BTW - the MSXML 6.0 Parser did show as being installed in Add/Remove Programs.

Thanks for you help!

View 6 Replies View Related

Where/how Do I Save My Ssis Package Into Sql Server ?

May 10, 2007

So now ive got a ssis project that works and does what i need it to. How do I save the package into sql server ?

View 4 Replies View Related

How To Get Rowcount In A Programatically Created SSIS Package

Oct 22, 2007

Hi,

I created a SSIS Package programatically based on the few threads here in this forum. This package just has a data flow task, during data transfer for every 1000 rows or so I want to update the status in a table in the database.

How do I achieve this?

As of now I just have a source and a destination, no transformations in between the flow. I'm not sure if rowcount will help, when I tried it using a onprogress even handler it always showed up as zero.

Thanks

View 6 Replies View Related

The Package Contains Two Objects With The Duplicate Name - Package Created In UI - Duplicate Columns

Aug 17, 2007

I've begun to get the above error from my package. The error message refers to two output columns.



Anyone know how this could happen from within the Visual Studio 2005 UI? I've seen the other posts on this subject, and they all seemed to be creating the packages in code.

Is there any way to see all of the columns in the data flow? Or is there any other way to find out which columns it's referring to?
Thanks!

View 3 Replies View Related

Can't Save Or Compile Package (insufficient Memory)

May 7, 2007

When I compile or save a SSiS package in the SQL Server Business Intelligence Development Studio I get the error

Failure saving package. (Microsoft Visual Studio)

Insufficient memory to continue the execution of the program.



Sometimes, if I wait longer time, the package can suddenly be saved.



I have 2 GB of RAM und over 15 GB of free space on my disk. Thus, there should be anough space to save the package.



What should I do to resolve this problem? It seems to be a bug.



To splitt the package would not be a solution.

View 1 Replies View Related

Can't Save Package To Server (No Description Found)

Nov 8, 2005

I'm getting an error, "No description found", when trying to save my package to the SQL Server (2005).

View 4 Replies View Related

Save Copy Of Package Option Missing

Mar 5, 2008

On my workstation the option is there, but on a couple other workstations that option is not available from the file menu. I tested doing the exact same thing and the option just isn't there. Anyone have any idea's?

View 3 Replies View Related

Update Package To Save New Property Values

Jan 4, 2007

Hi,

using custom tasks. My properties got saved properly the first time the task is added to the workspace. After that, changing values in the CustomUI updates the properties, but the package shows, that It doesn't need to get saved. So my properties don't get changed in the package XML. Moving my custom task on the workspace after changing properties, let the package go into "save me" state and my propertiy values get saved to XML.

So now, Im searching for a method or property I have to call or set to show the package it needs to get saved after closing my CustomUI.

Any hint?

Thanks

 

PS: When I change the property value in the task properties grid (lower right). The package gets notified about the need to get saved.

View 11 Replies View Related

What Are To Be Installed At The Production Unit To Deploy A Package Created ?

Nov 14, 2006

Hi friends,

Can anybody tell what all are required for the deployment of a package.

I read from some article that to deploy ur package SSIS runtime and .Net framework should be installed first

and 1)it is not necessary to install sql server 2005. if so Is it True .?

2)whether the ssis runtime is freely available as independent installation package like .Net framework





View 5 Replies View Related

How To Add SQL Statements To The Package Created By Export Data Wizard?

Jan 14, 2006

How to add SQl statements to the package created by Export Data wizard? I need to add SQL coming from file, the flow would be like this:

1) SQL would drop all objects: (views, tables, stored procedures) etc

2)  SQL would create all objects: (views, tables, stored procedures) etc

3) Export Wizard SSIS package would execute

Also is there a dynamic way to add more tables do the package once created in SQL database? I would like to put the whole task on a scheduler too...

View 6 Replies View Related

Can't Save Package To Server (No Description Found) ERROR - Again

Dec 31, 2005

Hello, I need some help with installing release copies of SQL05(+SSIS) and VS05 on Win03R2.  It is very frustrating when a basic install fails. I€™ve been going round and round with this.  M$ support has not been of help yet.


I have a new development box for SQL05/VS05 development, and when I do a clean install of release software from MSDN: Windows Server 2003 R2 ent; SQL Server 2005 dev; Visual Studio 2005 pro I find that the "save to server" in SSIS (and other utilities that save a package) fails with a non-informative message *No Description Found* (see error text below).


To setup this box I install Win03R2 first, promote it to a Active Directory DC (the one and only DC in a test forest), then install VS05 onto the E: drive.  Note, I must install VS05 first (before SQL05) so that all components get installed to the RAID5 *E:* drive.  If SQL05 is installed first then VS that comes with SQL gets installed on to C: (no way I see to get around this) then the full VS05 pro gets forced to install on the C: drive.


Then I install SQL05 (with everything including SSIS).  At this point every thing works fine, packages can be saved ok.


If I then install VS05 again so that all settings of VS05 are as expected of a standard VS05 install (not the SQL version) then the problem with saving packages arises.


If the error message was a little more informative, I might be able to track down the source of the problem.  Please help!  I have tried a bunch of things - creating credentials, proxies, using the most privileged accounts possible, etc.


Thanks, MikeC

 

Error from create SSIS package (save to server):
===================================

No description found (Microsoft Visual Studio)
------------------------------
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.DataTransformationServices.Design.Controls.PackageSaveCopyForm.PackageSaveCopyForm_FormClosing(Object sender, FormClosingEventArgs e)

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


Error from copy db wizard:
===================================

No description found (Copy Database Wizard)
------------------------------
Program Location: at Microsoft.SqlServer.Dts.Runtime.Application.SaveToSqlServerAs(Package package, IDTSEvents events, String packagePath, String serverName, String
serverUserName, String serverPassword) at Microsoft.SqlServer.Management.CopyDatabaseWizard.PackageCreator.SavePackage()

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

View 3 Replies View Related

Can SSIS Save The Context Of Errors At The Package Level?

Feb 20, 2007

Lately, I have been experimenting with SSIS and I created a generic custom error logging component that saves all offending data on data flow component failure. However...

Instead of re-directing rows at the data flow level and handling/logging the data at that level, is it possible to catch all of this information at the package level and handle/process it there?

If so how would you do this?

Thanks!
Tony

View 13 Replies View Related

Save SSIS Package On SQL Server Using Windows Authentication

May 27, 2008

I am creating SSIS packages on the fly using C#.net. I need to save SSIS packages on a SQL Server using windows authentication. I have found a way to save the package using SQL authentication Microsoft.SqlServer.Dts.Runtime.Application .SaveToSqlServer(Package pkg,IDTSEvents evts,string serverName,string serverUserName,string serverPassword)

Can you give me a solution for saving SSIS packages using windows authentication, as it is a must in my project.

View 3 Replies View Related

Processing Last Created/modified Files From A Location Using SSIS Package

Mar 12, 2008

We have a scenario to process last created/modified files from a location using SSIS package , eventhough the folder contains multiple files with same name and extension.

Kindly give respond to this if any one has worked on this.

Regards,
Sajesh

View 7 Replies View Related







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