|
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.
|