Yes I could open the package in visual studio

Hi I need one help from u, I am also gettign error while executing package from cmd. Could you please help?

I am getting below two error

1.Unable to load the package...

AND another error I am getting is Unable to load the package as XML because package doesnt have valid xml format.

Hi John,

Thank you very much, but one more point it is a known issue in SQL.When we use linked server we may get this error.

Hi I would ike to know which deployment tool can be used for automatic deployment from one region to another. Not only for dotnet projects, whatever projects may be i...

Hi suresh thank u very much for ur explanation.

Thank U guys... The link provided by u helped me a lot. :):-)

Hi guys thanks, the issue is resolved. I just taken the value for @columname inside while loop. actually i was taking @column name value from @leantemp temporary table. Now i...

DECLARE @LEANTEMP TABLE

(

ID INT IDENTITY(1,1),

SETUPDETID BIGINT ,

LEVELVALUEID BIGINT,

METRICSID BIGINT,

METRICNAME VARCHAR(250), ...

Yes I am passing only value to this

SELECT convert(datetime, '10/19/2011 2:00:00 PM') -- mm/dd/yyyy

SELECT CONVERT(VARCHAR(10), '2012-08-17 00:00:00.000', 111) AS [YYYY/MM/DD]

Hi thanks i understood the usage of path, the query is returning the result set as an xml

Can u please tell the exact scenario, Do u need to show all the entries in trans1 table in single row with the loan Number?

Thank u Swarna 🙂

yes this is the correct solution, Do u have any function for that