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.

Is it possible to script multiple queries?  I need to transfer about 30 queries from one server to another w/o copying the entire database.  I was hoping i wouldn't...

Are you using SQL Agent job to do this?

If so, it's likely that the SQL Agent user does not have the necessary rights to create the file.

Or, if the file...

Note also that it is good practice to

a) Explicitly name the columns you are INSERTing to

b) Avoid SELECT * (unless the number of columns and their names has no effect...

You have stated your requirement, but what is your question? What have you tried and what were the results?