Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tooba
Posting Yak Master
224 Posts |
 Posted - 2014-01-28 : 22:07:18
|
| Hi Guys, I have one question, I Schedule my SSIS package to Copy All Directry file using "File System Task" (All are SSIS Packages) from one server to other as a back up, I just notice after i copy from one server to other server All Flat File Source or Destination "Text Qualifier" Option change to somethinge.g "c_090_9489" and so on. Is anyone can help me to fix this issue. Thank You in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-29 : 04:25:03
|
| hmm...need more information. are you doing it inside a loop? whats the extension you're looking for? can you give us high level overview of the package?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
tooba
Posting Yak Master
224 Posts |
Posted - 2014-01-29 : 10:40:48
|
| My SSIS Schedule transfer all Files from the Directory to other server. Not inside a Loop, Simple "File System Task" no extension, all files. Please let me know if you have any questions, thanks for helping... |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2014-01-30 : 07:24:22
|
quote:
Originally posted by tooba
My SSIS Schedule transfer all Files from the Directory to other server. Not inside a Loop, Simple "File System Task" no extension, all files. Please let me know if you have any questions, thanks for helping...
File System Task will not cause any chances to File Content so I'm not sure whether problem you're facing is because of the package.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
SSIS Package Transfer Help