Viewing 15 posts - 9,316 through 9,330 (of 13,882 total)
The complexity of the problem means that a derived column solution is unlikely to be practical.
A Script Component would allow you to write code with as much complexity as you...
April 13, 2014 at 4:38 am
Resender (4/11/2014)
Phil Parkin (4/11/2014)
What exactly are you changing when you 'change to Unicode type'?I go into the advanced editor and change the datatype of the column
Can you post the error...
April 11, 2014 at 8:52 am
Resender (4/11/2014)
I got a series of databases that have...
April 11, 2014 at 8:19 am
From this I understand that the package format is upgraded - does it mean that the package (& functionality contained) will not run against 2008 when using the dtexec command...
April 10, 2014 at 5:44 am
peter 89731 (4/10/2014)
The company I am working for has a 2008r2 server and packages developed using bids 2008. They are also using TFS, and because of some of the...
April 10, 2014 at 4:07 am
KoldCoffee (4/9/2014)
Ooooh, I didn't interpret the lower case f's as intended 😉
..along with >99% of others, I would guess 😀
Phil, you're really a great resource on these forums and have...
April 10, 2014 at 2:29 am
And regardless of where those servers are, you can still get rid of SORT components if you decide to keep the Merge Joins.
April 10, 2014 at 2:27 am
sqlbuddy123 (4/9/2014)
This error usually occurs due to an out-of-memory condition.
Check if you are experiencing any memory problems and errors ..
--
SQLBuddy
Note also that SSIS may do some caching to the...
April 9, 2014 at 11:33 pm
KoldCoffee (4/9/2014)
April 9, 2014 at 10:27 am
As long as your data volumes are low and it works ...
But otherwise you should consider doing ALL sorting at source and then just setting the IsSorted property preceding...
April 9, 2014 at 6:00 am
KoldCoffee (4/9/2014)
In the Flat File Connection Manager Editor (r-click and select Edit on the Connection Manager itself, not the Flat File Source Data...
April 9, 2014 at 5:51 am
Megha P (4/9/2014)
Data sources are SQL command likeselect * from Mst_From_Email where Company_ID = 1 and active = 1
Then do the entire source selection in T-SQL.
April 9, 2014 at 3:38 am
What are the data sources?
The advanced editor does not 'do sorting' - for that you need a SORT transformation. And these are slow - better to sort at source if...
April 9, 2014 at 2:47 am
ssis2008r2 (4/8/2014)
Just wanted to know if SQL Server Agent can run in standby mode.
You mean while the computer is powered down? As far as I know, pretty much nothing at...
April 9, 2014 at 12:18 am
a4apple (4/8/2014)
April 9, 2014 at 12:13 am
Viewing 15 posts - 9,316 through 9,330 (of 13,882 total)