Migrating DTS packages Question: Dynamic Properties

Hi guys,

After DTS Migration is "successful", I opened up dynamic properties step but I saw codes were all commented out inside the public class ScriptMain. Since I am not familiar with Microsoft.SqlServer.Dts.Runtime, I'm not sure what methods I should use as there aren't much examples available online. How do I do the following in SISS way?

' Add your code here

' Source Type = 2

' Global variable = glvTrade

' Destination = 'Connections';'Trade';'OLEDBProperties';'Data Source';'Properties';'Value'

Regards

Hi,
I have same problem too.
' Source(Type = 2)
' Global variable = SPLastDate
' Destination = 'Tasks';'DTSTask_DTSExecuteSQLTask_7';'Properties';'SQLStatement'
How can i convert this code for ssis ?
Does anyone have any solution ?

Thans
Yasemin

Migrating DTS packages Question: Dynamic Properties

Hi guys,

After DTS Migration is "successful", I opened up dynamic properties step but I saw codes were all commented out inside the public class ScriptMain. Since I am not familiar with Microsoft.SqlServer.Dts.Runtime, I'm not sure what methods I should use as there aren't much examples available online. How do I do the following in SISS way?

' Add your code here

' Source Type = 2

' Global variable = glvTrade

' Destination = 'Connections';'Trade';'OLEDBProperties';'Data Source';'Properties';'Value'

Regards

Hi,
I have same problem too.
' Source(Type = 2)
' Global variable = SPLastDate
' Destination = 'Tasks';'DTSTask_DTSExecuteSQLTask_7';'Properties';'SQLStatement'
How can i convert this code for ssis ?
Does anyone have any solution ?

Thans
Yasemin

sql

Migrating DTS packages

Is there anyway to copy all the DTS packages and jobs in one step from one server to another. I usvally copy one DTS package at a time. As our packages count grown bigger, it became a painful process.
If anyone knows a way to copy these packages and jobs in one then it would be very helpful.

ThanksI don't think you can for DTS: Steps I have used in the past:

Save DTS package to hard drive:
Save DTS package as file on the disk, then copy this file on the target SQL Server and load this DTS package on the target machine. Dont forget to save in SQL Server.

Or...

Run DTS Export Wizard, and transfer this select statement:

SELECT * FROM sysdtspackages WHERE name = 'DTSPackageName'

from the msdb database on the source server to the msdb database on the destination server to transfer the DTSPackageName package.

You may be able to add multi packageName, I have never play around with the code. (Maybe someone else will have an idea)

And...

As for jobs you can create a DTS package and under Task select 15 - Transfer job task and follow the steps. You can do all of your jobs at once.

Hope it works out for you.

Thanks

Lystra|||As for the DTS packages go to http://www.sqldts.com/default.aspx?242 This is a free tool to migrate the DTS packages in one step.

migrating data from DB2 to MS-SQL

hi,
i am a novice in DB2 and am looking for a step by step procedure to migrate data from DB2 version7 to MS-SQL. i need immediate help..
thanks
jackieI think you could use a linked server to do that ... and if i remember correctly, there is also a whitepaper availible on MS Knowledge Base for the same ...|||thanks...let me check it out...|||From the Holy Book

OLE DB Provider for DB2

The Microsoft OLE DB Provider for DB2, distributed with Microsoft Host Integration Server 2000, allows Microsoft SQL Server 2000 distributed queries to query data in DB2 databases.

To create a linked server to access a DB2 database
Install the Windows NT Client for Host Integration Server 2000 or the Windows 9x Client for Host Integration Server 2000 on a computer running an instance of SQL Server. Select the options to install the OLE DB Provider for DB2 and the network components needed to communicate with an IBM computer running in an SNA network.
Determine the connection string the OLE DB Provider for DB2 needs to access the DB2 data source you want to query. The best way to determine a connection string is to build a Data Link file using the Host Integration Server New OLE DB Data Source application. For more information, see the Microsoft Host Integration Server 2000 documentation.
Execute sp_addlinkedserver to create a linked server, specifying DB2OLEDB as the provider_name, the name of the DB2 catalog containing the data you want to access as catalog, and the connection string from Step 2 as provider_string. This example shows how to use sp_addlinkedserver to create a linked server definition accessing a DB2 database:

EXEC sp_addlinkedserver @.server = 'DB2SRV', @.srvproduct = 'Microsoft OLE DB Provider for DB2', @.catalog = 'SEATTLE', @.provider = 'DB2OLEDB', @.provstr = 'NetLib=SNA;NetAddr=;NetPort=;RemoteLU=SEATTLE;Loc alLU=LOCAL; ModeName=QPCSUPP;InitCat=SEATTLE; Default Schema=WNW3XX;PkgCol=WNW3XX;TPName=;Commit=YES; IsoLvl=NC;AccMode=;CCSID=37;PCCodePage=1252;BinAsC har=NO; Data Source=Seattle_WNW3XX'
Execute sp_addlinkedsrvlogin to create login mappings from SQL Server 2000 logins to DB2 logins. This example maps the SQL Server 2000 login SQLJoe to DB2 login DB2Joe:

EXEC sp_addlinkedsrvlogin 'DB2SRV', false, 'SQLJoe', 'DB2Joe', 'JoePwd'
After completing these steps, you can use the linked server name DB2SRV as the server name in four part names and as linked_server in the OPENQUERY function. For example:

SELECT *FROM DB2SRV.SEATTLE.WNW3XX.DEPARTMENTOr

SELECT *FROM OPENQUERY(DB2SRV, 'SELECT * FROM SEATTLE.WNW3XX.EMP_ACT')When the distributed queries against DB2 data sources involve NULL comparisons, use IS NULL or IS NOT NULL rather than comparison operators, such as =, <, or >. In addition, INSERT statements should supply values for all columns in a table even if certain columns in the table can be NULL or have default values.|||hey that was great...i am going to try that...|||OS/390 or Client Server?

With the mainframe, you'll need a gateway I believe...have yet to get that working..

If it is the mainframe, you could unload all the data and ftp it down the bcp it in...

The deal with conversion issues...wonder if linked servers handle DB2 Dates?

Migrate from sql 2000 to sql 2005

I buckup and restore all databases on the sql server 2005 from sql 2000.
What is the next step ?
I need to implement Reporting Services for sql 2005.
Thanks for help.On Jun 15, 4:11 pm, GGill <G...@.discussions.microsoft.com> wrote:
> I buckup and restore all databases on the sql server 2005 from sql 2000.
> What is the next step ?
> I need to implement Reporting Services for sql 2005.
> Thanks for help.
This article should be of assistance.
http://msdn2.microsoft.com/en-us/library/ms143724(SQL.90).aspx
Regards,
Enrique Martinez
Sr. Software Consultant