by Peter Plimpto » Fri, 20 Dec 2002 06:26:00
by Allan Mitchel » Fri, 20 Dec 2002 06:30:08
http://www.sqldev.net/dts/DotNETCookBook.htm
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
Quote:> Hi-
> I would like to create a vb.net application which creates a dts package.
The
> package would include a number of data transformations. Using SQL-DMO I
> would retrieve the field names from each table in a list of table names.
> Looping through these field names I would build a dts data transformation
> task for each table. I'm working in SQL7 but will be working in sql 2000
> within three months.
> Is this possible? If so, I'm looking for some sample code and resource
> recommendations.
> Thanks,
> Peter
by Peter Plimpto » Fri, 20 Dec 2002 06:44:56
> http://www.sqldev.net/dts/DotNETCookBook.htm
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> > Hi-
> > I would like to create a vb.net application which creates a dts package.
> The
> > package would include a number of data transformations. Using SQL-DMO I
> > would retrieve the field names from each table in a list of table names.
> > Looping through these field names I would build a dts data
transformation
> > task for each table. I'm working in SQL7 but will be working in sql 2000
> > within three months.
> > Is this possible? If so, I'm looking for some sample code and resource
> > recommendations.
> > Thanks,
> > Peter
by Allan Mitchel » Fri, 20 Dec 2002 07:06:48
"She" is a "he" and a pretty big and ugly one at that <grin>
Gert will field questions on specifics on this NG in general
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
> > You may want to start here
> > http://www.sqldev.net/dts/DotNETCookBook.htm
> > --
> > Allan Mitchell (Microsoft SQL Server MVP)
> > MCSE,MCDBA
> > www.SQLDTS.com
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> > > Hi-
> > > I would like to create a vb.net application which creates a dts
package.
> > The
> > > package would include a number of data transformations. Using SQL-DMO
I
> > > would retrieve the field names from each table in a list of table
names.
> > > Looping through these field names I would build a dts data
> transformation
> > > task for each table. I'm working in SQL7 but will be working in sql
2000
> > > within three months.
> > > Is this possible? If so, I'm looking for some sample code and resource
> > > recommendations.
> > > Thanks,
> > > Peter
by Peter Plimpto » Fri, 20 Dec 2002 07:21:57
> "She" is a "he" and a pretty big and ugly one at that <grin>
> Gert will field questions on specifics on this NG in general
> --
> Allan Mitchell (Microsoft SQL Server MVP)
> MCSE,MCDBA
> www.SQLDTS.com
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
> > Thanks Allan-
> > Some good clues here.
> > I'll have to email Gert to find out if she has anything on the
> programmatic
> > creation of packages. She lists that subject in her TOC but I think only
> as
> > a placeholder at the moment.
> > Peter
> > > You may want to start here
> > > http://www.sqldev.net/dts/DotNETCookBook.htm
> > > --
> > > Allan Mitchell (Microsoft SQL Server MVP)
> > > MCSE,MCDBA
> > > www.SQLDTS.com
> > > I support PASS - the definitive, global community
> > > for SQL Server professionals - http://www.sqlpass.org
> > > > Hi-
> > > > I would like to create a vb.net application which creates a dts
> package.
> > > The
> > > > package would include a number of data transformations. Using
SQL-DMO
> I
> > > > would retrieve the field names from each table in a list of table
> names.
> > > > Looping through these field names I would build a dts data
> > transformation
> > > > task for each table. I'm working in SQL7 but will be working in sql
> 2000
> > > > within three months.
> > > > Is this possible? If so, I'm looking for some sample code and
resource
> > > > recommendations.
> > > > Thanks,
> > > > Peter
1. Converting DTS Package to VB.NET
I converted a package to VB
and then am trying to convert to VB.NET. However it
chokes on the following saying "text" is not a valid
property.
oTransProps = oTransformation.TransformServerProperties
oTransProps.Item("Text").Value = ....
The vb6 code that was generated from Sql Server had "oTransProps("Text") =
..." which I changed to the vb.net syntax of
"oTransProps.Item("Text").value = ...."
This is in the sub called oCustomeTask1_Trans_Sub1
where a transformation occurs.
Thanks for any help you could provide,
Ned Kraushaar
Atlanta, Georgia
3. QueryInterface Error with DTS Package in VB.Net
4. Error with pervasive ODBC 16
5. Execute existing DTS package from VB.Net
7. Executing DTS Packages using VB.NET fails
8. compound SQL queries and DISTINCT problem
9. Activate DTS Package from Web page via asp.net (VB)
11. Executing DTS package from VB.net