Concentrate on this error:

"The version of component "Flat File Source" (363) is not compatible with this version of the DataFlow"

It looks like there is a mismatch between the SSIS version...

Paul_Harvey (12/8/2009)

---

Hi All,

For reasons outlined in my previous topic, http://www.sqlservercentral.com/Forums/Topic829742-148-1.aspx, I need to find a way to automatically edit an XML file to replace ampersand characters with either & or...

No, it is not possible. You have to have...

rfugikawa (12/7/2009)

---

Hello,

I need to identify if a flat file is Unicode or not by SSIS (Script Task). It's happens because sometimes the file's sponsor creates a file in a Windows...

If you are looking for easier encryption alternative and can use third-party solution, check the commercial CozyRoc OpenPGP Task.

If you can use third-party components, check the commercial CozyRoc Lookup component. You can load the flat file in...

stricknyn (11/20/2009)

---

CozyRoc (11/20/2009)

---

You can definitely load your data directly in data set. However you have to implement a script component for that. Regarding the release of the COM object I...

Can you include the complete error message?

Writing correct CSV parser is not trivial. I would suggest you find existing code and use it as a starting point. This project looks promising.

I would suggest you manually process this irregular file by implementing source script component.

Check strFiles if it is NULL. It should be something like

If Not strFiles Is Nothing Then

...

paul.pauldj54 (11/27/2009)

---

Hi:

I'm trying to assess the data inside a SQL Server 2005 database. I'm using the profiling task of the SSIS 2008.

I'm selecting all the profile request in the profile...

stricknyn (11/20/2009)

---

I see. That's interesting because I always thought objects were ByVal when declared instead of ByRef. So that means Im assuming that if I change some data...

stricknyn (11/20/2009)

---

Oh, forgot one last question on this. If I load the data right into datatable object in my first dataflow task, do I have to declare an instance...

stricknyn (11/20/2009)

---

CozyRoc (11/20/2009)

---

You can definitely load your data directly in data set. However you have to implement a script component for that. Regarding the release of the COM object I...