I will try your options and get back to you.Thank You

When the data is getting loaded from a Table to another table. Temp file location in Windows is getting filled up and SSIS package is failing.

Tried to use BlobTempStoragePath...

Joe,
Thank You very much for the Help. It worked like a charm.

Msg 156, Level 15, State 1, Procedure vw_TestC, Line 2

Incorrect syntax near the keyword 'CREATE'.

create table dbo.#QueryResults 
(
QResults VARCHAR(MAX)
)

INSERT INTO dbo.#QueryResults(QResults)
select 
'CREATE VIEW ' + 'vw_' + t.name + CHAR(13) + 'AS ' + CHAR(13) + 'SELECT * ' +...

DECLARE @SourceDB SYSNAME ;
DECLARE @TrgtDB SYSNAME

SET @SourceDB = 'DatabaseA'
SET @TrgtDB = 'DatabaseB'

DECLARE @CreateViewStatement NVARCHAR(MAX) 
SET @CreateViewStatement = '
      USE '+ QUOTENAME(@TrgtDB) +';
     ...

The issues is in the schema. I was able to find it and fix it.

I had given select permissions on Object 'projects',database 'SSISDB',schema 'catalog' . But that did not help either

I got the issue resolved by running as an admin user.

Thank You for looking into the Issue.

Structure of the Table in the database is same as the table in the spreadsheet

I was able to deploy the package using ISDeploymentWizard.exe on the destination server. There is a flat file which is used as a source in the package. when the...

Hi Scott,

The code is using left outer join. The code is working. But i am not getting the exact count of the data.

Thank You very much for looking into this.

Thank...

Hi,

I am converting the code into Netezza. Netezza doesnt like the correlated sub queries.

Thank You,