Hi,

Add the necessary column in the create statement.

Change the order of the insert and then use the below statement.

Declare @sql varchar(max);

set @sql= STUFF((select ', MAX(case when...

Try this...

DECLARE @cols AS NVARCHAR(MAX),

@query AS NVARCHAR(MAX)

select @cols = STUFF((SELECT ',' + QUOTENAME(ColumnName)

...

Hi,

I'm not sure !!!! but from the error message which you have listed seems to be error in calling an SP, where you are passsing dates as an input paramter......

i need to change the value of connections property by opening the xml and editing it. if i changed the value then that should be refelected in the SSIS packages......

I have updated all the stats all ..., but eventually it is showing the same performance issue...is there anything i need to update??????

Could you post your issue properly???

You can use bulk insert if you don't have any transformation. otherwise you can use SSIS for transformation.

Hi,

Could you send me the steps and code that how you solved this task thr' WMI?

Help is highly appreciated.....

hi,

I don't think that there is a dependency between control flow and data flow, since you are setting the property in the control flow, so that won't return only single...

Hi,

Anybody came accross above issue.....If you have any options, let me know...

I don't know whether the below method satisfies your need...

While transformation, convert the numeric column into varchar datatype and check the flat file.....

Create a column which has old and new data for the date . First import the data in to an old column and then update the new column with...

Hi,

Is it a homework???:-)

Set can be used only to intialize a single variable.

Select can be used to intialize a single variable or more than that..

pls find the queries below:-

List all the departments that don’t have any employees. (Without using sub query)

SELECT * FROM DEPARTMENT DEP

WHERE NOT EXISTS

(SELECT 'DEP' FROM EMPLOYEE EMP

WHERE EMP.DEP_ID=DEP.DEP_ID)

List the departments...

hi

could you explain how to incorporate the log file????