Elliott Whitlow (6/29/2010)

---

You know Cozy, I recommend people look at your components quite a bit, I might need to download them and spend some time looking at them in greater...

Tim Mitchell (6/28/2010)

---

Has anyone had any experience setting up an SSIS package (or other ETL mechanism) to automagically import a data file received as an e-mail attachment? I've got...

afilipao20 (6/24/2010)

---

Hi all, I'd appreciate very much if someone could answer my question bellow.

I created an SSIS package using the Export and Import wizard that exports some tables from SQL...

Dipak,

Of course you are correct. I forgot about this approach. There is one shortcoming though. You cannot enlist in the current transaction.

You have to have the provider in the following folder:

C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

and on 64bit machine here as well:

C:\Program Files (x86)\Microsoft SQL Server\90\SDK\Assemblies

Also you have to have at least SQL...

Celita (6/17/2010)

---

I have an Excel source file that has some rows with a line feed carriage return in the Address1 columns of the file. This causes SSIS to think it...

If you can use third-party solutions, check the commercial CozyRoc Script Component Plus. It is an extension of the standard Script Component and you can access the list of columns...

Hari.Sharma (6/11/2010)

---

There is reason why codeplex is best solution: We need to...

Hari.Sharma (6/11/2010)

---

Best way to load SharePoint Lists into SQL Server table is to use codeplex solution SharePointListAdaptersSetup.msi

Click here to downloaded this.

After running this msi, two SSIS Data Flow controls...

dg227 (6/11/2010)

---

Partially: if you run PowerShell using COM objects to extract the data, then yes, Office is required and will load on the machine that the script runs on. ...

dg227 (6/11/2010)

---

Just another thought on Excel books that you don't control: parsing the Excel to a flat file using PowerShell or Perl is very handy, and also avoids metadata issues,...

If you use SQL 2008, you can use the out-of-the-box ADO.NET...

If you can use third-party solutions, check the commercial CozyRoc Excel components. These are the relevant components:

* Excel Source component - for reading data from Excel...

If you can use third-party solutions, check the commercial CozyRoc Excel components. These are the relevant components:

* Excel Source component - for reading data from Excel...

If you can use third-party solutions, check the commercial CozyRoc Excel components. These are the relevant components:

* Excel Source component - for reading data from Excel...