I found a solution using the HTTP Connection manager and changing the values for the parameter using Script task.

I found this solution.

I tested and works OK!, since the files are the same every month you can use variables to hold the file names.

take at look

http://www.sqlis.com/post/Downloading-a-file-over-HTTP-the-SSIS-way.aspx

to...

Provider:

Microsoft OLE DB Provider for ODBC Drivers

Product Name: (Not Required)

DataSource:

YourDesireDataSourceNAME

Provider String:

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

Location: (Not Required)

Catalog:

myDatabase

You can find a Solution here.

http://microsoft-ssis.blogspot.com/2011/05/download-source-file-from-website-with.html

you can use

Data Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

for the ODBC

You can created the Linked server using OLEDB Provider for ODBC Connection (You need to attach the file to an SQL 2000 Instance)

Data Source=SERVER;Initial Catalog=Data;User Id=YOURUSR;Password=yourpassword;

& you will be...

I found a Solution to my problem.

It was caused for and index using the wrong data type in a pivot table, in 32 Bits worked fine, but in 64 Bits...

Were you able to find a fix ..?

I have the same problem.

Thanks .