a) different rows via different routes

A conditional split will produce more than one output & you can then perform different tasks on each output e.g. you may use the...

TheSQLGuru (10/27/2009)

---

1) the first poster is incorrect. you CAN get performance increases from partitioning without multiple filegroups - sometimes vast improvements even. This would come from partition elimination...

I do this by right clicking the chart choosing chart properties -> Value Axis Properties & then setting the Minimum to 0 & the Maximum to 100.

Or am I totally...

Right click on the table you want to copy in management Studio choose "Script Table As" -> "Create To" -> "Clipboard"

Make a connection to the server you want to copy...

OK - so log shipping copies (ships) transaction Logs from one server to another. The error is telling you that there are no transaction logs to copy on the source...

1) Is it possible to send multiple columns out put from conditional split

The Conditional Split will pass all columns through - it just sends different rows via different routes.

2)...

Hmm - well that's a bit more difficult. I use Configuration files a lot but I use XML ones. Typically I would run the same package multiple times from a...

It does seem to be straight after it goes into single user mode something else beats the SPROC to the single connection but I like the idea of a TRY...

I see where you a re coming from in disabling TCPIP but that's a step too far for me & it would affect other databases as well....

Sproc is in the same database (AttendaDW) which is what makes in so damn annoying!! the next statement in the SPROC should just hop onto the connection & away I...

How about this? Set up 2 connection managers for the flat flat file one for " the other for ^ delimiter.

Then enable package configurtaions from the SSIS menu -> package...

Yep - this is exactly what I am doing

ALTER DATABASE AttendaDW

SET SINGLE_USER

WITH ROLLBACK IMMEDIATE

DECLARE @FGName varchar(50)

DECLARE @sqlvarchar(200)

DECLARE FG_cursor CURSOR FOR

SELECT FileGroupName FROM maintenance.getRequiredOldFGs

OPEN FG_cursor

FETCH NEXT FROM FG_cursor INTO...

Hi - I think you need to pass the data from the Flat file source straight into the lookup, then compare each row, any rows which match are the same...

You could use a script component & use a few lines of VB to convert the date, e.g. something like this??

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)

Dim strDate=Row.MyDate...

Hi - I would set up my your query like this in the Data source of the data flow (assuming an oleDB source)

SELECT PaidWeight =

CASE

WHEN M.Weight = '0' THEN ?

ELSE...