Viewing 15 posts - 8,551 through 8,565 (of 11,678 total)
ChrisM@home (12/13/2011)
Quick today, Koen :hehe:
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...
December 13, 2011 at 3:59 am
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...
December 13, 2011 at 3:56 am
duggal.priyanka06 (12/13/2011)
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...
December 13, 2011 at 3:55 am
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...
December 13, 2011 at 3:46 am
What if you don't put double quotes around \Package.Variables[User::MainPath].Value?
December 13, 2011 at 3:15 am
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,...
December 13, 2011 at 2:59 am
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?
December 13, 2011 at 2:57 am
arkiboys (12/13/2011)
1- I removed the value in the MainPath variable of the package and renamed the pckageconfiguration...
December 13, 2011 at 2:54 am
arkiboys (12/13/2011)
I did but then I disabled it.Still seems the package is looking at the folder path which is set in the package variable.
Take a copy of your package, delete...
December 13, 2011 at 2:35 am
Can do what in a script component?
Here's a starting point:
December 13, 2011 at 1:30 am
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...
December 13, 2011 at 1:08 am
SQL Kiwi (12/12/2011)
Wayne's LAST_VALUE bug has been updated (it will be fixed for RTM).
Great. I haven't looked at that new feature yet.
Is it comparable with KEEP FIRST/LAST in Oracle?
December 13, 2011 at 12:08 am
Do you have package configurations enabled on the variable MainPath?
December 12, 2011 at 11:56 pm
Bit of a trick question - as it has nothing to do with sorting - but learned something. Thanks.
December 12, 2011 at 11:46 pm
Viewing 15 posts - 8,551 through 8,565 (of 11,678 total)