We have not used any tools to compare, but the same solution is being used between both Cubes and the underlying Data sources.

I am positive that they are having the...

Hi Damion,

Have you tried the select and update queries separately.

Run them and see if they are working fine.?

HI,

I have created a similar query to yours and it works fine for me. So the problem must be with the syntax. Kindly check it once.

Create Procedure Test(@SCAC Varchar(50))

AS

Begin

Select SCAC,...

Hi eugene,

Have a look at the below URL. It will help you...

http://stackoverflow.com/questions/9530983/ssis-execute-first-task-if-condition-met-else-skip-to-next

Hi Krasavita,

IN the properties change the Protection Level from "Encrypt Sensitive with User Key" to "Encrypt Sensitivity with Password" and enter a password in package password.

Now you can run this...

Hi ,

You can get the desired result quiet easily...

The below mentioned code will solve your problem.

Select ID, Name, 'The City name is ' + Name Comment

From #tTemp1

Hi Sivaji,

The below procedure must solve your problem...

Use SSISTest

GO

-- Exec SplitStringInsert '1-2,2-3,3-5,4-4,14-14,10-9684'

Alter Procedure SplitStringInsert (@String Varchar(8000))

AS

Begin

Declare @BeginingPosition int;

Declare @TrunPosition int;

Declare @Length int

--Set @String = '1-2,2-3,3-5,4-4,14-14,10-9684'

Set @BeginingPosition = 0

Set @Length =...

[font="Times New Roman"]Hi Sathyan,

If i understand correctly the value 'XXX' is getting replaced by NULL in the excel sheet.

If thats the case can you give us some example for the...

Hi rhythmk,

I have listed the properties i am storing below.

FILE Path(File name):C:\Users\testuser\AppData\Local\Microsoft\Windows\Temporary Internet Files\Content.IE5\OEZNMMLB\FlatFile.data

Server Name: 10.58.56.964

User Name:TestUser

Password:********

Initial Catalogue:Data Source=10.58.56.964;User ID=TestUser;Initial Catalog=msdb;Provider=SQLNCLI10.1;Persist Security Info=True;Auto Translate=False;Application Name=SSIS-dtsTrailerPoolLoad-{E108C483-DA03-486D-BD30-697C8548FB7E}10.48.253.28.msdb.TestUser;

Database Name:TrailTest

Hi Koen,

The Configuration Table is Placed in MSDB system database.

As far as Configuration goes we are giving the server details and other required information and saving the data in...

Hi bhuvneshk,

I have tried those methods already but still i am getting the error...

Hi bhuvneshk,

II run the package using BIDs...

Hi Koen,

We are using Package Configuration to store the details in the Configuration table...

Thanks,

Karthick.

Hi,

We have created another connection manager which will have the server details of the Configuration table.

The Configuration Table is placed in msdb system database and SQL Server authentication is used..

Thanks,

karthick

The Table in where the configurations were done from

SSIS ---> Package Confiruration

Thanks...