setting variable and data from the 1st row

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

setting variable and data from the 1st row

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/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources