 | |
DataRowsToSkip
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: DataRowsToSkip -
08-13-2008
, 07:22 AM
|
On 8 Aug., 22:16, "Brian Mahloch" <bmahl... (AT) live (DOT) com> wrote: Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are much appreciated. are you talking about dts from sql2000 - import from textfile? yes! use the dynamic property task. left mouse click - Properties - Add - Connections - Textfile - OLEDB Properties - skip rows - double click on default value. now you can select in between different sources. i prefer the "query" to store all meta-information of etl within a database kr moby |
#12
| |||
| |||
|
|
On 8 Aug., 22:16, "Brian Mahloch" <bmahl... (AT) live (DOT) com> wrote: Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are much appreciated. are you talking about dts from sql2000 - import from textfile? yes! use the dynamic property task. left mouse click - Properties - Add - Connections - Textfile - OLEDB Properties - skip rows - double click on default value. now you can select in between different sources. i prefer the "query" to store all meta-information of etl within a database kr moby |
#13
| |||
| |||
|
|
On 8 Aug., 22:16, "Brian Mahloch" <bmahl... (AT) live (DOT) com> wrote: Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are much appreciated. are you talking about dts from sql2000 - import from textfile? yes! use the dynamic property task. left mouse click - Properties - Add - Connections - Textfile - OLEDB Properties - skip rows - double click on default value. now you can select in between different sources. i prefer the "query" to store all meta-information of etl within a database kr moby |
#14
| |||
| |||
|
|
On 8 Aug., 22:16, "Brian Mahloch" <bmahl... (AT) live (DOT) com> wrote: Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are much appreciated. are you talking about dts from sql2000 - import from textfile? yes! use the dynamic property task. left mouse click - Properties - Add - Connections - Textfile - OLEDB Properties - skip rows - double click on default value. now you can select in between different sources. i prefer the "query" to store all meta-information of etl within a database kr moby |
#15
| |||
| |||
|
|
On 8 Aug., 22:16, "Brian Mahloch" <bmahl... (AT) live (DOT) com> wrote: Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are much appreciated. are you talking about dts from sql2000 - import from textfile? yes! use the dynamic property task. left mouse click - Properties - Add - Connections - Textfile - OLEDB Properties - skip rows - double click on default value. now you can select in between different sources. i prefer the "query" to store all meta-information of etl within a database kr moby |
#16
| |||
| |||
|
|
On 8 Aug., 22:16, "Brian Mahloch" <bmahl... (AT) live (DOT) com> wrote: Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are much appreciated. are you talking about dts from sql2000 - import from textfile? yes! use the dynamic property task. left mouse click - Properties - Add - Connections - Textfile - OLEDB Properties - skip rows - double click on default value. now you can select in between different sources. i prefer the "query" to store all meta-information of etl within a database kr moby |
#17
| |||
| |||
|
|
On 8 Aug., 22:16, "Brian Mahloch" <bmahl... (AT) live (DOT) com> wrote: Is there anyway to set the DataRowsToSkip property at runtime? I've tried using an expression but it just gets ignored. Any suggestions are much appreciated. are you talking about dts from sql2000 - import from textfile? yes! use the dynamic property task. left mouse click - Properties - Add - Connections - Textfile - OLEDB Properties - skip rows - double click on default value. now you can select in between different sources. i prefer the "query" to store all meta-information of etl within a database kr moby |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.