SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS Package Transfer Help
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tooba
Posting Yak Master

143 Posts

Posted - 01/28/2014 :  22:07:18  Show Profile  Reply with Quote
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 something
e.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

India
52309 Posts

Posted - 01/29/2014 :  04:25:03  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

tooba
Posting Yak Master

143 Posts

Posted - 01/29/2014 :  10:40:48  Show Profile  Reply with Quote
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...
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52309 Posts

Posted - 01/30/2014 :  07:24:22  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000