|
Comments
|
Jason Nupen on
12/10/2008
It moved pretty quick which wasn't too bad but if possible I'd like to see more on the use of a Variable to rename the file so we can add a '200812' type designation.
|
|
|
Variables -- As noted from a previous viewer -- use of variable to append date/time to filename would be a useful addition to the training video.
|
|
|
Pretty concentrated one.. thank you..
|
|
Michael Wells on
2/10/2009
Gave me exactly the answer that I needed without taking a lot of time.
|
|
|
It was very enlightening to see the File System task being performed, and that it has all the important capabilities ... but I must say that the presenter operates pretty quickly, so I may want to see it again some time ... perhaps after playing with it a bit.
|
|
kalakotireddy on
2/18/2009
It was fast but good job
|
|
|
I needed information on using variables with these tasks, and that was not provided.
|
|
|
It would be useful to talk about using UNC, if possible, within an SSIS package.
|
|
|
good
|
|
|
Greate file system task intro...
|
|
|
good man
|
|
|
Good but basic
|
|
|
I would like more about use of variables when moving files by adding a date/time to the file name.
|
|
|
spoke too fast....I couldn't understand a lot of what he was saying; couldn't see a lot of what he was doing until he enlarged some window pics.
|
|
|
how do you add a date time stamp to the renamed file?
|
|
|
Great video with quick examples
|
|
|
How did you know that I needed to figure out file renaming for a project today?
|
|
|
Voice is a little too fast. Good use of zoom to highlight screen areas.
|
|
|
Keep the SSIS videos coming, love them!
|
|
|
another great video
|
|
|
Ditto on the data time. I would like a video on how to go through a series of files named, say, Sales_East.txt, Sales_Midwest.txt and Sales_West.txt, put them all in a staging table, AND move each one to an archive folder while appending the date and time to the file name so it comes out Sales_East060520091032.txt, Sales_Midwest060520091033.txt, etc.
|
|
|
Can you move folders to another destination if say the folder has the word closed at the end of the folder name?
|
|
|
the speaking is a little fast and more real world examples a the end.
|
|
|
short and excellent demo
|
|
|
1 day too late. I spent yesterday trying to figure out how to do this. I think the tricky part of what I was doing though is rename the file based on a variable and a timestamp. Otherwise, good video. Thanks!
|
|
|
This example package was run locally. Try installing the package on a server and scheduling it and see how well it works. You will run into permisions issues with file system and even permissions to read the .net assemblies if you are running .Net script.
This is how most developers will use and there is very little on how to accomplish this without running into a world of pain.
|
|
|
Nice one
|
|
|
Too fast.
|
|
|
good stuff to know!
|
|
|
Can SSIS use wildcards to locate the files to feed the task?
|
|
|
Most people should know how to do this. You should have focused on something a bit more complicated.
|
|
|
This was simple and easy but valuable. Good to see couple of test cases.
|
|
|
How abt the network path in place of the local path ? Will that work there as well.
|
|
|
I cannot believe this guy is considered to be such an expert in SQL Server and have such terrible speaking skills...
|
|
|
Nice, quick examples
|
|
Carney Clegg on
6/23/2009
Good video, Thanks for sharing it.
|
|
|
Loved the step by step instructions. Thanks
|
|
|
would have liked it to include the check if a file existed
|
|
vasu contact on
7/12/2009
I would have been nice ahd it demonstrated the variable destination. I think that was demoed in a different video.
|
|
Kishor Bandi on
7/13/2009
It was quite helpful
|
|
|
Had already used Move, Copy and Delete. Didn't know what Rename would. Very helpful
|
|
Jay Ravindran on
7/15/2009
Good work...keep goin....
|
|
|
Nice one!
|
|
|
thankss
|
|
|
shows only basic file operations, would be intersting to see how to pass other variables to append to the filename
|
|
|
Good basic stuff. You move your mouse a little fast at times, and the thing we really need is the variables stuff, but I finally figured it out.
|
|
|
I'd like to have seen how to use a var as part of the new filename for the Rename File task. I'd like to append a date-time stamp to my archived file. I can figure it out, I'm certain, but it would have been a good addition.
|
|
|
gr8,Keep sending such stuff
|
|
|
too fast
|
|
|
Could have gone a little into how to add date/time stamp on the file when you rename it instead of the hard-coding. But still a pretty good video.
|
|
|
What about creating a file with the date created as part of the file name?
|
|
|
very helpfull, thank you!
|
|
|
The images appear fuzzy on my system, despite my hires screen
|
|
|
The guy should talk a little slower.
|
|
Kevin Taylor on
2/13/2010
Using the File System Task in SSIS - video, is great.
-----------------
I have an issue where I use the RS command and xp_cmdshell in an SSIS package to export a report to excel for certain clients who have up to 150 fleets, each excel fleet file going to each fleets folder (folder: Fleet1, folder: Fleet2). The issue I am experiencing is that when the size of the exported file goes over 1.5 MB (2.1 MB in this case) and the file location for saving the file is on a network drive then file size is 0 kb. If I save the exported file locally on the report server then the file size is 2.1 MB (it works). If I schedule the same report via a subscription and the file location for saving the file is on a network drive then file size is 2.1 MB (it works). The RS command uses a .RSS file (vbscript) so I assume this file might be the culprit. Can anyone assist. Email: sonyt65@yahoo.com
|
|
|
Excellent!
|
|
|
Excellent, but can I play it at half speed???
|
|
|
hard coding file names is a no brainer
better to show example with variables and dynamic file names
|
|
|
What if I want to add a connection to the file on the network which involves network credientials.
|
|
Mukul Janeja on
3/13/2010
It will be nice to see how variables are used within connection to point to files such as *.xml and delete/rename/move.
|
|
James Florey on
6/27/2010
It doesn't show how to rename a file without moving it.
|
|
Furqan Iqbal on
6/28/2010
Way too Fast, Doesn't show where to set the Variables, just too fast.
|
|
|
good video - how do we ssis to copy all of the files in one folder to another folder?
|
|
|
Keep posting good things
|
|
|
We need it for multiple files.
Like move example on multiple files.
|
|
|
Bit too fast
|
|
|
Excellent
|
|
|
Good video. Very helpful.
|
|
Joe DeMarco on
12/22/2010
I really wish the displayed content window were bigger, making the code easier to see as it is being shown.
|
|
|
Very good. If an option is discussed, it should be shown (variables)
|
|
Marcelo Marim on
12/22/2010
A bit too fast. You could take it a little bit slow like a minute or two more.
But in general it was good stuff...
|
|
Jamshid Nouri on
12/22/2010
excellent ssis filesys demo. short and very effective example.
|
|
Dan McCrady on
12/22/2010
great subject, poor presentation.
|
|
|
Excellent video!
|
|
|
Very useful. My only complaint is that the instructor is moving extremely fast through this, so it is hard to keep up.
|
|
|
very blurry but very informative
|
|
Thomas Kelley on
12/22/2010
Thanks for taking the time to provide this info. I know it's basic stuff, but please slow down a litte.
|
|
|
I liked the added effects (zoom in, red arrow, highlighter, etc)
|
|
|
Too small and too fast.
|
|
|
I dont know something was strange about host. I think he was going to fast and I am used to Andy's voice. Ahaaa! now i get it. His microphone, if he adjusts the volume so that there is less noise and pitch in it and slows down his presentation just a little bit. It would be great.
|
|
|
Is it possible to print a file, using this?
|
|
Rudy Nichols on
1/11/2011
Should have examples of working with dynamic variables too...
|
|
Maurice Ivory on
2/11/2011
It was cool....
|
|
|
vv good
|
|
|
Great presentation.Very helpful..Thanks!!
|
|
Howard Rosen on
5/11/2011
I would have liked to see renaming a file with a timestamp apended to it
|
|
|
Excellent videos. But Brian has to slow down on the coffee intake before recording these videos :-) (talks and runs threw the examples way to fast).
Thanks for your work though. Excellent material.
Rich
|
|
|
excellent.. help me full.. thanks..
|
|
Robert Turner on
8/13/2011
Good demo, Thanks
|
|
|
the announcer spoke waaaay to fast. Since the task being reviewed is a very simple function and the fact that I am unfamiliar with the software (This would probably be the primary audience for this task). it seems to me he would slow down just a bit.
|
|
|
if you some knowled on variable , dynamically add date on the rename
|
|
|
nice simple video with 1 topic covered. Keep them up
|
|
Dennis Walker on
10/25/2011
How about rename to include a time stamp?
|
|
Mike Nicholas on
10/25/2011
Very nice, thank you Brian. Makes me wonder how to deal with handling multiple files at once vs just a single file.
|
|
David Walker on
10/25/2011
Choppy video
|
|
|
good
|
|
|
Good and Fast
|
|
|
Great video, great instructor. very very useful
|
|
|
nice renaming,moving,deleting the file
|
|
|
This was great! Can you show how to dynamically rename moved files that were processed to include the processed date?
|
|
|
Presenter speaks too quickly
|
|
|
Great tips, presented quickly and concisely.
|
|
|
a good introduction
|
|
|
Very good video, useful for a number of projects I will be doing soon!
|
|
ML Stephens on
11/21/2011
needed this
|
|
|
Usefull, but very quick, and zooming in and out.
|
|
|
Excellent
|
|
|
excellent
|
|
|
I wish for a follow up video, where you could rename the file using a pattern. For example dynamically add a date or a time stamp to the name.
|
|
Bruce Bealer on
11/30/2011
Way too fast. Could not keep up and follow the moves. If the videos continue to be this fast I will stop watching them.
|
|
|
It would be nice if the video can play smoothly without a lot of stop and start.
|
|
Kris Robinett on
12/5/2011
This presenter talks way too fast. Luckily this is not a very complex function of SSIS.
|
|
|
very nice...........
vijay raj gupta
|
|
|
Nice Video
|
|
|
Nice video, thanks boss
|
|
Tom McMaster on
1/28/2012
Simple explanation that's clear and makes sense. Well done.
|
|
|
Nice vedio
|