I do my best 🙂

But you make an excellent point as well. Using the DATE datatype allows you to write easier queries with BETWEEN and you...

What if you delete those 5 packages you don't need and then run the Manifest file?

Or you can script out the deployment using DTUTIL, or even easier, use BIDSHelper to...

duggal.priyanka06 (12/13/2011)

---

Hi,

I have the following query where @User::Cob_Dt is a variable giving me the previous business day.The

following gives me day of a month i.e. 2011-12-31 00:00:00.000

declare @cob_dt...

According to MSDN, the SET option only doesn't work if values are set by a configuration.

http://msdn.microsoft.com/en-us/library/ms141682.aspx

So you are still doing something wrong somewhere.

Change the design time value for mainPath folder...

What if you don't put double quotes around \Package.Variables[User::MainPath].Value?

Clicking on 'Start Debugging' or right-clicking on a package and selecting "Execute Package" will result in the configuration file being used.

However, if you select a task/container and choose Execute Task/Container,...

Can you give a little more explanation?

I don't know all possible properties of SSIS out of my head, so where does the MessageSource property come from?

arkiboys (12/13/2011)

---

I did what you suggested and difinitely my set statement does not work because:

1- I removed the value in the MainPath variable of the package and renamed the pckageconfiguration...

Take a copy of your package, delete...

Can do what in a script component?

Here's a starting point:

http://msdn.microsoft.com/en-us/library/ms136114.aspx

The usual questions:

* are there NULL values in your data?

* do all the rows contain string data of the same structure?

The FINDSTRING function implicetly converts the data to unicode. Could...

Great. I haven't looked at that new feature yet.

Is it comparable with KEEP FIRST/LAST in Oracle?

Take a look at this thread:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ec5a4654-ada2-4974-8140-529cfb8153c8/

😉

Do you have package configurations enabled on the variable MainPath?

Bit of a trick question - as it has nothing to do with sorting - but learned something. Thanks.