Re: 2 DTS Questions

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Guy Dillen (guy_dillen_at_nospam.hotmail.com)
Date: 09/14/04 

Date: Tue, 14 Sep 2004 08:30:05 +0200

Thanks Allan for your answers:

regarding to my first question:
would it be a good solution, creating a table in the SQL Server db with
TableName, UpdateYesNo, UpdateInterval, PackageName or
StoredProcedureNameTimeStamp and using this table e.g. in a C# app to start
the Package/StoredProcedure (starting directly the package or starting the
package via a stored procedure) if the UpdateYesNo = 'Y' and the
UpdateInterval is also ok?

To my 2nd question: i downloaded the document you mentioned, but there are
no examples (if i'm right) of writing DTS packages in C#?

Thanks.
Guy

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:%23Cfe8ihmEHA.1152@TK2MSFTNGP11.phx.gbl...
> 1. You can do this but this makes it very dynamic and you will have to
> write a lot of code to do this. DTS is not really this dynamic
>
> 2. You can certainly use C# to launch/write DTS packages and one of the
> best examples is a cookbook produced by Gert Drapers here
>
> http://www.sqldev.net/download/dts/DotNETCookBook.pdf
>
> --
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.SQLDTS.com - The site for all your DTS needs.
> www.konesans.com - Consultancy from the people who know
>
>
> "Guy Dillen" <guy_dillen@nospam.hotmail.com> wrote in message
> news:41461cb5$0$15182$ba620e4c@news.skynet.be...
>> I'm rather new to DTS and have the following questions:
>>
>> 1) i need to develop (a) DTS packages that transfers data from an Oracle
>> (8.1) database to SQL Server 2000 db. However the user should have the
>> possibility to select the tables in the Oracle db that he wants to
>> transfer/trasform to the SQL Server db. What is the best way to achieve
>> this?
>> 2) Since i don't know any vbscript, is it possible (and if so where can i
>> find more info) to use C# to launch DTS packages or create packages?
>>
>> Thanks for any help.
>>
>> Guy
>>
>>
>
>

Relevant Pages

  • Re: Editing DTS Packages on a 64-bit SQL Server 2005 installation
    ... But currently on our SQL 2006 64-bit installation it keeps doing the first ... SMS (SQL Server Management Studio) will not start at all. ... We can kind of do this now by editing the packages from our 32-bit installs ... In order to maintain the ability to edit these DTS packages, ...
    (microsoft.public.sqlserver.setup)
  • Re: Adding DTS via script
    ... As far as the DTS packages go, my source would be the structured storage file ... and the destination would be the sql server I wanted to add it to. ...
    (microsoft.public.sqlserver.dts)
  • Re: Versioning DTS Packages
    ... Packages in sysdtspackages will have a new row for every time you save it ... VersionID will be different as will CreateDate ... >>DTS Packages are versioned by default in SQL Server. ...
    (microsoft.public.sqlserver.dts)
  • Re: program to make changes to multiple DTS packages?
    ... "Allan Mitchell" wrote: ... The account used to retrieve the package from msdb and usually specified ... is an idea about how to retrieve the packages from SQL Server ... Enumerating DTS Packages using VB.Net ...
    (microsoft.public.sqlserver.dts)
  • Re: Help from experienced DTS Gurus
    ... come up with a standard file location that are packages point to. ... Chumma Dede wrote: ... > We have several large and complex DTS packages for converting from OLTP to ... > Advantages of maintaining in SQL Server: ...
    (microsoft.public.sqlserver.dts)