The first error is almost certainly caused because you copy-pasted an SSIS package from another source, or imported it from another source, and the connection manager which that source used...

First off, instead of using DT_DECIMAL, I'd recommend using DT_NUMERIC. Since you're dividing by 100, I assume you're looking for a value with two decimal places. This will allow you...

An easy way to solve that would be to just put a Script Task in, and pass the variable into the script task, then put a MessageBox command in your...

Is the error happening when you run the package, or just when you save it?

Either way, the best way to deal with these sort of situations, is to just not...

This is just a theory, since I haven't used AS400 -

SSIS sometimes has issues with trying to automate certain things that would otherwise seem normal to do. What may be...

So you want, for each of the 10 companies and four regions, an output? In other words, a cross join of the two, resulting in a total of 40 outputs?

In...

The problem is one that I've faced several times, and it's because the default encryption level is EncryptSensitiveWithUserKey.

The problem is that the User Key is something specific to a machine....

Are you sure you encased your statements properly?

I've reformatted your query to make it a bit more readable, and placed the brackets in the appropriate places. Try it out and...

honestly, the fastest solution will probably be to just delete and re-create each element which is throwing an error. you might be able to find another solution, but i doubt...

Cursors are evil things ... maybe something related to cursors is causing your problem

Try this version instead:

CREATE TABLE #TempDatabaseNames

(

ID INT IDENTITY,

DatabaseName VARCHAR(250)

)

INSERT INTO #TempDatabaseNames (DatabaseName)

SELECT DatabaseName

FROM UserDatabasesToBackup

JOIN sys.sysdatabases ON...

A somewhat ugly and brute-force solution, but which would probably work for you, is to get the output exactly as you've posted, with the extra pipes at the end. Output...

EDIT ***

I think I see your problem. You're not doing typecasts correctly.

Both your numerator and denominator are integer values. Try it - SELECT 1 / 2 will result in a...

VS_NEEDSNEWMETADATA shows up when the underlying data behind one of the tasks changes. In your case, if the data that is being obtained from the database has changed, then your...

Yeah I really should remember to preface all suggestions that I post which involve xp_cmdshell with a comment like that. Sometimes I forget that the databases which I work with...

I find running the things from a script instead of the agent is a much more reliable way of getting the Encrypt things to work. Try this instead:

EXEC xp_cmdshell 'dtexec...