|
Comments
|
Jim Phillips on
12/4/2008
Just what I was looking for.
|
|
Dick Rosenberg on
12/14/2008
I have wanted to know how to do this in SSIS ever since I started learning SSIS. Thanks!
|
|
|
nice thank u
|
|
|
it is a good video but must be still have explained the time graph in a detailed manner
|
|
|
DO you also have a video how to add timestamp to an .mdb file?
|
|
|
h
|
|
|
Its really a good video
|
|
|
How to add a timestamp to a table
|
|
|
qqqqqq
|
|
|
Good.Keep going..
|
|
|
thanks Brian Knight it was very helpfull to each ssis learner
|
|
|
Easy to understand. Great tip.
|
|
|
concise and very instructive.
|
|
|
I really appreciate the SSIS videos, especially because I am very inexperienced with it. Please keep them coming!
|
|
|
I had to do this last week, but the format of the date string they wanted was very specific. Moreover I had a feeling they would change their minds. I created some variables and pass them into an SSIS script task, build the connection string, and assign it to a variable. That variable is used in an expression for the file connection string. Now they can adjust what values are passed to the variable in the SQL Agent job and I never have to touch the SSIS package when they change their minds...
|
|
Thomas Kelley on
2/10/2009
As always, thanks.
|
|
|
It's good that you show some of the issues that might arise with any particular solution.
|
|
Raalnan Five on
2/10/2009
First video I have watched on the site. There was no real lead in to tell me what I was watching, so I just jumped in at the first video.
|
|
|
Great video. I really like it when you make a mistake and then show how to correct it; as opposed to everything going smooth. I would like to see a tutorial on assigning a variable to the path. You kind of skimmed through that at the end.
|
|
Terence Tully on
2/12/2009
Awesome...as always, Brian has a knack for breaking down and explaining tasks that makes it easy and relevant to learn!
|
|
|
I like it! Not only the videos are awesome, but the questions after that make me think of what I've just watched and remember it easier!
|
|
|
Everyday real life example, excellent value.
|
|
|
Very good connectionstring.
|
|
|
Very good vedio with goood example
|
|
|
this video is very good, now ilearn how to use exprtion for connection string
|
|
|
This is great! A 6 minute video allows me to do what would have taken hours to correctly find on the net!
Thanks jumpstartTV!!!
I will post this link on twitter.
|
|
|
Fantastic demo. Keep it up!
|
|
|
good video. Appreciate your working through the errors, more 'real world' like.
|
|
|
Great video!, but would rather you use the variable approach to be more real-world.
|
|
Jeremy Pryor on
4/30/2009
Absolutely love the Zooming in/out, red arrows, red underlining, and the red circle beacon type flash in this presentation. Completely Awesome, it just adds to an already exceptional training session.
|
|
|
good one brother.
|
|
|
ss
|
|
|
Good video. Short and right on the spot!
|
|
|
excellent learning resourse
|
|
|
video to small to see clearly.
|
|
|
THANK YOU! This, combined with assigning the file mod date/time to a variable, was exactly what I needed to do today! This was the clearest explanation I found.
|
|
|
i love the this way of learning, it saves me a lot of time reading multiple materials, more power
|
|
|
This solved one of the biggest problems I was facing in SSIS. It is amazing how misleading some of the dialogs are, such as for Connection Managers.
|
|
|
Just what i needed thanks
|
|
|
To the point and precise instructions. Good job.
|
|
|
Question # 2 was worded poorly
|
|
|
Cool stuff! Thanks, Brian!
|
|
|
very good
|
|
|
Good one!
|
|
|
Nice work Brian and beautifully presented.
|
|
|
Great video! I just wish you had zoomed in on the expression that included the timestamp with the replace function to remove colons. I really wanted to do a screen capture on that one.
|
|
|
good .. was very helpful
|
|
|
Nice One!
|
|
|
Excellent video
|
|
Rhys Domingo on
9/30/2009
Wasn't clear on how to use the connection string after you make the changes in this video.
|
|
|
Little fuzzy on screen
|
|
Trudie Pearcy on
10/12/2009
This works great for flat file destinations, but I can't get it to worik at all on Excel file destinations.
|
|
|
wish i got the code
|
|
|
Not enough context, otherwise good
|
|
|
I really enjoyed this video and spent quite a few days trying to find out exactly how to add a timestamp to a flat file. The only problem i'm having now is that my timestamp won't parse, I get a truncation error and i'm using the exact same code as in the video. Not matter what I try it just doesn't work.
|
|
rupesh sharma on
12/15/2009
very informative
|
|
|
Great demo, thanks.
|
|
|
It would be good if we could read what you are doing. Only when you are zooming in we see it.
|
|
|
thank you
|
|
|
voice with vedio streaming is breaking due to network or internet.
|
|
|
simple and effective
|
|
|
Exactly what I was trying to solve, yet very concise. THANKS!!!!
|
|
|
thx..it was useful
|
|
|
good
|
|
|
very nice to understand.txs a lot.
|
|
|
I would love to see the final code as something I can copy-paste having watched the video... :-)
|
|
|
great video guys
|
|
|
When I use "C:\\TEST\\Archive\abc.txt"+ "_"+ (DT_WSTR, 40)(DT_DBDATE)GETDATE() it works fine. Now I want to add time like you do: "C:\\TEST\\Archive\abc.txt"+ "_"+ (DT_WSTR, 40) (DT_DBDATE) GETDATE() + (DT_WSTR, 40)(DT_DBTIME)GETDATE()
and get error message “A truncation occurred during evaluation of the expression.” But it works in your video just fine! We are on SQL2008. What could be the problem? Thank you very much.
|
|
|
to the point, clear.
|
|
|
bad sound
|
|
|
excellent!
|
|
|
Can you pls provision something so we can download and watch it full screen ? thanks, bobby
|
|
|
The explanation was okay but built on a previous understanding of the DT functions and the expression concept both of which are new to me
|
|
|
uiygjhlk
|
|
Cosmin Tornea on
4/12/2010
super
|
|
|
excellent
|
|
|
Great video! You hard coded the file name and path, but mentioned that you could have used a variable. I tried that, but am getting an error message on the last FINDSTRING about "@" not being recognized. How do I get around that?
|
|
|
some time video is not cleare. rest of all are good.
|
|
|
Great video, showed my just what i wanted step by step.
|
|
|
Exactly what I was looking for. Love these videos
|
|
|
It ia very usefull
|
|
|
good
|
|
|
Video was great. I get following error when I try to rename file using this method, any idea why? TITLE: Package Validation Error
------------------------------
Package Validation Error
------------------------------
ADDITIONAL INFORMATION:
Error at Restraints [Connection manager "DestinationConnectionExcel"]: The connection string format is not valid. It must consist of one or more components of the form X=Y, separated by semicolons. This error occurs when a connection string with zero components is set on database connection manager.
Error at Restraints: The result of the expression ""\\fh1adcb\\clientdata\\DTSData\\Restraints" +(DT_WSTR, 30)(DT_DBDATE) GETDATE() + " "+REPLACE((DT_WSTR, 30)(DT_DBtime) GETDATE(), ":", "")+ ".xls"" on property "ConnectionString" cannot be written to the property. The expression was evaluated, but cannot be set on the property.
(Microsoft.DataTransformationServices.VsIntegration)
------------------------------
BUTTONS:
OK
------------------------------
|
|
|
great explaination!
|
|
|
work as it says on the tin.
Thanks.
|
|
|
Excellent
|
|
|
Awesome trick !
|
|
|
ok
|
|
Mike Nicholas on
8/18/2010
Pretty good! I've been having trouble doing some file system tasks using variables in order to manipulate some flat files, so I was hoping this tutorial would incorporate the variables based on expressions rather than just the expression alone.
|
|
Chris Freund on
10/14/2010
Great video... Need a few more closeups when typing the code (for Newbies like me)
|
|
|
Helped me to understand how to concatenate date and time into a file name.
|
|
|
This question was asked to me in one of the interview recently. I thought of making expressing that uses getdate(). But, it needs lot of tids and bits to make it works.Great video. Thanks
|
|
|
Please, make it available for download. I am collecting such great videos.
|
|
|
Great article.
|
|
|
I do it in DTS with the help of VB script, In SSIS its quite simple. Thanks for sharing knowledge Brian :)
|
|
|
very nice
|
|
|
Very nice solution. I have done this but this is a more elegant solution.
|
|
|
how would you change the format of the date i.e. to yyyymmdd
|
|
|
Blurry screen
|
|
Howard Rosen on
7/14/2011
It was a little hard to see on my computer
|
|
|
Question one should say date instead of time.
|
|
Robert Gibson on
7/14/2011
I really needed to see this particular video! Thanks a lot!
|
|
|
Love the series, though I wish the video was in higher resolution. It is hard to read the code and blurry with the window maximized.
|
|
|
Thorough presentation with a quick recap at the end.
|
|
|
FileNames with the date examples are everywhere on the internet, but adding the time to a file name for a process that runs multiple times per day is not easy to find. This questions was asked by a co-worker yesterday and this is very clearly shown for an example to pass along. Thanks.
|
|
|
you MUST be psychic - I needed this about a 1/2 hour ago...
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
|
the function used to strip the time is db_dbtime and not the 2nd option.
|
|
Keith Cooper on
7/14/2011
keep these type of short videos coming. the speaker is easy to understand and the content is much needed.
|
|
|
Thank you!
I knew about expressions, but I learned another way of getting the date in there. I have always done Year + Month + Day before. I'll try this way too.
|
|
|
A bit too fast.
--Would like to be able to copy the conclusiong.
|
|
Edgar Machado on
7/16/2011
Speak slower and more clear. Slow down in the presentation.
|
|
jayamanjunath on
7/17/2011
when i try with this code "c:\\dummy\\personcontact"+ (DT_WSTR,30) (DT_dbDATE) GETDATE() + (DT_WSTR,100) (DT_DBTIME) GETDATE()+".csv" i am getting an error
a truncate occured during evaluation of the expression
where has if i not concateing the + (DT_WSTR,100) (DT_DBTIME) GETDATE() the code executes pls help in this regards
|
|
|
we should use different formmatting functions to convert datetime into string.
|
|
|
Thank you for the tip about DT_DBDATE! I've been using a very lengthy bit of code to extract the year, month, and day, and place zeroes in front of single-digit months and days... doh!
|
|
Cynthia Weers on
8/15/2011
ANDY LEONARD is as life-saver... One learns so much from so many different sources, it's tough to remember where to go look when you want to recall something... This website is amazing!
|
|
|
pronunciation is faster
|
|
|
Best way to kick off SSIS.Thanks
|
|
Maurice Ivory on
11/28/2011
I like this one, I think I will go over it again.
|
|
mohannareshv on
1/19/2012
It is good for learners. Thanks
|
|
mohannareshv on
1/19/2012
It is good for learners. Thanks
|
|
|
Awesome
|
|
|
Good video. First time on your site. Will come back soon.
|
|
|
Could not see all data flow task's objects
|
|
|
simply superb
|
|
|
thanks
|
|
|
Excellent guide
|
|
|
gud test,i got confidence
|