SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 
        
Home       Members    Calendar    Who's On



DTS with Activex & FTP Expand / Collapse
Author
Message
Posted Friday, March 27, 2009 3:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 07, 2009 7:07 AM
Points: 1, Visits: 8
Hello,

I would like to create a TAB file "category.txt" with the header - categoryid categoryname parentid categorydescription categoryimage categorybottomdescription categorydisplaytitle categorydisplayordergroup pageDescription pageKeywords
FROM a SQLQuery Result - SELECT * FROM tblcategory.

I would like to create a DTS package so I can automate the process of creating category.txt file.

After creating the category.txt file I would like to ftp it to the different server. And also I would like to automate this process.

Would it be possible for me to do?

I would really appreciate your help. Thanks in advance.

Shuchi-


Post #685405
« Prev Topic | Next Topic »


Permissions Expand / Collapse