We help IT Professionals succeed at work.

Views or stored procedure

ohemaa
ohemaa asked
on
621 Views
Last Modified: 2013-11-05
I need to select * from Customer Table on Server A(sql 2005) and dump the output into
a text file on server B  every night at 10.00 PM.  Any ideas. I am thinking of using a view.  Any better suggestions
                                                                                                                                                     
Comment
Watch Question

Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Commented:
You could use SSIS to do that. Use the Import/Export wizard and then schedule it as a job when you are satisfied with the results.

Author

Commented:

Can you show me how to using SSIS

 Select * from customer
  into serverb.customertextfile    
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Is there another way of doing this other than using SSIS

Select * from customer on server A
  into a textfile on server B every night
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
I am getting this error using ssis. The customerdescription field has a  type  Ntext.  I am exporting data from a table to flat text file...How can I get past this error
----------------------------------------------------------------------------------------
- Validating (Error)
      Messages
      * Error 0xc020802e: Data Flow Task: The data type for "input column "CustomerDescription" (167)" is DT_NTEXT, which is not supported with ANSI files. Use DT_TEXT instead and convert the data to DT_NTEXT using the data conversion component.
       (SQL Server Import and Export Wizard)

Commented:
It sounds as if you are exporting a text file (customerdescription) that is defined with the NText data type. You can convert that to text (instead of ntext) and the ANSI file will accept that.

Author

Commented:
I changed the datatype to text and received the same error

Author

Commented:
Link explains "If you trying to extract data from a flat file and got the following error"  I am doing vice versa.  I am extracting data from sql table into a flat file......any other inputs will be greatly appreciated
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.