dbTalk Databases Forums  

SQL Server 2005 DTS /SSIS

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts SQL Server 2005 DTS /SSIS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss SQL Server 2005 DTS /SSIS in the microsoft.public.sqlserver.dts forum.



Reply
Page 1 of 5 1 2 3 4 5 >
 
Thread Tools Display Modes
  #1  
Old   
Test Test
 
Posts: n/a

Default SQL Server 2005 DTS /SSIS - 09-11-2008 , 11:46 PM





I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!


*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
  #2  
Old   
Gerald Aichholzer
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-12-2008 , 01:16 AM





Hi Test,

Test Test wrote:
Quote:
I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!
have a look at the following blog article:
http://blogs.conchango.com/jamiethom...3/01/1093.aspx

In general Jamie's blog is a great resource for ssis tipps and tricks.

regards,
Gerald


Reply With Quote
  #3  
Old   
Gerald Aichholzer
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-12-2008 , 01:16 AM


Hi Test,

Test Test wrote:
Quote:
I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!
have a look at the following blog article:
http://blogs.conchango.com/jamiethom...3/01/1093.aspx

In general Jamie's blog is a great resource for ssis tipps and tricks.

regards,
Gerald


Reply With Quote
  #4  
Old   
Gerald Aichholzer
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-12-2008 , 01:16 AM


Hi Test,

Test Test wrote:
Quote:
I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!
have a look at the following blog article:
http://blogs.conchango.com/jamiethom...3/01/1093.aspx

In general Jamie's blog is a great resource for ssis tipps and tricks.

regards,
Gerald


Reply With Quote
  #5  
Old   
Gerald Aichholzer
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-12-2008 , 01:16 AM


Hi Test,

Test Test wrote:
Quote:
I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!
have a look at the following blog article:
http://blogs.conchango.com/jamiethom...3/01/1093.aspx

In general Jamie's blog is a great resource for ssis tipps and tricks.

regards,
Gerald


Reply With Quote
  #6  
Old   
Gerald Aichholzer
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-12-2008 , 01:16 AM


Hi Test,

Test Test wrote:
Quote:
I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!
have a look at the following blog article:
http://blogs.conchango.com/jamiethom...3/01/1093.aspx

In general Jamie's blog is a great resource for ssis tipps and tricks.

regards,
Gerald


Reply With Quote
  #7  
Old   
Gerald Aichholzer
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-12-2008 , 01:16 AM


Hi Test,

Test Test wrote:
Quote:
I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!
have a look at the following blog article:
http://blogs.conchango.com/jamiethom...3/01/1093.aspx

In general Jamie's blog is a great resource for ssis tipps and tricks.

regards,
Gerald


Reply With Quote
  #8  
Old   
Gerald Aichholzer
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-12-2008 , 01:16 AM


Hi Test,

Test Test wrote:
Quote:
I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!
have a look at the following blog article:
http://blogs.conchango.com/jamiethom...3/01/1093.aspx

In general Jamie's blog is a great resource for ssis tipps and tricks.

regards,
Gerald


Reply With Quote
  #9  
Old   
Gerald Aichholzer
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-12-2008 , 01:16 AM


Hi Test,

Test Test wrote:
Quote:
I am a SQL Server 2000 developer and recently moved to SQL Server 2005
environment. I need to know what is the equivalent of "dynamic
properties task" in SQL server 2005. What is the process of setting up
global variables in SQL 2005? The pkgs, I have written in SQL 2000, are
machine independent (no hard coded values) using dynamic properties task
and global varibles. I used DTSRUN utility to pass values to the GVs and
I want to do the same in SQL 2005. Any help would be appreciated!
have a look at the following blog article:
http://blogs.conchango.com/jamiethom...3/01/1093.aspx

In general Jamie's blog is a great resource for ssis tipps and tricks.

regards,
Gerald


Reply With Quote
  #10  
Old   
Test Test
 
Posts: n/a

Default Re: SQL Server 2005 DTS /SSIS - 09-14-2008 , 12:02 AM


This infomration helps. The 'Expressions' (in SSIS) seem to be working
as 'Dynamic Properties Task' as I have been able to create GVs, assign
properties to it using Expressions and pass the vlaues form job code
(T-SQL) using DTSX utility.

Another question: In SSIS, how do I select multiple columns in source
and destination columns and make it a single transmformation (as it is
in DTS 2000).

Thanks



*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
Reply
Page 1 of 5 1 2 3 4 5 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top