Tried to run the job , but this time I changed the path of the source file. Instaed of the network folder , I set up a local folder in...

If I login with my windows or sa credentials and run the pkg manually from the solution , it gets imported. But when I run the pkg as a job...

This expression is in the File system task to move the file from one directory to another with yyyymmddhhmmss_Filename format . But I am only getting this yyyymmddhhmmss_ .

Thanks Jason that worked ,

Now I need in the main query when the parameter Group(X,Y,Z) Say Z is passed then I get the values accordingly for record based...

I am trying to do this in my inline query in the where clause

WHERE

CASE WHEN (ISNULL(ALLPOINT.DateLoaded),(DATEPART(mm,ALLPOINT.DateLoaded)= DATEPART(mm,GETDATE())

ELSE DATEPART(mm,ALLPOINT.DateLoaded)= DATEPART(mm,@DateLoadedBin)

WHERE Am I going wrong ?

GEtting...

=IIF(Parameters!DateLoadedBin.Value=0 OR Parameters!DateLoadedBin.Value Is Nothing,TODAY())

I am using this but not working.

There will be one file once a month at a particular location with the filename as mentioned above.

Thanks it worked perfectly!

I a using the following in the where clause

DATEPART(m, ALLPOINT.dateloaded) = DATEPART(m, GetDate()) AND DATEPART(yyyy, ALLPOINT.dateloaded) = DATEPART(yyyy, GetDate())

but it is not pulling records which are only in the...

Thanks I removed the Declare Statements from my query and just used where Settlementdate Between @StartDate and @EndDate.

Thay worked. Thanks.

Thanks I got that working . But I have another issue . The source table has nvarchar datatypes and the destination has varchar. I tried converting the source to DT_STR...

MERGE DB1.dbo.TEST1 AS TEST1

USING db2.dbo.test2 AS test2

ON TEST1.columA= test2.columA

WHEN MATCHED THEN

UPDATE SET test1.Processor = test2.Processor,

...

The MERGE statement attempted to UPDATE or DELETE the same row more than once. This happens when a target row matches more than one source row. A MERGE statement cannot...

CAn you give an example ?

Mike : It was a typo. I actually meant that.

Michael: Thanks.It worked!