Daniel Forrester 123 (12/13/2012)

Using the advanced editor does work but I have quite few packages with this problem.

I'm pretty sure the problem is related to the MSSQLToSSIS10.XML mapping file but...

I have noticed that some point rankings give "special statuses".

Do you have a good reason to use AutoShrink? Because it will mess up the fragmentation of your indexes.

As far as I know this isn't possible in SQL Server.

You could create a computed column that takes the first 5 characters of your column and put an index on...

Another option is to make sure your dataflow doesn't fail: add an error destination after the regular destination and set the destination to redirect error rows.

This doesn't help when your...

Normally if the...

What if you change the datatype of the output column in the advanced editor? Does that work?

What do you mean?

"I did not give any permissions to the package"

or

"I haven't received any permissions on the package"

Maybe SQL Server thinks you're trying to write a correlated subquery. Since there's no WHERE clause, you'll get the "no join predicate" warning.

It might. The package will need access to the external database, so ports probably will have to be opened. And you're transfering data over the network, so there might be...

It depends.

In SSIS 2012 you have two ways of developing your packages:

* using the project deployment model (brand new and too much to explain in a forum post)

* using the...

The error is quite clear:

The account used to run the package (I guess the SQL Server Agent account) doesn't have permission to open the package.

You're sure that each and every of those 20 locations has data?

Is there a filter somewhere? (either in the report, or in the data source view, or somewhere else?)

If you look at the actual execution plan, you'll see that the nested loops (left semi join) has a warning sign. It says: "no join predicate". What basically means the...

Nice question, thanks.