Migration From Livelink To Sharepoint Using Ssis

Apr 9, 2008

hi

in my department we used livelink for a long time. now we have the order to migrate to sharepoint.
i have the task to make a package in ssis which reads from livelink using the livelink api and transform the data to sharepoint.



i have begun creating a custom connection manager. it is recognized by ssis and i can select it in the new connection window. what do i have to do in the aquire connection methods? do i have to create a custom datareader?

thanks in advance for your help

peter

View 9 Replies


ADVERTISEMENT

SSIS And Sharepoint List

Apr 28, 2007

i would like to know whether there is anyway to load the content of a Sharepoint(2007) List from a SQL server database.

have tried as a workaround to make Access database(.acc db) as a source for the List so that when changes made to the .accdb, automatically it reflectes the sharepoint list.

so i tried to make use of ssis 2005 to dts data from SQLserver db(Source 1) to .accdb(Destn1), then from Destn1 the SPList would receive data.

the Object that accdb supports to SPList is of Sharepoint List type i am not able to DTS data from sql server to accdb.



Any suggestions wld be appreciated!!!



View 28 Replies View Related

SSIS && SharePoint Lists

Apr 7, 2006

Hi,



is there any example how to extract values from a SharePoint list? I searched in Google but I only found something about that someone failed using the web service task for it... If possible I would like to get around any custom .net code (Scripts would be OK), but if I can't get around that, I have to follow that path...

Thanks,



View 5 Replies View Related

Beginning SSIS - Sharepoint And Excel

Feb 14, 2006

Hi all, I have never used SSIS before, but am looking to use it in this aspect:

1) A user uploads an Excel file into Sharepoint. This will be through a Document Library in a Sharepoint page.

2) When this file is uploaded, I'd like SSIS to notice there is a new file and process it - it will pull information from the Excel file, put it into a database, and - if this is possible - delete the new file.

3) This is iffy. Can SSIS then generate an InfoPath document  from the information stored in the database? If not, I can just have a InfoPath query form.

I'd just like to know if this is possible. If you have any helpful links, please let me know - I would greatly appreciate it!

Thanks,

James

View 8 Replies View Related

How To Query A Sharepoint List From SSIS

Jan 2, 2008

I have been searching for a GOOD example of using SSIS to query MOSS 2007 list data. I just want to return the data from a list in Sharepoint and use that data in SSIS. It should be as simple as defining a data source to connect to a specific list and return the rows like a SQL query.

Can anyone provide a good example of doing this in SSIS (and by the way, I'm not looking for how to write a C# program) - I want to be able to do this directly from SSIS.

Any help would be greatly appreciated.

View 4 Replies View Related

DTS Migration To SSIS

Nov 12, 2007

I have a problem with this ActiveX Script. I need to find out why I'm getting this error message: "retrieving the file name for a component failed with error code ..." I think it has something to do with my global variable setting. Am I right? Help please.

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()
Dim fn
Dim mm, dd

mm = Month(Now)
dd = Day(Now)

'Padded a 0 in front of the month if its less than 10 to maintain the YYYYMMDD format
If cInt(mm) < 10 then
mm = "0" & mm
End If

'Padded a 0 in front of the month if its less than 10 to maintain the YYYYMMDD format
If cInt(dd) < 10 then
dd = "0" & dd
End If

'Dev Server
fn = "D:Documents and SettingsUserDesktopDTSMigrateSamplesAEC_" & Year(Now) & mm & dd & ".txt"


dim oPackage
dim oConn

set oPackage = DTSGlobalVariables.parent
set oConn = oPackage.connections("HR Feed")
oConn.datasource = fn

set oPackage = nothing
set oConn = nothing

Main = DTSTaskExecResult_Success
End Function

View 3 Replies View Related

DTS Migration To SSIS

Jan 10, 2006

Good Day,

I am currently in the process of migrating my DTS packages to SSIS---one at a time---and have come accross the following error during the excecution of a "Copy SQL Server Objects Task".  The exact error is:

[Transfer SQL Server Objects Task] Error: Execution failed with the following error: "Version80 database compatibility level is not supported.".

What I am doing with this particular task is to copy a table(s) from another SQL Server, to the current SQL Server.  The original location is a SQL2000 DB table.  In the near future the source server for this table will be a SQL 2005 server but not until the current migration has been completed.

I have looked at all of the properties, but can not find anything relating to the db compatibilty level.  Is there an easier way?  Or a setting that I can change to accomplish what I am trying?

Thanks for any help/suggestions.

View 8 Replies View Related

Migration From DTS To SSIS

Sep 6, 2007

Hi everybody,
I would REALLY appreciate it if some had a link to a good tutorial about migration from DTS to SSIS, but without visual studio . net.
For example I need to use DTS package in sql server 2005 and execute them, I used migration wizard (SQL 2005) but it didn't work because i have in my computer sql 2000 et sql 2005 and the server name is PC2, however when i use the server source PC2 and the server destination PC2 an error message appear "server destination should be a sql server 2005 instance ".

help me please..
Thanks very much anyone response my question.

View 3 Replies View Related

Migration Of DTS To SSIS

Nov 6, 2006

Well..

Have migrated my SQL 2000 DTS packages to SSIS packages through the package migration Wizard.Also, the hurdle to schedule it as a job has been resolved.But, the concern is the package contains entrieslins for old dataserver.

Is it possible to edit the SSIS pckage using management studio or integration services?



View 1 Replies View Related

SQL 2012 :: Reading File From Sharepoint To SSIS

Dec 16, 2014

We have a requirement to read data from Sharepoint to SSIS. Is it doable? What components to use and any dll we should include.

View 1 Replies View Related

HOW To Extract Data From A SharePoint List Using SSIS

Apr 9, 2008

Has anyone figured out how to extract the data from a SharePoint List into a SQL Table or ssis variable
using SSIS?

View 5 Replies View Related

Integration Services :: Sharepoint Folders Using SSIS

Nov 18, 2015

Is there any way we can download sharepoint folders using ssis. I have a specific link(View on sharepoint) which I would like to download using ssis, Is it possible?

View 2 Replies View Related

SSIS For Data Migration

Apr 5, 2007

Hi guys,

I just moved to SQL 2005 and am facing a difficulty trying to build a DTS Package using SSIS Projects. I need to migrate data from an old Database design to a new Database design in my local pc.

Can anyone provide me some guidelines or tutorials on which components to use and a flow of the entire process which I should follow? I am confused.

Thanks alot in advance, hope to hear from you guys soon.

View 1 Replies View Related

Migration Of DTS Packages To SSIS

Feb 16, 2006

I am in a situation where we are redesigning our Datawarehouse. Currently we have our Datawarehouse in SQL 2000 and we are rebuilding from scratch in SQL 2005. This means that even though we will get the same tables but we are planning to rename each & every attribute to make it more meaningful.

The question is like this:

We can migrate the current DTS packages to SSIS but since all the ODBC connections , field names(attributes) will change is it worth it to leverages the DTS packages ?

Also we convert the julian date to gregorian date in our DTS packages but since SSIS has a feature to convert julian date it would be redundant to migrate the packages and my feeling is to create new packages in SSIS and start on a clean slate.

Is there anybody who was in such situation ?

Please advise.

Adarsh Mathur

View 2 Replies View Related

DTS To SSIS Migration Question

Aug 2, 2007

Its probably a little late for this kind of question but, I'm converting several DTS packages over to SSIS and in the conversion I have the ability to run tasks as 'Execute DTS 2000 Package'. My question is, should I use that or do a full re-write of the flows to use the SSIS tasks?

So far I've been removing anything pertaining to SQL 2000 and adding the SSIS tasks. Its becoming very time consuming this way due to some of the DTS packages have a lot of tasks/flows. Is it the best way to do this or should I just use the DTS migration Wizard and then leave the .dtsx files alone once they're created from the wizard?

View 4 Replies View Related

SSIS Migration Between Servers

Sep 21, 2007

Good Day,

I am in the process of moving my ssis package development to a new machine. I have zipped up all of my development/solution files and put them on the new machine...put them in place...but when I try to test them within Visual Studio I am getting a build error that says

Error 3 Cannot create the output file "C:Documents and SettingsmandolinMy DocumentsVisual Studio 2005ProjectsTransfer and Load Enrollment DataTransfer and Load Enrollment DatainCUP Enrollment Data Pickup.dtsx": The device is not ready. . 0 0


Additionally, but related, I can only open some projects within the solution. I am getting the following error when I try to open "some" of the packages within the solution:

The Device is not ready. (Exception from HRESULT: 0x80070015)


Can someone offer some advice on just what is happening here? I would really appreciate any thoughts or advice.

Thank you in advance.

View 9 Replies View Related

SQL Server 2012 :: SSIS Package Backup Of Sharepoint

Dec 2, 2013

I was assigned a project to make a backup of data from 3 lists in a sharepoint with the objective of using that data to do reports on it using Report Builder.

I was abble to do the downloads using the add in to do downloads Sharepoint List Source and Destination "plug in" in SSIS, now the issue is how to update the backup table only with updated and new rows.
Daniel

View 1 Replies View Related

SQL Server 2014 :: SSIS SharePoint List Destination?

Mar 24, 2015

We are just looking to move to SSIS 2014 from 2008R2 however we have a number of packages which write to Sharepoint lists. The SHarepointDestination doesn't seem to work in VS 2013, any solution other than buying a third party connector.

View 1 Replies View Related

Data Migration Using SSIS In SQL 2005

Aug 8, 2006

Greetings,
I am using SQL Server 2005 and I want a clue if there is some good built-in support to do the following.
I want to transfer all the data from one source database to another destination database having same number to tables and schema like source database. I also want to ensure that the old data on the destination database should be secure too.
I have an idea that this can be done through SSIS in coding but can anyone give me a guide, tip, link, sample code that can be helpful.
Thanx a million in advance.
Regards
 

View 1 Replies View Related

Migration From Sql Server 2000DTS To SSIS

Mar 26, 2008

Hi,
I am going to work on the Migration project(DTS to SSIS).Could you plese suggest me some useful links reg Migration process and Best Practices used for Migration.

Appreciated Assistance/guidence in this regard

View 3 Replies View Related

Regarding SSIS Implementation Difficulties In Migration

May 2, 2008



We would like to Share the BatchJobs functionality before going to the difficulties what we are facing in SSIS package Design and it's implementation.

BatchFile Process Steps:

1.Flat File is coming from the upstream server(DB2 main Frame Server) to the linux box in which the jobs are scheduled using crons.

2.The Flat file is validated whether having header and trailer information.The flat file name itself (eg. APPLWIC00077.dat ) will have it's sequence number ie 00077.This number will be checked against Flat file Header information Which also gives the sequence number information .If both number matches,The Loading will be initiated.Same way checking happens with Trailer.If anything goes wrong,mail will be sent and Loading will not happen.

3.The Job will process the coming flat file and Loading it into SQL Server Staging Table.

4.If loading is successful,then Some Sql server Procedure are called to validate the Staging Table Data,Filters,then move the Data from Staging table to Target table.

5.All Process or Steps are tracked,If anything goes wrong,Mail will be sent to Concerned Person.

Utilities Involved:

1. SQL Loader to Load the FlatFile Data into the SQL Server 2005 Database.

2. SQLPLUS to execute the PL/SQL procedures.

3. SENDMAIL or MAILX to send mails to externals.

Additional Information:

The SQL Loader Control File Splits the flatfile data by Position wise in order to load it into the particular column of the Staging Table.No column delimiters.Data are taken position wise (like column1 -> Sequence No , 1-3 -> column2 , 4-8 -> column2 )and checked against a condition By which the particular Staging Table is selected.





Difficulties We face in migration in regard to SSIS Package Design and it's Implementation:

1. We could Receive the flat file using FTP Task and we don't know how to open and validate the flat file data Like What we mentioned in STEP 2.

2. We could load the sample flat file which is properly delimited like {CR}{LF} ,{CR},{LF},semi -colon,comma,colon,tab,vertical bar .

If flatfile is messed up and data need to be processed by position wise (Scenario mentioned in Additional Information) ,We don't know how to implement this in SSIS package with the Limited delimiter option given.

FYI : Flat File columns are not fixed and ragged type.

3. We need logging information like howmany rows inserted, discarded,something in detail..How can we log these information using SSIS.This will help to send detailed mail to Application handler.It should be automated using SSIS.

4. How can we execute Procedures Using available SSIS tasks ( Executing many Procedures which is residing in Sql server 2005 using Single sql file as input to SSIS package)



Thanks in Advance!
Your input is priceless.

Regards,
Prabhu.M

View 4 Replies View Related

Migration From Sql Server 2000DTS To SSIS

Mar 26, 2008



Hi,
I am going to work on the Migration project(DTS to SSIS).Could you plese suggest me some useful links reg Migration process and Best Practices used for Migration.

Appreciated Assistance/guidence in this regard

View 6 Replies View Related

SSIS Migration Wizard Question

Mar 18, 2008

I applied the DTS Migraiton Wizard to a DTS package and it worked fine with one BIG exception. The DTS package imports a fixed-width record, length about 1500 bytes, with 60+ "parse" lines (one per field). The migrated SSIS package did not preserve any of the parse structure. That's alot of error prone worke to recreate and we have another 3 DTS packages based on the same parsing. Any suggestions on how to preserve the parsing structure in SSIS?



TIA,

barkingdog



View 2 Replies View Related

Where Is The Forum For DTS -&&> SSIS Migration Questions?

Jan 29, 2008

I have a question regarding a DTS (SQL server 2000 package) to SSIS (SQL SERVER 2005 package) migration.

which is the best forum to post my question ?

View 1 Replies View Related

Migration SSIS In Msdb To Other Server

Aug 7, 2006

I depolyed several package in a server A msdb in some logical folders

E.g. msdbTask1package1

msdbTask2package2

msdbTask3package3

I would like to migrate the package to other server B and keep the logical folders tree.

I know I can reploy the packages in B and move them to the logical folders tree one by one, it is too slow.

Is there any fast method to migrate the package and keeping the tree?

Thanks.

View 1 Replies View Related

SSIS Pkgs Migration Question

May 30, 2008



I have a server that is sql2000. We are planning to upgrade that to SQL SERVER 2005.
We also have a test 2005 server.
Before going live, we are migrating all 100 DTS pkgs that we have
in sql server 200 over to SSSS on the TEST 2005 sql Server. once all THE 100 DTSPKGS THAT we have in SQL
2000 PKGS Are scucessfuly migrated/tested on test 2005 server, only then we will
move forward with migrating the PRODuction 2000 Server to 2005.

My question is:

1. When we are ready to migrate PRODuction 2000 SERVER, TO 2005, We will need to transfer/copy all
the SSIS 2005 PKGS THAT WE HAD tested on the test 2005 server. Once we move that to prod 2005,
we will need to change datasource connection to point to the PRODuction 2005 SERVER.

However my question is WHAT IS THE EASIEST/FASTEST WAY TO tranfer/copy all these (100+ ssis pkgs)
2005 ssis pkgs that are on the TEST SERVER
OVER TO PROD 2005 SERVER? Do we transfer each and every SSIS PKg manually ,or is there any easy way to get
these 100 SSIS Pkgs, over from TEST 2005 TO PROD 2005?

View 10 Replies View Related

Activate Or Execute A Ssis Package From Sharepoint Document Library

Mar 26, 2007

hello all

i need to execute a ssis(sql 2005 integration service) on a document document library . can you people help me out how i can do it

i want to make a work flow which initiate when new document upload in a moss document library and this work flow pass the document to a ssis package and initiate that ssis package

note: the database and moss servers are on different machine

please reply ASAP if there any way to do it.

thnaks

View 7 Replies View Related

Integration Services :: SSIS - Extract Data From SharePoint 2013?

Apr 23, 2015

i never used SharePoint before, only for update some Excel files. But now, I want to extract the Excel Data from SharePoint 2013 to my SQL database. I'm thinking use the Excel Source to do that, however I'm having very errors to achieve that.

I want to do some ETL on data from the Excel files.

View 6 Replies View Related

Copying Files From A Sharepoint Location To Local Machine Using SSIS

Apr 20, 2007

I have to copy files from a sharepoint or extranet location (basically https://.....) location to my local server using SSIS.



Any kind of early help would be really great.

View 1 Replies View Related

Migration Issue From DTS 2000 To SSIS SQL 2005

Jul 13, 2007

Hi,

Hi,



I am trying to migrate DTS 2000 packages to SQL 2005 SSis using Package Wizard. When I am invoking and after the passing server information of source and destination, while reading the packages it is giving error

TITLE: Microsoft SQL Server

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



This wizard will close because it encountered the following error:



For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.UI.WizardFrameworkErrorSR&EvtID=UncaughtException&LinkId=20476



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

ADDITIONAL INFORMATION:



Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)


Could someone can help in this regards. As this is a important task for me and I am stuck on this which has to be resolved by end of today.

Thanks

-VD

Venkatesh

View 1 Replies View Related

How Can I View The Design Of The Ssis Package After Migration

Jun 8, 2007

OK, I was able to successfully migrate all of my DTS packages to SSIS, for SQL 2005. I can log into intergration services and see my packages listed under:

servername --> stored packages --> msdb. Now my question is, how can I open these packages, not run them open them in a design mode like you can in SQL 2000, you can double click on the package name and view the design of the package. how can i do that now that I have them in SQL 2005?







View 6 Replies View Related

Reporting Services And Sharepoint Integration - Sharepoint Alternate Access Mappings (Zones)

Mar 2, 2007

I get the following error when I try to navigate to a report/model/data source, stored in a Sharepoint Document Library using a Sharepoint URL based on an Extranet or Intranet zone - but it works OK using the url for the Default zone:

System.Web.Services.Protocols.SoapException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used. ---> Microsoft.ReportingServices.Diagnostics.Utilities.SecurityZoneNotSupportedException: The specified path refers to a SharePoint zone that is not supported. The default zone path must be used.


Is this a limitation of the SQLRS-WSS3 integration or is there a workaround?

Many thanks to anyone who can help!





View 22 Replies View Related

Integration Services :: SharePoint SSRS Subscription Execution From SSIS Using Powershell

Oct 26, 2015

We have been looking for a way to executing bursting of SSRS reports within SharePoint (integration mode) from a SSIS package after a successful load. We found this MSDN article which has a PowerShell script to "fire" a subscription.URL....One of the parameter needed is the SubscriptionID.

View 4 Replies View Related







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