Good article on SQLIS to help get you going -

http://www.sqlis.com/311.aspx

It's pretty straight forward. Create a new SSIS package. From the toolbar in BIDS or VS 2005 select the SSIS dropdown menu, and the variables option. Create a new string...

If you can get away w/ just moving the system database(s) to the D drive then -

http://support.microsoft.com/kb/224071/en-us

Create a a new string variable to store the file name (varFileName) and populate the variable with a script task - i.e.

Option Strict Off

Imports System

Imports System.Data

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports System.IO

Public...

NP - happy to help 🙂

NP 🙂

Create another execute SQL task, select the parameter mapping tab. Under variable name, select User::MyDate. The direction will be Input, the data type will be DATE, and the parameter...

NP - so for example. Let's say you have a datetime variable called "MyDate". Create a new execute SQL task. Change the result set to "single row". The SQL statement...

Take a look at this one, use the same method to query the DMV's in order to get what your looking for.

http://sqlserver2005.databases.aspfaq.com/better-sp-who2.html

Use an execute SQL task. See "Usage Examples" here: http://www.sqlis.com/58.aspx

Lastbit Software's SQL Password is pretty decent - $149 (http://lastbit.com/sqlpassword/default.asp)

Have you tried the OLEDB Provider for DB2?

http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

select count(*)

from sys.dm_exec_connections

See Replication Views in BOL (http://msdn2.microsoft.com/en-us/library/ms187369.aspx). Also take a look at the Replication Administrator InfoCenter (http://msdn2.microsoft.com/en-us/library/ms151314.aspx). Another good resource, http://www.replicationanswers.com

Have you tried the OLE DB Provider for DB2 available in the feature pack? http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

Here is a good example - http://blogs.conchango.com/jamiethomson/archive/2005/12/09/SSIS_3A00_-Using-dynamic-SQL-in-an-OLE-DB-Source-component.aspx