Variable Pane and Path

Question

Post reply

Variable Pane and Path

yrstruly

Hall of Fame

Points: 3440
More actions
December 1, 2016 at 10:01 pm

#401150

I am following examples in the book: Microsoft SQL Server 2014 Businesss Intelligence Development
In Ch.4 page 103 they are talking about set the path to Customers_1.csv file. No where in the chapter do they refer to this csv file(can be dowloaded or create it yourself).
I dont know if i should create it myself and they dont show you how to set its path to this document. Can anybody assist me please? The book seem to be unclear in some exercises.
Full book or chapter can be viewed by using the following link:
https://drive.google.com/open?id=0ByFnKe4djAO-d29ZTUJrbExhbzQ

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

DamianC SSCrazy Eights Points: 8015 More actions · Answer 1

I suspect this means, set the Value to Customer_1.csv

- Damian

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 2

I interpret it as meaning the path to the Customer_1.csv file, something like "c:\MyCSVs". There's a section on page 5 Downloading the example code. Can you find the csv file if you go to the location specified there?

John

yrstruly Hall of Fame Points: 3440 More actions · Answer 3

yrstruly

Hall of Fame

Points: 3440

December 2, 2016 at 4:34 am

#1915664

Thank You!

How do i set the path (in "Variables")?

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 4

If you're just doing this to follow along with an exercise, set the value of the variable by typing it into the pane. If you're doing it with the intention of putting it live, you'll want to read about package configurations. This will enable you to set change the value of the variable without having to edit the package file. Package configurations are a bit old-school (but I can't remember what the replacement is called).

John

yrstruly Hall of Fame Points: 3440 More actions · Answer 5

I have set the path in the Variable Pane and i'm getting an error. Can it be in the Variable Pane or some where else?

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 6

Your screenshot doesn't show the whole value of the variable. Does it include the name of the csv file? Have you tried it with and without? Please will you also post the expression that sets the value of the connection string for the connection manager?

John

yrstruly Hall of Fame Points: 3440 More actions · Answer 7

Thank you i manged to get it right.

On page 99 (https://drive.google.com/open?id=0ByFnKe4djAO-d29ZTUJrbExhbzQ) they give this expression: YEAR(GETDATE()) - YEAR((DT_DATE)BirthDate

I get an error when trying to do this. I left this out and manage to finish the task, only to have no data loaded in the table or am i wrong?

John Mitchell-245523 SSC Guru Points: 148809 More actions · Answer 8

yrstruly (12/8/2016)
Thank you i manged to get it right.

Please will you share what you did? It will help anyone who's having a similar problem to yours.

On page 99 (https://drive.google.com/open?id=0ByFnKe4djAO-d29ZTUJrbExhbzQ) they give this expression: YEAR(GETDATE()) - YEAR((DT_DATE)BirthDate
I get an error when trying to do this. I left this out and manage to finish the task, only to have no data loaded in the table or am i wrong?

The reason for the error is given at the very top - there is no such column as BirthDate. Is this in a Data Flow? Make sure that the BirthDate column is among the output columns of the previous source or transformation, and in the input columns of the one the error appears in. I can't be any more specific than that without seeing the whole package.

John