| Author |
Topic |
|
fred simons
Starting Member
9 Posts |
 Posted - 2012-02-23 : 09:18:24
|
Hi there,
I'm stuck with this problem.
I have this sales.xls file to import. The month (and year) of the sales is recorded in the second row of the sheet. So how can I read it, transform it and set a new output column with a proper date ?
(I'm quite confident about the last 2, reading is my problem)
should I set some kind of variable ? what tools from the dataflow should I use ?
thank you in advance
fred
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-23 : 09:32:09
|
how are you importing from excel file? is it through data flow task or using execute sql task?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
 |
|
|
fred simons
Starting Member
9 Posts |
Posted - 2012-02-23 : 09:48:51
|
through data flow task
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-23 : 09:53:05
|
is there some description on row containing month and year info ?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
fred simons
Starting Member
9 Posts |
Posted - 2012-02-23 : 10:03:07
|
here is the complete value of the cell(A2):
VENDITE DICEMBRE 2011
this is what I will have to translate to 01/12/2011
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-23 : 10:07:46
|
quote:
Originally posted by fred simons
here is the complete value of the cell(A2):
VENDITE DICEMBRE 2011
this is what I will have to translate to 01/12/2011
ok
you can one thing
if row is fixed you can add a rownumber transformation inside data flow and then look for row with value 2. then use a conditional logic to convert month and day to equivalent numbers
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
fred simons
Starting Member
9 Posts |
Posted - 2012-02-23 : 10:17:16
|
rownumber transformation
Ican't see this one in my toolbox? Is this an addon or something ?
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-23 : 10:20:43
|
http://www.sqlis.com/sqlis/post/Row-Number-Transformation.aspx
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
fred simons
Starting Member
9 Posts |
Posted - 2012-02-23 : 10:25:28
|
Many many thanks !
|
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-02-23 : 14:54:24
|
welcome
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
|
setting variable and data from the 1st row