Instead of

SELECT cols

...

Try

SELECT DISTINCT cols

...

Does that help?

Use @@SERVERNAME?

Use

SELECT ItemNo = ISNULL(ItemNo,0)

Here is the general pattern for a MERGE...

• This reply was modified 6 years, 3 months ago by Phil Parkin.

If you want your comparison to be bulletproof, you need...

Your expression NULL(DT_DATE) is returning the 1899 date always. You cannot change it, unless you change the expression to return something else.

Same result, confirmed.

The packages are located on a shared folder in the server which all team members has access to . We are trying to open these packages from the server...

Hi,

Can you please give me Idea, how can i use stored procedure in SSIS with different database name in Dev, Test and Prod ?

In stored procedure, I am going...

What does "I am unable to open those packages from the server" mean? What are you doing? What are the errors you're getting? You need to describe the problem,...

Are you attempting to write multiple files, or multiple sheets in the same file?

I think so! If you try plugging a string containing a triple space into my example above, you will see that it gets condensed...

Oh no it isn't. TRIM() is the equivalent of LTRIM(RTRIM()) and thus removes leading and...

I'm assuming that SSIS does not consider what happened to be an error ... otherwise, by default, your package would fail.

Assuming this package is deployed to SSISDB, please check the...

Right-click on the database in SSMS Object Explorer.

Select Tasks/Generate Scripts

Select Views and follow the prompts.