You have two options:

create a proxy through TSQL, or use the Management Studio Interface.

I think the last one will be the easiest.

At which step did you get that error?

If SSIS 2012 isn't an...

The connection will be the same. The credentials using that connection will however be that of the proxy account.

When you go to the certification website, there's usually a Learning Plan associated with that certification. It contains useful links to articles, white papers and books.

Try doing as much as...

Sure you can solve it. Do not use the local system account 🙂

Or execute the job through a proxy.

Creating SQL Server Agent Proxies

Is it possible to log into the server as that proxy account and try to execute the package manually?

Duplicate post. Original topic can be found here:

http://www.sqlservercentral.com/Forums/Topic1266572-391-1.aspx

amit.sinha-717308 (3/14/2012)

---

This has fixed the problem. Thanks.

It shows me warning

[ADO NET Source [1]] Warning: Rows sent to the error output(s) will be lost. Add new data flow transformations or destinations...

Excel does not support the entire TSQL syntax.

If the number of rows isn't that big you can use the SORT component to delete the duplicates for you.

If performance is an...

You can store the username and password in a configuration file/table and use package configurations to alter the connection manager.

Unless there's a way to use some sort of Windows Authentition...

Which column is "columna02"?

Descripcion, cantidad or costo?

ps: you'll have more luck with English on this site.

You do realize this thread was from 2009, right?

I sure hope the OP has already mastered MS BI right now.

(furthermore, wouldn't it have been more useful to blog about...

Log into SSAS using SSMS.

Locate your cube database, open the dimensions and right click on the dimension that you want to change. Choose Script Dimension As and select ALTER To....

BIDS is 32-bit, but when running a package it emulates a 64-bit environment by default.

This can cause issues with the Excel connections, as there is usually not a 64-bit JET...

If you leave it to General, you have 2 different...