David Brea (6/10/2009)

---

Hi there.

Has somebody exported a Select (TSQL) result set to a DBF file (DBase iv, FoxPro 2.0 Dos).

How you did it?

Import, it the easy way,...

If the XML format is same then you can setup the XML source to be configurable and use different...

This is not the correct discussion to post your question....

washawgolla (6/9/2009)

---

I have a DTS package which imports xml data into a table; I have vb script in ActiveX script to accomplish this

see sample code

Dim objBL

Set objBL = CreateObject("SQLXMLBulkLoad.SQLXMLBulkLoad")

objBL.ConnectionString...

This should be easy....

Have you checked Todd McDermid's SCD component?

This is not the best place to ask this question. This is "SQL Server Integration Services" forum. Try in the TSQL forum.

ruchi (6/4/2009)

---

Hi, I am working on Recordset destination in SQL server 2005, But the problem is:

Whenever I am trying to specify a variable name : "It says that...

Another approach you can use is to configure a flat file reader where:

1. First column separator is ;

2. Second column separator is [space]

3. Third column separator is [CR][LF]

And then import...

I think reading should be enough because the...

anjali.vishwakarma (5/31/2009)

---

Also the system I am going to deploy my package will not have SQL server installed in it. It will be just a web server. Integration Services is a...

anjali.vishwakarma (5/31/2009)

---

Thanks Cozyroc.

By SSIS Framework you mean Integration Services. Right ?

Also what about the sharing part ? Do we need to set some sharing rights on the folder...

anjali.vishwakarma (5/28/2009)

---

If we deploy the SSIS package on our web server using file system deployment, what all needs to be installed on that server so that we can call and...

anandhakrishnabca (5/28/2009)

---

Hi,

I have to pull the data from one database to another database(Using OleDB Source and Destination Controls). Both are SQL Db's. I created...

ramchaitanya_4 (5/28/2009)

---

I need to call an SSIS package from stored procedure using dtexec utility. My SSIS package is deployed in a different machine than my database server. My package is...