Can you give some example of what you are trying to do? Table ddl would be nice.

SSIS has the import column transformation, it may be worth checking that one out.

Try using the dt_ntext data type in ssis

Nice question, thanks.

There must have been some error somewhere.

Either the connection string in the configuration table is incorrect, or SSIS could not find the configuration table.

Do you have logging enabled in the...

Not really (although someone made a shortcut: Clear Report...

No problem, glad it worked out.

If you already have a Visual Studio solution that contains the package, open that one and edit the package.

If not, either create a new solution or use an existing one...

What if you delete the script component, add a new one and copy paste only the following piece of code into the main() function?

bool failure = false;

bool fireAgain = true;

foreach...

Go to the folder where the report is stored. There is probably a cached data file with the extension .DATA. Delete that file and try again.

I have never worked with STATA before, but is there a place somewhere where you can specify credentials?

Or maybe you can specify those in the ODBC connection itself when you...

craig.bobchin (6/11/2014)

---

I have it set to true for the connection manager which made no difference, but see no where in either...

martiankeeper (6/11/2014)

---

What I find slightly confusing is the line in this Article here

SQL Server 2014 - What's New in Analysis Services and Business Intelligence

http://msdn.microsoft.com/en-us/library/bb522628.aspx

Multidimensional models now also support queries using...

It might be possible to add a custom data source extension, but I have never done it before.

Take a look at this page:

Data Sources Supported by Reporting Services (SSRS)

Also set DelayValidation on the package to true.

What is the error?