Integration Services In SSMS

Jul 12, 2007

We use Windows Authentication to connect to SQL Server, is there any special permissions required to connect to Integration Services in SSMS?

Whenever I try to browse the servers available with Integration Services (from Object Browser), none of the servers gets listed. If I directly give server name and try to connect to Integeration Services I get the following error. But I'm able to connect to the database engine.

TITLE: Connect to Server
------------------------------

Cannot connect to <servername>.

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

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

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

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

Connect to SSIS Service on machine "<servername>" failed:
Access is denied.

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

Connect to SSIS Service on machine "<servername>" failed:
Access is denied.

Thanks

View 5 Replies


ADVERTISEMENT

Integration Services :: Restore Cube In SSMS

Aug 26, 2015

I have a cube that I cant restore in my SQL server management studio.

How to resolve it?? What are the steps to be done?

View 6 Replies View Related

Integration Services :: SSIS - Can't Connect Using SSMS Remote (locally OK)

May 18, 2015

Error: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA) (Microsoft.SqlServer.DTSRuntimeWrap)
 
Here are the steps I followed:

To configure rights for remote users on Windows Server 2003 or Windows XP

View 10 Replies View Related

Integration Services :: Login To SSMS Got Access Denied Error

Sep 9, 2015

When I try to connect to "Integration services" in "SSMS" with my window authentication, for some servers can able to connect. But for some server i am getting error like "Access denied".

To fix these Access Denied, as per instruction from google, i have configured the Administrative Tools-->Component Services->Component Services-->Computer-->My Computer-->DCOM Config-> Microsoft SQL Server Integration Services 11.0--> Right
Click-->Properties-->navigate to “Security”--> then adding the Active direcotry login in the "Launch and Activation Permissions", "Access Permissions" and "Configuration Permissions".

Then this issue was fixed. I want to know why this was happening to some servers only, what is the reason behind this.

View 5 Replies View Related

Integration Services :: Connect SharePoint List View To SSMS

Aug 31, 2015

I need to install SSIS/SSRS in SSMS. I have connected the SharePoint list view to excel for reporting purpose but due to data size the performances is very slow in excel and now I would like to connect the SharePoint List to SSIS/SSRS

I have windows 8, 64 bit system

I have installed SQL Server Management studio 2012 but I am unable to enable the Integration and Reporting Services

May be I have missed to choose the option during installation.

View 5 Replies View Related

Integration Services :: Cannot See Catalogs Node In Management Studio (SSMS)

Oct 12, 2015

I wanted to create a SSIS catalog and the way to create a catalog is to right click on "Integration Services Catalogs" node and select "Create Catalog" option.

However, I am not able to see the "Integration Services Catalogs" node in SQL Server Management Studio (SSMS) as shown in the following image.

What is missing so that I can see this node in SSMS?

FYI, I have SQL Server 2014 (Developer edition) and Integration Services 12.0 installed on my machine.

ProductVersion = 12.0.2269.0 (SELECT
SERVERPROPERTY('productversion') AS ProductVersion)

View 6 Replies View Related

Integration Services :: Run Master Package Containing Multiple Packages From SSMS Agent?

Jun 18, 2015

I have a MASTER package containing multiple packages using execute package task in SSIS.When am running  this MASTER Package in Sql server agent in SSMS, am getting error as below.

steps how to run this and let me know what information am missing to run the Master package.

ERROR :Failed to decrypt protected XML node “DTS: Password” with error 0x8009000B “Keynot valid for use in specified state”. You may not be authorized to access this information.

This error occurs when there is cryptographic error. Verify that the correct key is available. 

View 2 Replies View Related

Integration Services :: SP Runs Fine In SSMS But Failed In Execute Task / All Parameters Checked Ok

Jul 30, 2015

There is one SP with parameters varchar, int, varchar and int. It runs perfect in SSMS. Now, I've moved into a Execute SQL task with four IN parameters. In parameter mapping, data type is varchar, long, varchar, long and parameter name is 0,1,2,3. It worked before which is great. Today, I opened this pkg for another testing but failed with the following error:failed with the following error: "Incorrect syntax near ';'.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly,parameters not set correctly, or connection not established correctly.

I know SP is fine as tested in SSMS.  I could not understand where it could go wrong in the ssis package. Currently using Reporting Service 2000; Visual Studio .NET 2003; Visual Source Safe SSIS 2008 SSAS 2008, SVN --

View 12 Replies View Related

Integration Services :: Can't Import Excel 2013 Using SSMS Import Wizard (2008 R2)

Jul 29, 2015

I am trying to import an xlsx spreadsheet into a sql 2008 r2 database using the SSMS Import Wizard.  When pointed to the spreadsheet ("choose a data source")  the Import Wizard returns this error:

"The operation could not be completed" The Microsoft ACE.OLEDB.12.0 provider is not registered on the local machine (System.Data)

How can I address that issue? (e.g. Where is this provider and how do I install it?)

View 2 Replies View Related

SSIS And SSMS Backup Wizard Integration Needed

Aug 15, 2006

I created a Backup plan using the SSMS Maintenance Wizard. It created an SSIS package for me but the package didn't delete files older than, say, 3 days. So I exported that package from MSDB, added a Script task to it (to do what I needed), and imported it back into MSDB. I can open the new package under SSMS and everything looked good ... until I double-clicked the Script task. That task is simply not supported under the SSMS Maintenance Wizard. Goin in and out of that task under SSMS gave me the following errors:

"Microsoft Visual Studio Macros: The operation could not be compelted. Call was rejected by callee.".

Or the ever popular "cannot show the editor for this task'.

I was asked to "Wait for Completion" or "Switch tasks or "Cancel".

It seems the only way to delete these files is to set up a seperate SSIS job that calls my Script task sometime after the nightly backup has completed. But now the completion of the Backup job and the file deletion processes are decoupled, which is not very good. Can you offer any ideas how to handle the gracefully? (The real problem is that the SSMS Maintenance wizard does not recognize the full set of SSIS tasks. It would be nice if double-clicking on the Maintenance plan pane opened up the SSIS editor but that's for a later day.)



TIA,

barkingdog

View 2 Replies View Related

SQL 2012 :: Can't Connect To Reporting Services From SSMS

Nov 17, 2014

I am working with SSRS. I do have admin rights. I can connect to the url https://localhost/Reports and can create the new reports and subscription. Delete the reports and subscriptions.

But when I tried to connect to Reporting Services from SSMS, I am getting below error.

I used the windows authentication. It is showing that the user name or password is not valid or you don't have permission to access this server

I can connect to the database engine and Integration services but unable to connect to the Reporting services.

View 4 Replies View Related

User Un-able To Connect To Integrated Services Within SSMS

Apr 17, 2008


Hi,
I am able to run an SSIS script from BI Visual Studio no problem, I am also able to connect to SSIS within SSMS successfully. I have system access rights to the Database Engine of the same server name.

However I have a user who also has full system access rights to the Database Engine of the same server name. However he can only connect to the database engine, he cannot connect to SSIS within SSMS, but he can successfully execute a SSIS script within BI Visual Studio which is targeted to the same server name which he cant connect to within SSMS.

Any help would be greatly appreciated.

Kind Regards,

Kieran.

View 5 Replies View Related

How To Optimize Integration Pacakages Or Best Practices For Integration Services

Sep 11, 2007

Hello friends.
I managed to design an Integration service package,but the desired level of performance has not been achieved(i.e it is performing slow).
So I want to know what are the best practices for optimized solution .
In my package I'm exreacting data from XML file and Storing it in SQL server database with some processing dring data flow.

I'm using
1) Two Script Task Control -In these control,I m opening the connection to XML file through VB.net code and
iterating each record at a time.
2)Two OLE DB Command -Each fetched record from script task component is processed in OLEDB command through
stored procedure and then inseted into database.
3)One for Loop -This loop contains two script Task control and two OLEDB Command control,
(mentioned above),for fetching single record and inserting it in database.
4)One derived Column
5)One Multicast
6)One Character Map
7)One OlEDB Source

As with my current performance I'm able to insert one record in every .5 second (Which is much below to acceptable limits)
Is control lying disabled on SSIS designer pane also affect the performance of execution.

View 4 Replies View Related

Making Inegration Services Visible/available In SSMS 2005

Jan 28, 2007

I have installed SQL Server Management Studio 2005 and have beenfinding the equivalent of the Data Transfer Services in SQLServer2000. I think I have worked out that it is in SQL Server IntegrationServices but when I open File-New-Project I do not see the SQL ServerIntegration Services there, though Help assumes that it is availablefor selection when starting a new project..How can I make it visible in the New Project window?I have successfully used the import function so I think this meansthat Inegration Services is there somewhere.I would appreciate some advice,Best wishes, John Morgan

View 3 Replies View Related

Reporting Services :: SSRS Properties Greyed Out In SSMS On Windows 2008

Oct 17, 2008

Have installed SQL 2008 on Windows 2008 and have come across a strange issue.
 
When connecting to the Report Server cvia SSMS to enable "My Reports" (for example) the Report Server Properties are greyed out and we cannot alter them. This occurs when logged on both locally & remotely to the Win 2008 server.
 
Interestingly, we have another (XP Pro) box with SQL 2008 on it. If we connect to the Win 2008 SQL report server from the XP machine's SSMS, then we have full control and can access and change the report server properties on the Win 2008 server. 
 
The relevant domain accounts are in the Admin group on the Win 2008 server and the XP Server so we are confused as to why we cannot edit the Win 2008 report server properties locally.

View 5 Replies View Related

SQL 2005 SP2 Reporting Services And Window SharePoint Services V3 Integration Config Issue

Mar 23, 2007

Hi,
I have just install SQL 2005 SP2 and trying to get Window SharePoint Services V3 integrated with SQL 2005 SP2 reporting services.
In SharePoint Central Administration, I select the Reporting Services Integration page and have setup the Report Server Web Service URL and Authentication Mode. I then goto Grant database access, specify the SQL server name, get promted for a username and password that has access SQL Reportserver and get the following error "The group name could not be found"
Does anyone have any ideas?
Thanks

View 5 Replies View Related

Analysis Services 2005 Database Processing Fails When Run From Integration Services

Oct 11, 2007

Hello, I have a problem when trying to fully process an SSAS database using Integration Services "Analysis Services Processing Task" task. I have 2 of these tasks which are responsible for processing the Dimensions then the Cubes. When I run the package either via the BIDS environment or on the local server from the Integration Services engine, I will get an error after about 20 minutes stating:

"Error: Memory Error: Allocation failure. Not enough storage is available to process this command""Error: Errors in the metadata manager. An error occurred when loading the <cube name> cube from the file \?D:Program FilesMicrosoft SQL ServerMSSQL.2OLAPDataMyWarehouse<cube file>.xml"

The cube name is not specific, it will fail and any of my cubes could be in the error log

If I fully process the AS database using the AS engine (logon to local AS server, right-click AS database and click Process), I get no errors at all, it processes and completes fine. The processing options are identical when I run in AS or via the SSIS "Analysis Services Processing Task" task.

I've searched quite a lot online but no joy, the information I have gleaned from various sites does not directly link SSIS with SSAS processing problems.

When either the AS processing starts via SSAS or SSIS the memory usage of MSMDSRV.exe increases to around 1.4 / 1.5 GB but never goes to 2GB ever, even when the error appears.

I've done the following with no effect.

" Have run via AS and works fine
" No specific cube it fails on
" Have created a Dimension only package, same problem
" Changed the maxmemorylimit
" Changed the connections to localhost
" Memory DOES NOT max out on server

Server Specs:
Windows Server 2003 Standard + Service Pack 2
4GM ram, 2GB paging file

SQL Server 2005 + Service Pack 2


Can anyone help?

Andy

View 2 Replies View Related

Integration Services Notification Services

Apr 18, 2007

Does anybody know of a notification services using SSIS? Is it SendMail or otherwise? Is there a step-by-step practice on how to create one?

View 19 Replies View Related

Integration Services

May 24, 2007

Is there a way to give customers access to SSIS? They need to be able to create their own SSIS packages. Of course we have more then one customer so it would be nice to have modular security in place where they don't get to see customers abc and customer xyz packages. Only their own.
 
thanks!

View 6 Replies View Related

Help With Integration Services !!!

May 8, 2008

Hi All,

I have created an integration services project (attached is a screenshot) that workes against the flat file (.DAT extension) and it does some manipluation in the data and then load it into the table. Everything works fine.
Now I want to get the name of my flat file source fille (which is a .DAT file) and then insert it in the table.
I am running th integration services against different .DAT files (only one file at one time) which are located on different locations.....so what I want is that, whenever I run the package it do the usuall processing and then while loading the data in to the destination table, it also load the name of the file into the destination table (lets called a field "FileName" of nvarchar type in the table "Comphistory")

How can I achieve this?

I am looking for a quick and easy help.

Thanks,

Zee

View 4 Replies View Related

BUG In Integration Services

Jul 25, 2007

Problem
When you have a SSIS package that contains a connection from a data source, this connection is not updated when the data source changes based on a configuration change.

Situation :
A SSIS solution contains 3 configurations : Development, Test, Production. You can create those configurations in configuration manager of the solution.

The SSIS project contains one Data source. It doesn't really matter what type but I take SQL Server. The database server in development is SQL_DEV, in test is SQL_TEST and in production is SQL_PROD. Initially they are for all configurations the same. You can specify those values by changing the active configuration and then editing the Data source.

In the SSIS package (DTSX), you can create a connection manager based on a Data source.
If you change the Data source, the connection manager is also changed. If you change the Data source by changing the active configuration, the connection manager is not being updated.

If you think this isn't a big issue think big. We have 4 configuration, 10 shared Data sources and 25 DTSX packages. That would give a maximum of 1000 settings (4 x 10 x 25). Using this method it can be reduced to 40 (4 x 10). Of course this is a theoretical but it is very common to have the destination data source re-used on all packages, which still would be 100 settings (4 x 25)


Steps to reproduce
- create a new SSIS project
- In the solution explorer, create a new Data source named TestSource.
- In the connection managers window of Package.dtsx, create a new connection from a Data source.
- Make some changes in to TestSource.ds under the Data Sources. For example change the server or the database.
- Verify that those changes are also in the package.

- in the solution explorer, right click the solution and select configuration manager
- under active solution configuration, create a new configuration named test.
- Set the copy settings from : development
- Verify that Create new project configuration is checked.
- click OK and close.
- Notice that the active configuration is now Test
- Make some changes the Testsource.ds like a different server.
- Verify that those changes are also in the package.
- Make the development configuration as active.
- Notice that the Testsource.ds contains now the original settings.
- You will notice that the connection manager still contains the "test" settings and not the development settings.
- If you create a deployment utility it will still contains the wrong values.

with regards,

Constantijn Enders

View 1 Replies View Related

Integration Services

Jun 16, 2006

Hi all,

Can someone explain to me why I am getting this kind of error though I am able to integrate all the data succeesfully to the next destination.



Ronald







SSIS package "Prescription.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.

Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.

Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.

Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.

Error: 0xC0202009 at Data Flow Task, SQL Server Destination [521]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 58, column 1. The destination column (PatientId) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 27, column 12. The destination column (ServiceId) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 26, column 12. The destination column (ServiceId) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 25, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 24, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 23, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 22, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 21, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 20, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.

Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.

View 3 Replies View Related

Integration Services?

Apr 25, 2006

Hi,

is Integration Services included in SQL Server Express?

In what version/module?

Thanks

just Do It

View 1 Replies View Related

Integration Services

Jun 16, 2006

Hi all,

Can someone explain to me why I am getting this kind of error though I am able to integrate all the data succeesfully to the next destination.

I am trying to get the Prescription table from Access to SQL SERVER 2005 database



Ronald







SSIS package "Prescription.dtsx" starting.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.

Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.

Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.

Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.

Error: 0xC0202009 at Data Flow Task, SQL Server Destination [521]: An OLE DB error has occurred. Error code: 0x80040E14.

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 58, column 1. The destination column (PatientId) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 27, column 12. The destination column (ServiceId) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 26, column 12. The destination column (ServiceId) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 25, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 24, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 23, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 22, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 21, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "The bulk load failed. Unexpected NULL value in data file row 20, column 7. The destination column (AllergyCode) is defined as NOT NULL.".

Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.

Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.

View 1 Replies View Related

Integration Services

Jun 20, 2006

I'm trying to use the new integration services and have found all kinds of help for it, but where is it? I can't find it. Is it in the SQL Server Management Studio?

View 1 Replies View Related

Integration Services (SSIS)

Jul 25, 2007

Hi,

I want to insert datas from a txt-file into a sql-table.
Therefor i would use a xml-file for the structure!

How can i refer this xml-file to a measurement insertion task?


Tanks for your help and sorry for my bad english :rolleyes:

View 1 Replies View Related

SQL 2005 Integration Services Help

Jul 23, 2005

I am trying to know how to read many XML files within one data flowtask. I have many many files that I would like to apply to with thesame data flow so I need to know how to read them in and what taskshould I use under SQL 2005 DTS/Integration services.Thanks for your help!JON

View 1 Replies View Related

Doubts On Integration Services

Jan 14, 2008

Good morning,

I've to do a mining project and I intend to use the SSIS.

I've done a clustering plugin last year on analysis services and I also want to use it.

Let me try to explain the architecture of the process:

1) Receive data (read data from the database - these data are texts, actually)

2) Pre-process the data (transform the texts in a sparse matrix) using a new plugin

3) Call my clustering plugin and assign it to read the table created on the previous step

4) Call my KNN plugin to classify other pre-processed texts using the clusters found on the previous step as classes.

5) Show results.

Alright... It all running as a workflow on integration services

Here are my doubts:

A) How to view and use my plugin made for Analysis Services on Integration Services ? (is it possible or will I have to create another plugins from zero just to run on Integration Services ?)


B) Assuming the previous step is possible, how to modify my plugins to define inputs and outputs to do the correct communications between each plugin ? I think this is the most important question. Is it simple to do ? Is there any documented examples ?


Thanks a lot for your attention once more,

-Renan Souza

View 1 Replies View Related

Essbase And Integration Services

Apr 24, 2007

is it possible to use integration services to extract data from essbase?

View 3 Replies View Related

Cannot Install Integration Services

Nov 15, 2005

Hi!

View 28 Replies View Related

SP1 - Killing Integration Services

Apr 5, 2007

Don't know what's the problem while installing SP 1 it just kills the Integration Services. Did any one had this issue?



Thank you - Ashok

View 6 Replies View Related

Cannot Connect To Integration Services

Nov 16, 2006

When i try to connect to SQL 2005 integration services from object explorer i get connected (in the sense it shows in object explorer running packages stored packages ..)but when i try to exand any of these objects i get the following error

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

Failed to retrieve data for this request(Microsoft.sqlserver.smoEnum)

Additional information

The sql server specified in SSIS service configuration is not present or not available.This might occur when there is no default instance of Sql server on the computer. For more information see "config integeration services" in server 2005 books online.

Login time out expired

An error has occured while establishing a connection to the server.When connecting to the Sql server 2005, the failure may be caused by the fact that under default settings Sqlserver does not allow remote connections.

Names Pipes Provider: could not open a connection to Sql Server[2].(MsDtsSrvr)

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

i have chkd remote connection settings and other settings but cant find a way out.

kindly provide some help

Thanks in advance



View 4 Replies View Related

Upgrading To Integration Services From DTS

Sep 26, 2007

Hi

We have developed a datawarehouse using DTS in 2000. Now we have started using 2005 and as it supports DTS so there no issued for our datawarehouse to run.

But every six months there are new requirements and we achange and add to the existing DTS, but now DTS development is not supported in 2005, can we use itegration services for the same and embedd it with the existing DTS or do I need to redevelop the datawarehouse using SSIS.

View 1 Replies View Related







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