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