Sounds very similar to the problem I had. See link to this site

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=120028#bm120824

It looks like a permisssions problem. When you run the package from designer it uses the...

Not exactly.

You need to add an additional column in the dimension table and populate it using left(col,1)+000 or likewise to achieve your goal in the normal way.

However, you can create...

You can do the same thing on the application as well if you are using one. In crystal reports and business objects I never create variables using division without setting...

Check out this site. It gives you step by step instructions including screen shots. Helped me out the first time.

http://www.databasejournal.com/features/mssql/article.php/3073161

Every friend I have introduced to Ken Henderson's "The Guru's Guide to Transact-SQL" has liked it and recommended it onto someone else.

An absolute definite.

Apologies for my code with the update inside the function. You cannot do this, but you can update the table from a value called from a function - which was...

Jeff is quite right. I have this all the time. Another reason is when the structure of the table changes and the linked tables are not updated. Need to run...

If you are going to be using this code regularly it might be worth creating a function like:

create function fnIntCount

(@location varchar(1))

RETURNS INT

AS

BEGIN

declare @nextNumber int

select @nextNumber = intcount from table1 where...

We have not got mauil set up on the server. I think I will go the dts route. That way I can also keep a history of log files if...

You cannot use normal select statements for dynamic sql. Use exec() or sp_executesql or a combination of both. Check BOL for more info. This is another good site: http://www.sommarskog.se/dynamic_sql.html

...

There is no inherent function in sql.

Even in vb you need to loop through the characters to perform the task.

You are looking at writing a script using the 'substring' function...

Try SET NOCOUNT ON

I can't see any parameters in qa apart from the amount of text to bring back - Maximum characters per column on Tools/Options/Results

If you want the heavy stuff with all the functionality look at Cognos Reportnet or Business Objects Webi.

Expensive, but gives you all the functionailt including letting users build their own...

Thanks. That is what i am doing. My manager wants to be able to log on to qa every morning and run the job in my absence without having to...

Check you service pack settings and mdac version on both servers. Sounds like it is poitning in that direction somehow.