how to manage a DTS Package usin Asp.net

Hi

How i can manage a DTS Package usin Asp.net

Hi,

R u looking for DTS Packages or SSIS Packages. For any SSIS package you can execute it from .Net Code using the given Below Method

1. Name Space to Include

using Microsoft.SqlServer.Dts.Runtime;

2. Create a Package Variable in constructor it takes FileName of the DTSX Package (SSIS Package ). You can explore this class. It has a execute method

Hope this will help

Satya

How to make the DTS package fail, when the source table is empty

How to make the DTS package fail, when the source table is empty while transfering data from source to destination.

Quote:

Originally Posted by sajithamol

How to make the DTS package fail, when the source table is empty while transfering data from source to destination.

Hi,

you will have to specify a T-SQL statement stating if it fails dont run DTS. Its easy to do it in MS SQL 2005 and it has added features.

How to make SSIS 2005 work like DTS 2000?

Hi!
Is it possible to make data flow in SQL Server 2005 Integration Services
looks like in SQL Server 2000 DTS?
I need to acive 2 goals:
1. If bcp fails on INSERT statement, for example, on primary key validation,
it must go on to the next row, but not to break SQL threat and stop.
2. I need log for failed errors. Not the log about which process failed, but
just the error source line.
And the final question: in SQL Server 2000 it was no probem to do it, so why
it has been removed from SQL Server 2005?
Thank you
Igor A. ChechetHi,
Igor A. Chechet wrote:
> Is it possible to make data flow in SQL Server 2005 Integration Services
> looks like in SQL Server 2000 DTS?
> I need to acive 2 goals:
> 1. If bcp fails on INSERT statement, for example, on primary key validatio
n,
> it must go on to the next row, but not to break SQL threat and stop.
> 2. I need log for failed errors. Not the log about which process failed, b
ut
> just the error source line.
>
your goals are easy to achieve with SIIS, too:
You have to open the editor of the task producing the error and
hit the "configure error output" button. There you have three
options:
- fail component
default, causes the package to stop
- ignore error
errors are ignored (see goal 1)
- redirect row
data is redirected to the error output (red arrow)
you can attach another Data Flow Destination component here
to write the failed rows to another table (see goal 2)
In the books online there's a tutorial for SIIS which shows the
most important features like logging, variables and configuration
files.
HTH,
Gerald|||Gerald, thank you for your advise!
I think that your suported method will help, but the problem is that the
error occured on the SQL Server Destination Task, and that's not possible to
create error output for it. BCP fails always on this task. Any ideas how to
handle it?
Thank you
Igor A. Chechet
"Gerald Aichholzer" <gerald.aichholzer@.gmx.net> '?/'' ? ''
'?: news:eYFYlFRpGHA.504@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Igor A. Chechet wrote:
> your goals are easy to achieve with SIIS, too:
> You have to open the editor of the task producing the error and
> hit the "configure error output" button. There you have three
> options:
> - fail component
> default, causes the package to stop
> - ignore error
> errors are ignored (see goal 1)
> - redirect row
> data is redirected to the error output (red arrow)
> you can attach another Data Flow Destination component here
> to write the failed rows to another table (see goal 2)
> In the books online there's a tutorial for SIIS which shows the
> most important features like logging, variables and configuration
> files.
>
> HTH,
> Gerald|||Hi Igor,
Igor A. Chechet wrote:
> Gerald, thank you for your advise!
> I think that your suported method will help, but the problem is that the
> error occured on the SQL Server Destination Task, and that's not possible
to
> create error output for it. BCP fails always on this task. Any ideas how t
o
> handle it?
>
I'm not quite sure about this (I started with SIIS only two weeks ago),
but AFAIR you have to disable bulk insert to be able to create error
output. I think you have to select "table or view" (without "fast load")
in "data access mode".
HTH,
Gerald|||to log the rows in error, you have to disable the fast load option (like in
SQL 2000)
but this greatly slowdown the loading process.
regarding the size of the file you have to load, it could be bettter to load
the file into a temporary table (with no PK constraint)
then execute some SQL statement to identify duplicated rows and remove these
duplicated (or moving these rows into another table)
another option is to try to play with the sort task in the dataflow (there
is an option to remove duplicated rows)
or the aggregate flow to count the rows in double, then split the stream
into 2 streams (1 with unique rows (count=1), 1 with duplicated rows
(count>1))
finally the stream 1 with the unique rows will be inserted into the
destination using the fast load option and duplicated rows moved to the
error log table.
and another option...
simply insert the rows using the fast load option and use only 1 transaction
(no batch size)
if the insertion failed, then load again the rows but with a destination
where the fastload option is disabled and where the error output can be
used.
(solution not tested)
"Igor A. Chechet" <ichechet@.mail.ru> wrote in message
news:eMksqaPpGHA.4424@.TK2MSFTNGP05.phx.gbl...
> Hi!
> Is it possible to make data flow in SQL Server 2005 Integration Services
> looks like in SQL Server 2000 DTS?
> I need to acive 2 goals:
> 1. If bcp fails on INSERT statement, for example, on primary key
> validation, it must go on to the next row, but not to break SQL threat and
> stop.
> 2. I need log for failed errors. Not the log about which process failed,
> but just the error source line.
> And the final question: in SQL Server 2000 it was no probem to do it, so
> why it has been removed from SQL Server 2005?
> Thank you
> Igor A. Chechet
>

How to make SSIS 2005 work like DTS 2000?

Hi!
Is it possible to make data flow in SQL Server 2005 Integration Services
looks like in SQL Server 2000 DTS?
I need to acive 2 goals:
1. If bcp fails on INSERT statement, for example, on primary key validation,
it must go on to the next row, but not to break SQL threat and stop.
2. I need log for failed errors. Not the log about which process failed, but
just the error source line.
And the final question: in SQL Server 2000 it was no probem to do it, so why
it has been removed from SQL Server 2005?
Thank you
Igor A. ChechetHi,
Igor A. Chechet wrote:
> Is it possible to make data flow in SQL Server 2005 Integration Services
> looks like in SQL Server 2000 DTS?
> I need to acive 2 goals:
> 1. If bcp fails on INSERT statement, for example, on primary key validation,
> it must go on to the next row, but not to break SQL threat and stop.
> 2. I need log for failed errors. Not the log about which process failed, but
> just the error source line.
>
your goals are easy to achieve with SIIS, too:
You have to open the editor of the task producing the error and
hit the "configure error output" button. There you have three
options:
- fail component
default, causes the package to stop
- ignore error
errors are ignored (see goal 1)
- redirect row
data is redirected to the error output (red arrow)
you can attach another Data Flow Destination component here
to write the failed rows to another table (see goal 2)
In the books online there's a tutorial for SIIS which shows the
most important features like logging, variables and configuration
files.
HTH,
Gerald|||Gerald, thank you for your advise!
I think that your suported method will help, but the problem is that the
error occured on the SQL Server Destination Task, and that's not possible to
create error output for it. BCP fails always on this task. Any ideas how to
handle it?
Thank you
Igor A. Chechet
"Gerald Aichholzer" <gerald.aichholzer@.gmx.net> '?/'' ? ''
'?: news:eYFYlFRpGHA.504@.TK2MSFTNGP05.phx.gbl...
> Hi,
> Igor A. Chechet wrote:
>> Is it possible to make data flow in SQL Server 2005 Integration Services
>> looks like in SQL Server 2000 DTS?
>> I need to acive 2 goals:
>> 1. If bcp fails on INSERT statement, for example, on primary key
>> validation, it must go on to the next row, but not to break SQL threat
>> and stop.
>> 2. I need log for failed errors. Not the log about which process failed,
>> but just the error source line.
> your goals are easy to achieve with SIIS, too:
> You have to open the editor of the task producing the error and
> hit the "configure error output" button. There you have three
> options:
> - fail component
> default, causes the package to stop
> - ignore error
> errors are ignored (see goal 1)
> - redirect row
> data is redirected to the error output (red arrow)
> you can attach another Data Flow Destination component here
> to write the failed rows to another table (see goal 2)
> In the books online there's a tutorial for SIIS which shows the
> most important features like logging, variables and configuration
> files.
>
> HTH,
> Gerald|||Hi Igor,
Igor A. Chechet wrote:
> Gerald, thank you for your advise!
> I think that your suported method will help, but the problem is that the
> error occured on the SQL Server Destination Task, and that's not possible to
> create error output for it. BCP fails always on this task. Any ideas how to
> handle it?
>
I'm not quite sure about this (I started with SIIS only two weeks ago),
but AFAIR you have to disable bulk insert to be able to create error
output. I think you have to select "table or view" (without "fast load")
in "data access mode".
HTH,
Gerald|||to log the rows in error, you have to disable the fast load option (like in
SQL 2000)
but this greatly slowdown the loading process.
regarding the size of the file you have to load, it could be bettter to load
the file into a temporary table (with no PK constraint)
then execute some SQL statement to identify duplicated rows and remove these
duplicated (or moving these rows into another table)
another option is to try to play with the sort task in the dataflow (there
is an option to remove duplicated rows)
or the aggregate flow to count the rows in double, then split the stream
into 2 streams (1 with unique rows (count=1), 1 with duplicated rows
(count>1))
finally the stream 1 with the unique rows will be inserted into the
destination using the fast load option and duplicated rows moved to the
error log table.
and another option...
simply insert the rows using the fast load option and use only 1 transaction
(no batch size)
if the insertion failed, then load again the rows but with a destination
where the fastload option is disabled and where the error output can be
used.
(solution not tested)
"Igor A. Chechet" <ichechet@.mail.ru> wrote in message
news:eMksqaPpGHA.4424@.TK2MSFTNGP05.phx.gbl...
> Hi!
> Is it possible to make data flow in SQL Server 2005 Integration Services
> looks like in SQL Server 2000 DTS?
> I need to acive 2 goals:
> 1. If bcp fails on INSERT statement, for example, on primary key
> validation, it must go on to the next row, but not to break SQL threat and
> stop.
> 2. I need log for failed errors. Not the log about which process failed,
> but just the error source line.
> And the final question: in SQL Server 2000 it was no probem to do it, so
> why it has been removed from SQL Server 2005?
> Thank you
> Igor A. Chechet
>sql

How to login to SQL servers in a DTS?

Hello,

I have a DTS package in which I have several flows using different connections (OLE DB Providers, etc...) with Login ID and password.

But whenever the password changes, I need to manually update all the connections I have in this DTS. Isn't there an easier way to do that, somewhere via code or something else?
DTS or SSIS?

For DTS questions, see the DTS forum: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg|||

Assuming you're talking about SSIS, you can consider other package protection levels (avoid password encryption) - e.g. ServerStorage.

See http://technet.microsoft.com/en-us/library/ms141747(SQL.90).aspx

How to login to SQL servers in a DTS?

Hello,

I have a DTS package in which I have several flows using different connections (OLE DB Providers, etc...) with Login ID and password.

But whenever the password changes, I need to manually update all the connections I have in this DTS. Isn't there an easier way to do that, somewhere via code or something else?
DTS or SSIS?

For DTS questions, see the DTS forum: http://groups.google.com/group/microsoft.public.sqlserver.dts?lnk=srg|||

Assuming you're talking about SSIS, you can consider other package protection levels (avoid password encryption) - e.g. ServerStorage.

See http://technet.microsoft.com/en-us/library/ms141747(SQL.90).aspx

How to load a Legacy DTS Package from .NET?

If I have an object of type "Microsoft.SqlServer.DTS.Runtime.Application,"

can I use one of the following functions
- ExistsOnDTSServer
- ExistsOnSQLServer
- LoadFromDTSServer
- LoadFromSQLServer
- LoadFromSQLServer2

to interact/load with a Legacy (SQL 2000) DTS package, stored on a SQL 2005 machine?

If so, can someone post an example first-argument (the Package Path) ?
Thanks.

I suspect that this is not possible.

Why would you not use the DTS object model to load and run a DTS package? Although it's a COM library, you can certainly use it from .NET...

-Doug|||You're probably right. It was worth someone verifying before assuming correctly/incorrectly.

The "Microsoft DTSPackage Object" COM object is an adequate alternative.
But this would require SQL 2000 Client Tools to be installed on the machine, in addition to SQL 2005 Client Tools, to gain use of both objects.

How to load a DTS package using SQL Query Analyzer (SQL Server 2000)

I have a fully functional DTS Package that I want to load into a new database environment using SQL Query Analyzer. Does anyone know how to accomplish this task? I know this can be done using Enterprise manager, but I must have it in a script that can be executed in Query Analyzer. Please advice. Thanks.

Why must this be done in Query Analyzer? If the two servers have the ability to connect to each other, you could use sysdtspackages but I don't believe this is the supported option as you are using undocumented system tables. However, you can find information on using this table to move the package in this article: http://www.sqldts.com/204.aspx

Other methods of moving packages are discussed in the article as well. If this is a requirement to move something to production or follow some other promotion or release guidelines, you may want to try to pursue saving the package as a structured storage files. The article addresses how to do this as well. And this method would be supported.

-Sue

how to list all tables used in a database?

Hi,
I want to list all the tables used in a particular database during the
execution of a lot of DTS packages.
I think the profiler could help me, but what is the configuration to
accomplish this?
event, columns, filters...
thanks for your guide
Jerome.
Hi
The below script find an emtpy tables , modify it for your needs
use pubs
-- create table and do not populate it
create table EmptyTable (c1 int)
go
-- create a cursor to go through each table in a database
-- and print the name of any empty tables
DECLARE @.SQLString nvarchar (255),
@.ParmDefinition nvarchar (255)
DECLARE @.tablename sysname, @.Empty char (1)
DECLARE FindEmptyTables CURSOR READ_ONLY
FOR SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
OPEN FindEmptyTables
FETCH NEXT FROM FindEmptyTables INTO @.tablename
WHILE (@.@.fetch_status = 0)
BEGIN
SET @.SQLString = N'IF EXISTS (SELECT * FROM ' + @.tablename + ') set
@.Empty = ''N'' ELSE set @.Empty = ''Y'''
SET @.ParmDefinition = N'@.tablename sysname, @.Empty char(1) OUTPUT'
EXECUTE sp_executesql
@.SQLString,
@.ParmDefinition,
@.tablename = @.tablename,
@.Empty = @.Empty OUTPUT
IF @.Empty = 'Y' PRINT @.tablename + ' is empty'
FETCH NEXT FROM FindEmptyTables INTO @.tablename
END
CLOSE FindEmptyTables
DEALLOCATE FindEmptyTables
GO
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:OreCV6qSFHA.1152@.tk2msftngp13.phx.gbl...
> Hi,
> I want to list all the tables used in a particular database during the
> execution of a lot of DTS packages.
> I think the profiler could help me, but what is the configuration to
> accomplish this?
> event, columns, filters...
> thanks for your guide
> Jerome.
>
|||I don't want to list tables availables, I want to list table REALLY used
during the loading process.
I mean tables which is part of a Select statement.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:exlUagvSFHA.3636@.TK2MSFTNGP14.phx.gbl...
> Hi
> The below script find an emtpy tables , modify it for your needs
> use pubs
> -- create table and do not populate it
> create table EmptyTable (c1 int)
> go
> -- create a cursor to go through each table in a database
> -- and print the name of any empty tables
> DECLARE @.SQLString nvarchar (255),
> @.ParmDefinition nvarchar (255)
> DECLARE @.tablename sysname, @.Empty char (1)
> DECLARE FindEmptyTables CURSOR READ_ONLY
> FOR SELECT TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> WHERE TABLE_TYPE = 'BASE TABLE'
> OPEN FindEmptyTables
> FETCH NEXT FROM FindEmptyTables INTO @.tablename
> WHILE (@.@.fetch_status = 0)
> BEGIN
> SET @.SQLString = N'IF EXISTS (SELECT * FROM ' + @.tablename + ') set
> @.Empty = ''N'' ELSE set @.Empty = ''Y'''
> SET @.ParmDefinition = N'@.tablename sysname, @.Empty char(1) OUTPUT'
> EXECUTE sp_executesql
> @.SQLString,
> @.ParmDefinition,
> @.tablename = @.tablename,
> @.Empty = @.Empty OUTPUT
> IF @.Empty = 'Y' PRINT @.tablename + ' is empty'
> FETCH NEXT FROM FindEmptyTables INTO @.tablename
> END
> CLOSE FindEmptyTables
> DEALLOCATE FindEmptyTables
> GO
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:OreCV6qSFHA.1152@.tk2msftngp13.phx.gbl...
>
|||Ok, run SQL Server Profiler to identify those tables , save the data into a
table in SQL Server and make a query to get report.
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:er2yWhxSFHA.1896@.TK2MSFTNGP14.phx.gbl...
> I don't want to list tables availables, I want to list table REALLY used
> during the loading process.
> I mean tables which is part of a Select statement.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:exlUagvSFHA.3636@.TK2MSFTNGP14.phx.gbl...
>
|||yes, I know...
but what filters, events and columns I have to select to accomplish this?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUm3IlxSFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Ok, run SQL Server Profiler to identify those tables , save the data into
> a
> table in SQL Server and make a query to get report.
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:er2yWhxSFHA.1896@.TK2MSFTNGP14.phx.gbl...
>

how to list all tables used in a database?

Hi,
I want to list all the tables used in a particular database during the
execution of a lot of DTS packages.
I think the profiler could help me, but what is the configuration to
accomplish this?
event, columns, filters...
thanks for your guide
Jerome.Hi
The below script find an emtpy tables , modify it for your needs
use pubs
-- create table and do not populate it
create table EmptyTable (c1 int)
go
-- create a cursor to go through each table in a database
-- and print the name of any empty tables
DECLARE @.SQLString nvarchar (255),
@.ParmDefinition nvarchar (255)
DECLARE @.tablename sysname, @.Empty char (1)
DECLARE FindEmptyTables CURSOR READ_ONLY
FOR SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
OPEN FindEmptyTables
FETCH NEXT FROM FindEmptyTables INTO @.tablename
WHILE (@.@.fetch_status = 0)
BEGIN
SET @.SQLString = N'IF EXISTS (SELECT * FROM ' + @.tablename + ') set
@.Empty = ''N'' ELSE set @.Empty = ''Y'''
SET @.ParmDefinition = N'@.tablename sysname, @.Empty char(1) OUTPUT'
EXECUTE sp_executesql
@.SQLString,
@.ParmDefinition,
@.tablename = @.tablename,
@.Empty = @.Empty OUTPUT
IF @.Empty = 'Y' PRINT @.tablename + ' is empty'
FETCH NEXT FROM FindEmptyTables INTO @.tablename
END
CLOSE FindEmptyTables
DEALLOCATE FindEmptyTables
GO
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:OreCV6qSFHA.1152@.tk2msftngp13.phx.gbl...
> Hi,
> I want to list all the tables used in a particular database during the
> execution of a lot of DTS packages.
> I think the profiler could help me, but what is the configuration to
> accomplish this?
> event, columns, filters...
> thanks for your guide
> Jerome.
>|||I don't want to list tables availables, I want to list table REALLY used
during the loading process.
I mean tables which is part of a Select statement.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:exlUagvSFHA.3636@.TK2MSFTNGP14.phx.gbl...
> Hi
> The below script find an emtpy tables , modify it for your needs
> use pubs
> -- create table and do not populate it
> create table EmptyTable (c1 int)
> go
> -- create a cursor to go through each table in a database
> -- and print the name of any empty tables
> DECLARE @.SQLString nvarchar (255),
> @.ParmDefinition nvarchar (255)
> DECLARE @.tablename sysname, @.Empty char (1)
> DECLARE FindEmptyTables CURSOR READ_ONLY
> FOR SELECT TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> WHERE TABLE_TYPE = 'BASE TABLE'
> OPEN FindEmptyTables
> FETCH NEXT FROM FindEmptyTables INTO @.tablename
> WHILE (@.@.fetch_status = 0)
> BEGIN
> SET @.SQLString = N'IF EXISTS (SELECT * FROM ' + @.tablename + ') set
> @.Empty = ''N'' ELSE set @.Empty = ''Y'''
> SET @.ParmDefinition = N'@.tablename sysname, @.Empty char(1) OUTPUT'
> EXECUTE sp_executesql
> @.SQLString,
> @.ParmDefinition,
> @.tablename = @.tablename,
> @.Empty = @.Empty OUTPUT
> IF @.Empty = 'Y' PRINT @.tablename + ' is empty'
> FETCH NEXT FROM FindEmptyTables INTO @.tablename
> END
> CLOSE FindEmptyTables
> DEALLOCATE FindEmptyTables
> GO
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:OreCV6qSFHA.1152@.tk2msftngp13.phx.gbl...
>|||Ok, run SQL Server Profiler to identify those tables , save the data into a
table in SQL Server and make a query to get report.
"Jj" <willgart_A_@.hotmail_A_.com> wrote in message
news:er2yWhxSFHA.1896@.TK2MSFTNGP14.phx.gbl...
> I don't want to list tables availables, I want to list table REALLY used
> during the loading process.
> I mean tables which is part of a Select statement.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:exlUagvSFHA.3636@.TK2MSFTNGP14.phx.gbl...
>|||yes, I know...
but what filters, events and columns I have to select to accomplish this?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUm3IlxSFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Ok, run SQL Server Profiler to identify those tables , save the data into
> a
> table in SQL Server and make a query to get report.
> "Jj" <willgart_A_@.hotmail_A_.com> wrote in message
> news:er2yWhxSFHA.1896@.TK2MSFTNGP14.phx.gbl...
>

how to list all tables used in a database?

Hi,
I want to list all the tables used in a particular database during the
execution of a lot of DTS packages.
I think the profiler could help me, but what is the configuration to
accomplish this?
event, columns, filters...
thanks for your guide
Jerome.Hi
The below script find an emtpy tables , modify it for your needs
use pubs
-- create table and do not populate it
create table EmptyTable (c1 int)
go
-- create a cursor to go through each table in a database
-- and print the name of any empty tables
DECLARE @.SQLString nvarchar (255),
@.ParmDefinition nvarchar (255)
DECLARE @.tablename sysname, @.Empty char (1)
DECLARE FindEmptyTables CURSOR READ_ONLY
FOR SELECT TABLE_NAME
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_TYPE = 'BASE TABLE'
OPEN FindEmptyTables
FETCH NEXT FROM FindEmptyTables INTO @.tablename
WHILE (@.@.fetch_status = 0)
BEGIN
SET @.SQLString = N'IF EXISTS (SELECT * FROM ' + @.tablename + ') set
@.Empty = ''N'' ELSE set @.Empty = ''Y'''
SET @.ParmDefinition = N'@.tablename sysname, @.Empty char(1) OUTPUT'
EXECUTE sp_executesql
@.SQLString,
@.ParmDefinition,
@.tablename = @.tablename,
@.Empty = @.Empty OUTPUT
IF @.Empty = 'Y' PRINT @.tablename + ' is empty'
FETCH NEXT FROM FindEmptyTables INTO @.tablename
END
CLOSE FindEmptyTables
DEALLOCATE FindEmptyTables
GO
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:OreCV6qSFHA.1152@.tk2msftngp13.phx.gbl...
> Hi,
> I want to list all the tables used in a particular database during the
> execution of a lot of DTS packages.
> I think the profiler could help me, but what is the configuration to
> accomplish this?
> event, columns, filters...
> thanks for your guide
> Jerome.
>|||I don't want to list tables availables, I want to list table REALLY used
during the loading process.
I mean tables which is part of a Select statement.
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:exlUagvSFHA.3636@.TK2MSFTNGP14.phx.gbl...
> Hi
> The below script find an emtpy tables , modify it for your needs
> use pubs
> -- create table and do not populate it
> create table EmptyTable (c1 int)
> go
> -- create a cursor to go through each table in a database
> -- and print the name of any empty tables
> DECLARE @.SQLString nvarchar (255),
> @.ParmDefinition nvarchar (255)
> DECLARE @.tablename sysname, @.Empty char (1)
> DECLARE FindEmptyTables CURSOR READ_ONLY
> FOR SELECT TABLE_NAME
> FROM INFORMATION_SCHEMA.TABLES
> WHERE TABLE_TYPE = 'BASE TABLE'
> OPEN FindEmptyTables
> FETCH NEXT FROM FindEmptyTables INTO @.tablename
> WHILE (@.@.fetch_status = 0)
> BEGIN
> SET @.SQLString = N'IF EXISTS (SELECT * FROM ' + @.tablename + ') set
> @.Empty = ''N'' ELSE set @.Empty = ''Y'''
> SET @.ParmDefinition = N'@.tablename sysname, @.Empty char(1) OUTPUT'
> EXECUTE sp_executesql
> @.SQLString,
> @.ParmDefinition,
> @.tablename = @.tablename,
> @.Empty = @.Empty OUTPUT
> IF @.Empty = 'Y' PRINT @.tablename + ' is empty'
> FETCH NEXT FROM FindEmptyTables INTO @.tablename
> END
> CLOSE FindEmptyTables
> DEALLOCATE FindEmptyTables
> GO
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:OreCV6qSFHA.1152@.tk2msftngp13.phx.gbl...
>> Hi,
>> I want to list all the tables used in a particular database during the
>> execution of a lot of DTS packages.
>> I think the profiler could help me, but what is the configuration to
>> accomplish this?
>> event, columns, filters...
>> thanks for your guide
>> Jerome.
>>
>|||Ok, run SQL Server Profiler to identify those tables , save the data into a
table in SQL Server and make a query to get report.
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:er2yWhxSFHA.1896@.TK2MSFTNGP14.phx.gbl...
> I don't want to list tables availables, I want to list table REALLY used
> during the loading process.
> I mean tables which is part of a Select statement.
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:exlUagvSFHA.3636@.TK2MSFTNGP14.phx.gbl...
> > Hi
> > The below script find an emtpy tables , modify it for your needs
> > use pubs
> >
> > -- create table and do not populate it
> > create table EmptyTable (c1 int)
> > go
> >
> > -- create a cursor to go through each table in a database
> > -- and print the name of any empty tables
> > DECLARE @.SQLString nvarchar (255),
> > @.ParmDefinition nvarchar (255)
> >
> > DECLARE @.tablename sysname, @.Empty char (1)
> >
> > DECLARE FindEmptyTables CURSOR READ_ONLY
> > FOR SELECT TABLE_NAME
> > FROM INFORMATION_SCHEMA.TABLES
> > WHERE TABLE_TYPE = 'BASE TABLE'
> >
> > OPEN FindEmptyTables
> >
> > FETCH NEXT FROM FindEmptyTables INTO @.tablename
> > WHILE (@.@.fetch_status = 0)
> > BEGIN
> > SET @.SQLString = N'IF EXISTS (SELECT * FROM ' + @.tablename + ') set
> > @.Empty = ''N'' ELSE set @.Empty = ''Y'''
> > SET @.ParmDefinition = N'@.tablename sysname, @.Empty char(1) OUTPUT'
> >
> > EXECUTE sp_executesql
> > @.SQLString,
> > @.ParmDefinition,
> > @.tablename = @.tablename,
> > @.Empty = @.Empty OUTPUT
> >
> > IF @.Empty = 'Y' PRINT @.tablename + ' is empty'
> > FETCH NEXT FROM FindEmptyTables INTO @.tablename
> > END
> >
> > CLOSE FindEmptyTables
> > DEALLOCATE FindEmptyTables
> > GO
> >
> > "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> > news:OreCV6qSFHA.1152@.tk2msftngp13.phx.gbl...
> >> Hi,
> >>
> >> I want to list all the tables used in a particular database during the
> >> execution of a lot of DTS packages.
> >>
> >> I think the profiler could help me, but what is the configuration to
> >> accomplish this?
> >> event, columns, filters...
> >>
> >> thanks for your guide
> >> Jerome.
> >>
> >>
> >
> >
>|||yes, I know...
but what filters, events and columns I have to select to accomplish this?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uUm3IlxSFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Ok, run SQL Server Profiler to identify those tables , save the data into
> a
> table in SQL Server and make a query to get report.
> "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
> news:er2yWhxSFHA.1896@.TK2MSFTNGP14.phx.gbl...
>> I don't want to list tables availables, I want to list table REALLY used
>> during the loading process.
>> I mean tables which is part of a Select statement.
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:exlUagvSFHA.3636@.TK2MSFTNGP14.phx.gbl...
>> > Hi
>> > The below script find an emtpy tables , modify it for your needs
>> > use pubs
>> >
>> > -- create table and do not populate it
>> > create table EmptyTable (c1 int)
>> > go
>> >
>> > -- create a cursor to go through each table in a database
>> > -- and print the name of any empty tables
>> > DECLARE @.SQLString nvarchar (255),
>> > @.ParmDefinition nvarchar (255)
>> >
>> > DECLARE @.tablename sysname, @.Empty char (1)
>> >
>> > DECLARE FindEmptyTables CURSOR READ_ONLY
>> > FOR SELECT TABLE_NAME
>> > FROM INFORMATION_SCHEMA.TABLES
>> > WHERE TABLE_TYPE = 'BASE TABLE'
>> >
>> > OPEN FindEmptyTables
>> >
>> > FETCH NEXT FROM FindEmptyTables INTO @.tablename
>> > WHILE (@.@.fetch_status = 0)
>> > BEGIN
>> > SET @.SQLString = N'IF EXISTS (SELECT * FROM ' + @.tablename + ') set
>> > @.Empty = ''N'' ELSE set @.Empty = ''Y'''
>> > SET @.ParmDefinition = N'@.tablename sysname, @.Empty char(1) OUTPUT'
>> >
>> > EXECUTE sp_executesql
>> > @.SQLString,
>> > @.ParmDefinition,
>> > @.tablename = @.tablename,
>> > @.Empty = @.Empty OUTPUT
>> >
>> > IF @.Empty = 'Y' PRINT @.tablename + ' is empty'
>> > FETCH NEXT FROM FindEmptyTables INTO @.tablename
>> > END
>> >
>> > CLOSE FindEmptyTables
>> > DEALLOCATE FindEmptyTables
>> > GO
>> >
>> > "Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
>> > news:OreCV6qSFHA.1152@.tk2msftngp13.phx.gbl...
>> >> Hi,
>> >>
>> >> I want to list all the tables used in a particular database during the
>> >> execution of a lot of DTS packages.
>> >>
>> >> I think the profiler could help me, but what is the configuration to
>> >> accomplish this?
>> >> event, columns, filters...
>> >>
>> >> thanks for your guide
>> >> Jerome.
>> >>
>> >>
>> >
>> >
>>
>

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
thanks in advance
Jamie Thomson
Jamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/com...n/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Mark,
Classroom learning is not an option as I intend to do this off my own back and can't afford a course.
I guess I'm looking for advice on either:
a) Good books for beginners or
b) Free online training resources.
Any advice from someone in the know as to what I should concentrate on would be useful as well.
Thanks for the reply Mark, thats very useful.
Regards
Jamie Thomson
"Mark Allison" wrote:
[vbcol=seagreen]
> Jamie,
> I think this is a rather subjective question. Some people learn best in
> a classroom where they can intereact with a teacher. Others prefer to
> learn from a book where they can work at their own pace and try the
> demos and examples in the book. Others prefer to just dive in and start
> "hacking around" by referring to the MSDN Library when they get stuck.
> You need to decide on whether you would benefit more from a structured
> learning experience, i.e. classroom training, or a self-paced
> experience, such as books, online learning libraries, or MELL.
> I personally prefer a classroom experience for something that I am
> totally new to, and once I have grasped the basics, I prefer to learn
> from books or some other form of self paced learning.
> Horses for courses...
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Jamie wrote:

>
|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>
|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
http://www.amazon.co.uk/exec/obidos/...043104-6361455
Regards,
Paul Ibison
|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your site as well.
Thanks again all.
"Wayne Snyder" wrote:

> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a version
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosity
> about the "new world" of .Net.
> Server-centric learning curve would be preferable.
>
>

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I ha
ve an appreciation of a few development tools such as Visual Basic v5, Java,
C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start
getting up to speed with .Net in advance of Yukon and I figured its about ti
me I started doing the same. I also want to satisfy my own curiosity about t
he "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-c
entric learning curve would be preferable.
thanks in advance
Jamie ThomsonJamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5, Jav
a, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to star
t getting up to speed with .Net in advance of Yukon and I figured its about
time I started doing the same. I also want to satisfy my own curiosity about
the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server
-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/co...rn/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Mark,
Classroom learning is not an option as I intend to do this off my own back a
nd can't afford a course.
I guess I'm looking for advice on either:
a) Good books for beginners or
b) Free online training resources.
Any advice from someone in the know as to what I should concentrate on would
be useful as well.
Thanks for the reply Mark, thats very useful.
Regards
Jamie Thomson
"Mark Allison" wrote:

> Jamie,
> I think this is a rather subjective question. Some people learn best in
> a classroom where they can intereact with a teacher. Others prefer to
> learn from a book where they can work at their own pace and try the
> demos and examples in the book. Others prefer to just dive in and start
> "hacking around" by referring to the MSDN Library when they get stuck.
> You need to decide on whether you would benefit more from a structured
> learning experience, i.e. classroom training, or a self-paced
> experience, such as books, online learning libraries, or MELL.
> I personally prefer a classroom experience for something that I am
> totally new to, and once I have grasped the basics, I prefer to learn
> from books or some other form of self paced learning.
> Horses for courses...
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
> Jamie wrote:
[vbcol=seagreen]
>|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
361455" target="_blank">http://www.amazon.co.uk/exec/obidos...6
361455
Regards,
Paul Ibison|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your
site as well.
Thanks again all.
"Wayne Snyder" wrote:

> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a versio
n
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosi
ty
> about the "new world" of .Net.
> Server-centric learning curve would be preferable.
>
>

How to learn .Net

Hi there,
I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
thanks in advance
Jamie ThomsonJamie,
I think this is a rather subjective question. Some people learn best in
a classroom where they can intereact with a teacher. Others prefer to
learn from a book where they can work at their own pace and try the
demos and examples in the book. Others prefer to just dive in and start
"hacking around" by referring to the MSDN Library when they get stuck.
You need to decide on whether you would benefit more from a structured
learning experience, i.e. classroom training, or a self-paced
experience, such as books, online learning libraries, or MELL.
I personally prefer a classroom experience for something that I am
totally new to, and once I have grasped the basics, I prefer to learn
from books or some other form of self paced learning.
Horses for courses...
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jamie wrote:
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I have an appreciation of a few development tools such as Visual Basic v5, Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to start getting up to speed with .Net in advance of Yukon and I figured its about time I started doing the same. I also want to satisfy my own curiosity about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
a really good place to start is the Modern Software Development seminar
series by Joe Hummel as per link below. VB focussed but does a great job of
explaining the concepts / issues. Also a lot of real world stuff , about
when its best to use certain language / .Net features etc that is missing
from a lot of the other stuff I've seen.
http://msdn.microsoft.com/vbasic/community/webcasts/modern/default.aspx
Andy.
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Hi Jamie
Fernando Guerrero, from my company Solid Quality Learning, has offered a
seminar at various conferences on .NET for the DBA, designed for just this
purpose and is VERY SQL Server centric. We are looking at ways to allow
Fernando to deliver this online in a publicly available format and should
have something scheduled by the end of the summer. Information will be
available on our site when we have all the details in place.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||I agree with Kalen, than Fernando would do an excellent job... You might
also try out some books like the Hitchihikers guide ( if there is a version
for Dot. Net.)
Companies like Learnkey also provide CD, and video based training
(www.learnkey.com)...
Getting involved with a local dot net group would be helpful as well.. (
Perhaps INETA (www.ineta.org) )
And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Jamie" <Jamie@.discussions.microsoft.com> wrote in message
news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> Hi there,
> I'm a SQL Server professional, specialising in DTS & Analysis Services. I
have an appreciation of a few development tools such as Visual Basic v5,
Java, C++ although have never developed anything in anger using them.
> I read everywhere at the moment that SQL Server professionals need to
start getting up to speed with .Net in advance of Yukon and I figured its
about time I started doing the same. I also want to satisfy my own curiosity
about the "new world" of .Net.
> What is the best way to start for someone with my background? A SQL
Server-centric learning curve would be preferable.
> thanks in advance
> Jamie Thomson
>|||Jamie,
if you're already familiar with VB 5/6 then I highly recommend this book:
http://www.amazon.co.uk/exec/obidos/ASIN/0672322641/qid%3D1088783844/202-5043104-6361455
Regards,
Paul Ibison|||Thank you to all. Some very useful information there.
I shall check out Andy's link immediately. Kalen, I'll keep a check on your site as well.
Thanks again all.
"Wayne Snyder" wrote:
> I agree with Kalen, than Fernando would do an excellent job... You might
> also try out some books like the Hitchihikers guide ( if there is a version
> for Dot. Net.)
> Companies like Learnkey also provide CD, and video based training
> (www.learnkey.com)...
> Getting involved with a local dot net group would be helpful as well.. (
> Perhaps INETA (www.ineta.org) )
> And (for sure) surf the Dot net newsgroups as your main forum for Q/A...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Jamie" <Jamie@.discussions.microsoft.com> wrote in message
> news:9D722171-D94A-429D-B989-71ECBEE2EFCD@.microsoft.com...
> > Hi there,
> > I'm a SQL Server professional, specialising in DTS & Analysis Services. I
> have an appreciation of a few development tools such as Visual Basic v5,
> Java, C++ although have never developed anything in anger using them.
> >
> > I read everywhere at the moment that SQL Server professionals need to
> start getting up to speed with .Net in advance of Yukon and I figured its
> about time I started doing the same. I also want to satisfy my own curiosity
> about the "new world" of .Net.
> >
> > What is the best way to start for someone with my background? A SQL
> Server-centric learning curve would be preferable.
> >
> > thanks in advance
> >
> > Jamie Thomson
> >
>
>

How to launch a SSIS package from VB or whatever

Dear all,

I am looking for any snippet of code where you can launch a SSIS package by DMO or VB 6.0. I read that it was posible to call dts.runtime assembly from VB 6.0 but at first it might be converted or something like that.

Issue comes from the moment that we’ve got an ASP 3.0 scheduler for hundreds of dts and now we have to migrate them to sql25k.

Thanks in advance for any info regarding this,

Hey there Enric,

I'm no expert in SSIS.. but I AM reading the Wrox book "Professional SQL Server 2005 Integration Services" which has a chapter on using SSIS with external applications.

If you get the book just look at chapter 17 and you'll find the info you need.

OR you could go to Wrox.com and download the sample code for chapter 17. It contains sample VB to call an SSIS package.

Basically you have to use the Microsoft.SqlServer.Dts.DtsClient namespace...

You import that namespace and use it to connect to the package...

Imports Microsoft.SqlServer.Dts.DtsClient

Then use an DtsCommand to execute the the package.

I don't want to post Wrox's sample code here (don't want no trouble) but if you search in books online for DtsCommand you should find stuff....

Its a bit silly calling an SSIS package with a DtsCommand isn't it?

Very confusing..

PJ

|||

The reason for the false naming is that the product was well into the development cycle when the decision was made to change the name from DTS to SSIS. That decision was actually made around Q3 2004, almost 4 years after development started.

At that late stage in the game it was considered too much of a job to go through and change all the code from DTS* to SSIS*. Its a shame but can't be helped.

Do as all techies do...blame the marketing department :)

-Jamie

|||

On Books online at

http://msdn2.microsoft.com/en-us/library/aa337077.aspx

there's an extensive coverage on how to run SSIS packages remotely.

You may need to be a bit seasoned developer to go through it and run it though, as the documentation is not a step-by-step instruction.

Rgds,

How to launch a SSIS package from VB or whatever

Dear all,

I am looking for any snippet of code where you can launch a SSIS package by DMO or VB 6.0. I read that it was posible to call dts.runtime assembly from VB 6.0 but at first it might be converted or something like that.

Issue comes from the moment that we’ve got an ASP 3.0 scheduler for hundreds of dts and now we have to migrate them to sql25k.

Thanks in advance for any info regarding this,

Hey there Enric,

I'm no expert in SSIS.. but I AM reading the Wrox book "Professional SQL Server 2005 Integration Services" which has a chapter on using SSIS with external applications.

If you get the book just look at chapter 17 and you'll find the info you need.

OR you could go to Wrox.com and download the sample code for chapter 17. It contains sample VB to call an SSIS package.

Basically you have to use the Microsoft.SqlServer.Dts.DtsClient namespace...

You import that namespace and use it to connect to the package...

Imports Microsoft.SqlServer.Dts.DtsClient

Then use an DtsCommand to execute the the package.

I don't want to post Wrox's sample code here (don't want no trouble) but if you search in books online for DtsCommand you should find stuff....

Its a bit silly calling an SSIS package with a DtsCommand isn't it?

Very confusing..

PJ

|||

The reason for the false naming is that the product was well into the development cycle when the decision was made to change the name from DTS to SSIS. That decision was actually made around Q3 2004, almost 4 years after development started.

At that late stage in the game it was considered too much of a job to go through and change all the code from DTS* to SSIS*. Its a shame but can't be helped.

Do as all techies do...blame the marketing department :)

-Jamie

|||

On Books online at

http://msdn2.microsoft.com/en-us/library/aa337077.aspx

there's an extensive coverage on how to run SSIS packages remotely.

You may need to be a bit seasoned developer to go through it and run it though, as the documentation is not a step-by-step instruction.

Rgds,

How to launch a dts 2000 from Framework 2.0?

Either c# or vb samples are welcomed.

Thanks in advance,

any idea?|||

What issues do you have?

You can simply call DTSRUN.EXE to execute the package.

Or you can use the object model - the usage is well documented in SQL 2000 books online, the VB code with minor changes can be used in VB.NET; you need to reference "Microsoft DTS Package Object Library" COM type library just like you would do in VB.

|||

Basically our application must be able to throw dts 2000, too. (apart from dtsx)

thanx

How to launch a dts 2000 from Framework 2.0?

Either c# or vb samples are welcomed.

Thanks in advance,

any idea?|||

What issues do you have?

You can simply call DTSRUN.EXE to execute the package.

Or you can use the object model - the usage is well documented in SQL 2000 books online, the VB code with minor changes can be used in VB.NET; you need to reference "Microsoft DTS Package Object Library" COM type library just like you would do in VB.

|||

Basically our application must be able to throw dts 2000, too. (apart from dtsx)

thanx