On the machine that I reinstalled BIDS and it launched using my login it did not work for the Developer who uses that machine.

Similar situation on another machine. I log...

Yes that is what I initially thought. I should have mentioned it.

I reinstalled BIDs on one of the PC's that...

I going to try and reinstall BIDS on this one PC?

I had someone connect to another machine and they are to start BIDS and validate the SSIS Package rather quickly....

I take it that you do not use DB2 or Oracle...

The DB2 equivalent to WITH (NOLOCK) is described in the following post:

http://www.sqlservercentral.com/Forums/Topic1040710-338-1.aspx#bm1040762

I need to correct a statement that I made with respect to the OPENQUERY being slow.

The OPENQUERY itself is not necessarily slow because it is using a Linked Server to...

shannonjk (12/17/2012)

---

Robert, the source table is in the lookup transform itself. So I do not know of a way to feed that and change the data types. I have tried...

What is the actual error that you are getting?

The reason that I ask is because I get a bogus truncation error or about a dozen tables from DB2 to staging.

If...

The following is a function that converts an AS400 Date Format to SQL Server.

Credit Jeff Moden.

CREATE FUNCTION [dbo].[udf_ConvertDB2toSQL](@CSC_DATE varchar(7))

RETURNS DateTime

AS

BEGIN

IF (LEN(ltrim(rtrim(@CSC_DATE))) = 6)

BEGIN

SET @CSC_DATE= '0' + @CSC_DATE

END

...

MSSQL_NOOB (12/14/2012)

---

CREATE VIEWS permission denied in database 'DBNAME'.

Edit:

I actually found http://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/bfd630bc-e405-4f9d-b63f-f673b3f4ccf5/

that has the same issue. They are saying it was a bug...

I tested the function using a Date in the 20th Century and it does not work.:hehe:

DECLARE @MyDate DATETIME2

SET @MyDate = '1999-01-01'

SELECT dbo.fncConvertSQLToAS400Date(@MyDate)

:blush:

I created a simple function to convert the Date.

CREATEFUNCTIONdbo.fncConvertSQLToAS400Date

(@SQLDateDateTime2)

RETURNSINT

-------------------------------------------------------------------------------------------

AS

-------------------------------------------------------------------------------------------

BEGIN

DECLARE@rtnAS400DateINT

SET @rtnAS400Date =

(SELECT cast(datepart(yyyy,@SQLDate) - 1900 as varchar(4))

+ cast(datepart(mm,@SQLDate) AS varchar(2))

+ cast(datepart(dd,@SQLDate) AS varchar(2)) )

RETURN @rtnAS400Date

END

DECLARE @MyDate DATETIME2

SET @MyDate...

What is the specific Error Message?

How did you verify that there is not an explicit deny for that User?

EXEC sp_helprotect NULL, 'UserName'

Is that User...

I tested it and it works:

SELECT *

FROM T1 ;

Are you using SQL Server 2012?